Report failed on open database connection in Business Objects XI R2

[Former Member]

Hi,

After installing Business Object Xi R2, I tested the report in CMC

The Error displays,

"The report failed to open database connection (oracle)" in Business Objects Enterprise.

I checked tnsnames.ora, it works fine, installed MSDAC 2.8 as well and also I created a universe and created a report in Desktop Intelligence.

am I doing something wrong? Any suggestions.

[Former Member · Accepted solution]

Hi;

make sure the Oracle environment settings are set up BOBJ server side, env variables (ORACLE_HOME particularly) etc... after setting this up, restart the WIReportServer(s).

Regards;

Lionel

[Former Member]

I resolved the issue. Actually few reports are DSN