Skip to Content

Query script generation failed. See your administrator. Specified RDBMS is invalid

I use BI 4.2 sp 4.

When I try to make a new webi report with universe connected to SAP BI Platform CMS system database as data sources,

the following error message is displayed.

"Query Script generation failed. See your BusinessObjects administrator. Specified RDBMS is invalid : SAP BI platform CMS system database"

I use the universe that Downloaded “BIRA-RTM-423002-UnxSample.lcmbiar” from the folder BI-on-BI.

Needs help.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 18 at 03:04 PM

    Have you checked the universe in IDT and tested the connection there ?

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 02:30 PM

    Have you upgrade from a lower patch to BI4.2 SP4? If yes, there might be a chance that the driver are not installed properly or not installed at all.

    As workaround you can try the following:

    Copy following files/folders from a working environment to the non-working environment (both should be of same patch)-
    ..\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\setup\cms.setup
    ..\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\cms\*.*
    ..\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\java\dbd_sapbicms.jar
    ..\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\java\dbd_sap_java_drivers_sdk
    Restart all the services/nodes

    Add comment
    10|10000 characters needed characters exceeded