Skip to Content
Former Member
Aug 09, 2013 at 02:44 PM

Unexpected database used by universe


Product: SAP BusinessObjects Enterprise XI 12.1.0

Database: Oracle

Web Server: WebLogic


I'm facing a really unexpected behaviour from Business Objects and I would need help to figure it out.

A universe is parametered to use connection "CONN_B" which points to service "SERV_B" defined in "tnsnames.ora", pointing itself to host "HOST_B".

Besides, another connection "CONN_A" is defined, related to service "SERV_A" and host "HOST_A".

I don't have access to the history of the universe, but it is likely that in the past it used "CONN_B".

Here is the unexpected behaviour : despite being parametered to use "CONN_B", the universe provides data from "CONN_A".

This was found by comparing data displayed in some reports using this universe. We double checked that by removing either "CONN_A" or "CONN_B" from the "tnsnames.ora" file. In the one hand, the report displayed a TNS error, on the other hand the report ran normally.

We tried a lot of common remedies: restarting everything, reexporting the universe and the report, creating a brand new connection identifier, etc. but none of them did solve the problem.

Do you have any idea?

(This forced us to use a workaround: editing "tnsnames.ora" to make "SERV_A" point to "HOST_B", yuck.)