Skip to Content
Author's profile photo Vipin Pillai

LCM CLI Roll back in SAP BusinessObjects Business Intelligence 4.1

The command line option of the promotion management tool allows promoting objects from one BI platform deployment to another, this method is commonly called LCM CLI.(Life Cycle Manager- Command Line Interface).
If for ,whatever reason, we need to rollback the Job that was created and executed by LCM CLI, the Promotion Management Interface does not allow this, as the roll back button is disabled.
See the screenshot below.

When queried the Job in query Builder we can see that Rollback feature is not enabled in Job Properties, as shown:

 

The problem is System defined in Promotion Management -> Manage System and Source System defined in LCM_CLI properties file (lcm_cli.bat -lcmproperty <property file>) is different.

Below is the screenshot of job which was executed

Below is the screenshot of “Promotion Management -> Manage System”

 

Solution:

Need to Define Correct System Name with FQDN in Promotion Management -> Manage System in CMC and need to use same system as Source_CMS in LCM Properties in LCM CLI Tool.

Next time we can rollback irrespective of promotion management or LCM CLI as we can see enabled button in Job Status.

 

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rishi Jain
      Rishi Jain

      Hello Vipin,

      Nice Blog.

      I just have one question :

      1.In Manage system whatever the SOURCE system we are using Need to Define Correct System Name with FQDN in Promotion Management -> Manage System in CMC for Source and even for Destination.
      2.
      Then while creating (Exporting) the BIAR file need to change the Source_CMS in LCM Properties to use same system source system.
      3.
      And when doing the importing of LCMbiar file need to change the Destination_CMS in to use same system as destination system.

      Author's profile photo Vipin Pillai
      Vipin Pillai
      Blog Post Author

      Hi Rishi,

       

      FQDN or HOSTNAME doesn't matter while defining System, thing which matter is You define the system and select the same system while create job from Drop down menu rather than typing it explicitly as the system defined in Manage System would automatically would have a Rollback option in Promotion Management -> Rollback settings.

       

      Regards,

       

      Vipin Pillai

      Author's profile photo Saurabh Mahajan
      Saurabh Mahajan

      Hi Vipin,

      Thank you for your valuable finding on this Roll back option workaround.

      I have tested it with below 3 Scenarios :

      1. Creation of BIAR file through LCM CLI and promoting it through LCM CLI - It worked
      2. Creation of BIAR file through LCM CLI and promoting it through Promotion Management GUI  - It worked.
      However
      3. Creation of BIAR file through Promotion Management GUI and Promoting it through LCM CLI - it did not worked.

      RollBack option is still grayed out in this scenario.

       

      Attached the word document for the results.

       

      Regards,
      Saurabh Mahajan

      Author's profile photo Saurabh Mahajan
      Saurabh Mahajan

      Here are the screen shots for the steps:

      Author's profile photo Vipin Pillai
      Vipin Pillai
      Blog Post Author

      Hi Saurabh ,

       

      Can you Query this Job in Query Builder ?

       

      Regards,

       

      Vipin Pillai

      Author's profile photo Saurabh Mahajan
      Saurabh Mahajan

       

      Hi Vipin,

      Sorry for the late response.

      Yes the Query resulted in below parameter :

      SI-ROLLBACK-Enabled = False

      Refer below:

       

      Regards,
      Saurabh

      Author's profile photo Saurabh Mahajan
      Saurabh Mahajan

       

      Below is the Query:

      select * from ci_appobjects,ci_systemobjects,ci_infoobjects where si_name='LCMRollBackTest1'

      Author's profile photo Vipin Pillai
      Vipin Pillai
      Blog Post Author

      Hi Saurabh ,

       

      I have suspected the same behavior this is because the source system where you have created the bair file irrespective of whether you are creating it using Promotion Management or LCM CLI Tool , you need to make sure the you select the same system which you have defined in "Manage System".

       

      Just to confirm whether whether rollback option is available just query the job in source system where you are creating the bair file.

       

      The query which you have mentioned above is correct.

       

      Regards,

       

      Vipin Pillai