Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 12 at 07:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded