Unfortunately, Informatica will not provide any metadata update query to perform the checkin/checkout as it might cause metadata inconsistency.
In a versioned repository, multiple objects can be validated/checked-in-out using queries option in the repository manager.
Hope this helps.
Currently there is no option for mass check-in or undo checkout. This needs to be done for each object.
The piece of code which is responsible for creating the versions of the objects work for specific versions and cannot be applicable for all the objects for better integrity.
And, this cannot be achieved using a SQL query from the backend as it is highly likely to create inconsistencies. Moreover, the query changes depending on the dependent objects of the workflow or mapping which makes it really difficult to frame the queries.
Hence, it is not recommended to make any changes to the objects from the backend which can corrupt the repository.
We understand that check-in or undo checkout for the specific objects from the client is a tedious process; but this is the only best available option which is verified.
Hope this helps.
There are pmrep commands to find checkouts , check-in, undo-checkout. I would suggest to create a shell script with pmrep commands to automate this process.
Find list of checked out objects
use pmrep commands to check-in/out
Loop through till all the objects are checked-in
Thank you Nagaraju for providing a solution! Does the pmrep command let you do the bulk check-in or undo-checkout? Also, I want to be very specific about the criteria that to be used for check-in or undo check-out. Can you provide the specific criteria in pmrep command?
Thank you Rajan for the clarification! Can we do the same using pmrep command as suggested by Nagaraju? It would be a great help.
1 of 1 people found this helpful
The only option is to use pmrep commands in a script to loop thru the object list and execute checkin or undocheckout as the case may be.
You need to be careful with undo check-out.
It might be the case the checked-out objects are deletes which were never checked in.You don't see them as checked out objects in the navigator of Designer, Workflow Manager or Repository Manager.
So my suggestion would be checking visually your repository folders for checked-out objects, decide what to do with it and afterwards run the query Find Checkouts and check in all remaining objects.
Hi Rex, I would suggest to write shell script where you can find list of checked-out objects with pmrep command and loop through the list and check-in if they meet your criteria. But you should be able to determine the criteria in an automated way in the script. Otherwise you can not automate this process as you have to validate visually and decide for check-in/checkout.