1540204 - Database connection in Web Intelligence document doesn't get updated even Oracle Client is changed to connect to another Oracle server

Symptom

Database connection in Web Intelligence document doesn't get updated even Oracle Client is changed to connect to another Oracle server

Environment

• BusinessObjects Enterprise XI 3.1 Server Pack 3
• Oracle 10.2
• Web Intelligence document

Reproducing the Issue

1. Prepare two Oracle Servers on two environments separately.
2. Create Oracle users with same user name and rights on the two separate Oracle servers.
3. Create tables with same table name on both Oracle database servers.
4. Insert different data into the tables on the two Oracle database servers respectively.
5. On BusinessObjects Enterprise (BOE) system, create a connection with default settings via oracle client connected to database server 1. ("Connection Pool Mode" should be "Keep the connection active for" by default.)
6. Create a universe with the connection created on step 5.
7. In InfoView, create a Web Intelligence (WebI) document with the universe created on step 6.

• Scenario 1:

1. Change database server IP address from server 1 to server 2 in "tnsnames.ora" file on BOE server.
2. Refresh WebI document and check data doesn't get updated at all.

• Scenario 2:

1. Insert some new rows into the table on database server 1.
2. Change database server IP address from server 1 to server 2 in "tnsnames.ora" file on BOE server.
3. Refresh WebI document and check that data gets updated to Oracle server 1 instead of server 2.

Cause

Database connection used in Universe doesn't get updated after changing Oracle client to connect to another Oracle server.

Resolution

This issue can be resolved by using any of solutions below:

• Wait till "Pool timeout" defined in connection passes.
• Set "Connection Pool Mode" of connection to "Disconnect after each transaction" instead of default "Keep the connection active for".
• Restart Web Intelligence Processing Server.

See Also

1557665 - Database connection in Desktop Intelligence document doesn't get updated even oracle client is changed to connect to another Oracle server

Keywords

Oracle, database, tnsnames.ora, IP address, connection

Header Data

Released On	15.02.2011 09:24:11
Release Status	Released to Customer
Component	BI-RA-WBI Web Intelligence
Priority	Normal
Category	Problem