Dashboard designer 4.1 client shows Specified RDMS is invalid error for unx universe

[Ganesha]

hi everyone,

we have created dashboard using unx universe based RDBMS Oracle connection, it was working fine, but suddenly now shows following error

"Request processing failed. (XLS 000009) Specified RDBMS is invalid."

(please see error screenshot in attachment)

we used "Add Query" to connect unx universe and now we can't edit the existing queries also and can't add new query,

after select the universe we are getting this error.

Universe working good, we are able to create webi report.

We are using Dashboard Design Tool 4.1 SP2.1

to resolve this issue, any advice please?

Regards,

Ganesh

[Ganesha · Accepted solution]

Hi everyone,

the problem was recently we made changes in dataAccess\connectionServer\cs.cfg

i.e EnableJNI="No"

this change cause the problem, now we reverted the changes, unx - dashboard and unx - explorer works perfectly.

thank you all.

Regards,

Ganesh

[bosegsap]

Hi Ganesh

1)Please try accessing this Dashboard in another PC rather using ur login credentials

2)Try to access the same dashboard in ur pc by logging in using other login(such as ur colleauges credentials

Regards

Bose

[Former Member]

Check your DSN connection.

[former_member194862]

First check if the midlerware you are using is supported.

Then check if the issue is the same if you try to connect to other databases as well.

If so then probably you can give a try to repair BO server.

[Ganesha]

The is no issue with connection or user,

I can able create webi or crystal report using same universe.

the problem with only the dashboard.

[former_member194862]

Hi Ganesh,

Check with other databases as well if you are able to create a dashboard query.

This will help in knowing if the issue is with the middleware.

If it fails with all the databases then check if the classpath on the BO server in environment variables contains any forward slash in the end.

There is a difference in the workflow of webi as here web service too comes in picture.

Regards,

Amit

[srinivasan_vinayagam]

Hi Ganesh,

try this.

Regards,

V Srinivasan

[Ganesha]

Hi Srinivasn,

thanks for the reply, doesn't helps both the thread for my case.

these thread where error occurs after the adding the dimension or issue with APS.

But my case after select the universe, immediately get the error before select any universe object.

Regards,

Ganesh

[srinivasan_vinayagam]

Hi Ganesh,

Please check the Connection and Connection user whether locked or not.

Kindly check the adapt "ADAPT01673874" in attached release note and

grant permission to update latest Support Patch.

https://anibalg.files.wordpress.com/2013/04/sap-businessobjects-business-intelligence-suite-4-0-supp...

Regards,

V Srinivasan

[Ganesha]

Hello Srinivasan,

we are using higher version, i.e  BO4.1 SP2.1, system was working perfectly and now suddenly this issue raised.

The is no issue with connection or user,  I can able create webi or crystal report using same universe.

the problem with only the dashboard.

Regards,

Ganesh