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