Skip to Content
1

"Report Processing Failed (XLS 000009) Specified RDMS is invalid"

Apr 12 at 04:12 AM

16

avatar image

Hello,

We're facing the below issue after new installations of Dashboard Designers on Client Desktops, on creating new Dashboards based on universes.

Error: "Report Processing Failed (XLS 000009) Specified RDMS is invalid"

- We get this error on all the universes even Efashion.

- Our universes are typically based on MS SQL Server but seeing with Oracle as well.

- Getting this error while connecting to all 5 environments we have Sandbox, Dev, Test, Prod.

- Testing Server middleware from IDT installed on the same client machine is successful.

- Creating Webi reports or refreshing from same universes is successful from WRC.

- Refreshing Webi reports from CMC and BI LPD is successful for the same universes.

- Tried the JNI settings mentioned in KBA 2170900 in Sandbox env, but still seeing the same issue.

- 64 and 32 bit ODBCs exists on the server machines.

Environment details:

- BI 4.2 SP03 Patch5

- Windows Servers

- All universes

Please suggest any solutions for this issue.

I also have the below queries, in case anyone can help answer them:

1. Can Dashboards also use UNV universe?

2. Dashboards Designer requires 64 bit ODBC connection on the client desktop or the server machine?

3. What kind of tracing can be enabled to log this issue?

Please suggest!

Thanks in advance!

Regards, Vaidehi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

VAIDEHI PIMPLE Apr 12 at 07:55 AM
0

The workflow we are using is:

Dashboard designer -> Log in to the BI Platform -> Query builder -> Add Query -> Universe-> Select universe -> Get error.

Regards,

Vaidehi

Share
10 |10000 characters needed characters left characters exceeded