Skip to Content

This blog outlines how to resolve error Specified RDBMS is invalid : sap bi platform cms system database (error: inf ) while changing report data source from UNV to UNX

System Update: SAP BI platform updated from version 4.1 SPx to 4.2 SP4 and above.

Scenario: Refer to SAP knowledge base #2432962 for detailed process of automating change of report data source from UNV to UNX. Below are the steps mentioned to resolve an specific error occured while running WebIChangeSource_Worklist document.

Error Message:

  • Specified RDBMS is invalid : sap bi platform cms system database (error: inf )

As per KB 2432962 Download following files:

  • lcmbiar
  • BI42_SAP_WebiChangeSourceDriver

 

Follow below mentioned steps:

  1. Extract SAPWebIChangeSourceDriver.zip
  2. Simple copy files from SAPWebIChangeSourceDriver.zip to Install drive\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer
  • Drivers
  • Sap_wics
  • setup
  1. Restart SIA and wait for SIA to be up and running
  2. Login to Promotion Management and Import lcmbiar
  3. Once biar file is imported. Login to BI Launcpad, Go to BI Admin folder and try to run WebIChangeSource_Worklist document.
  4. You will get following error message
    • Specified RDBMS is invalid : sap bi platform cms system database (error: inf )
  5. Reason for error is missing CMS DB Driver. Follow following steps to install missing driver.
    1. Go to Control Panel -> Programs ->Programs and Features.
    2. Select the base BI platform installation. i.e. SAP BusinessObjects BI Platform 4.1Note: DON’T select 4.2 update.
    3. Click on Uninstall/Change.
    4. Click Modify
    5. Select Database Access-> CMS DB Driver to install.
    6. Click Next…and follow steps until installation completes. This process will take around 30mins+
    7. Restart Server.
  1. Once driver is installed you should be able to execute WebIChangeSource_Worklist document.
  2. Continue following three main steps to apply the Mass UNV to UNX change data source. These steps are mentioned in detail on SAP Notes 2432962.
    1. Preparing Universe List: Define mapping information about the universes (UNV) which have been converted to UNX.
    2. Preparing Document List: Define the list of documents where you want to change the data source.
    3. Executing Change: Data Source Using the lists from the previous steps
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply