8 Replies Latest reply on Apr 22, 2021 4:17 AM by Nagaraju Karpurapu

    Automate bulk Check-in or undo Check-out

    Rex Wayne New Member

      Hello Infa Experts,

       

      We're in process to cleaning up our Informatica Power Center repository. I was going through all the repository tables and was wondering if there is a way to update directly the repo tables to do mass check-in or undo-checkout. I'm not sure if that's the best way but we're trying to automate this process instead of doing it manually every time.

       

      Appreciate your help in advance!

       

       

      Thanks,

      Rex 

        • 1. Re: Automate bulk Check-in or undo Check-out
          Seema Yaligar Guru

          Hi Rex,

           

          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.

           

          Thanks,

          Seema

          • 2. Re: Automate bulk Check-in or undo Check-out
            Rajan Rath Guru

            Hello Rex,

             

            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.

             

            Regards,

            Rajan

            • 3. Re: Automate bulk Check-in or undo Check-out
              Nagaraju Karpurapu Active Member

              Hell Rex,

               

              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

               

               

              regards

              Nagaraju

              • 4. Re: Automate bulk Check-in or undo Check-out
                Rex Wayne New Member

                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?

                 

                Thanks,

                Rex

                • 5. Re: Automate bulk Check-in or undo Check-out
                  Rex Wayne New Member

                  Thank you Rajan for the clarification! Can we do the same using pmrep command as suggested by Nagaraju? It would be a great help.

                  • 6. Re: Automate bulk Check-in or undo Check-out
                    user136699 Seasoned Veteran

                    Hello Rex,

                    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.

                    -Girish

                    1 of 1 people found this helpful
                    • 7. Re: Automate bulk Check-in or undo Check-out
                      JanLeendert Wijkhuijs Seasoned Veteran

                      Hi,

                       

                      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.

                      Regards,

                      JanLeendert

                      • 8. Re: Automate bulk Check-in or undo Check-out
                        Nagaraju Karpurapu Active Member

                        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.