Product: SAP BusinessObjects Enterprise XI 12.1.0
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.)