Unexpected database used by universe

[Former Member]

Product: SAP BusinessObjects Enterprise XI 12.1.0

Database: Oracle

Web Server: WebLogic

Hello,

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.)

Sincerely,

MB

[Former Member · Accepted solution]

Hi Maxime,

If its a Windows server then can you check hosts file in C:\WINDOWS\system32\drivers\etc location.

Open the hosts file and check if any entry of HOST_A and HOST_B are made with any specific IP address. Also make sure if entries are made then it should be with correct IP address.

To verify if your BO server pointing to correct DB server, you can utilize tnsping and ping on command promtp to see if both of them returns correct IP address.

Last thing to try would be recreate or copy tnsnames.ora from server, to eliminate possibility of file corruption.

Please try this and let us know.

Note: Before trying above steps, please take proper backup of files. So in case of any problem, you can restore them quickly.

[former_member188911]

I am not surprised, the official recommendation is to use the ip address rather than the host name

thanks

Simone