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

Symptom

Database connection in Desktop Intelligence document remains while oracle client changes connection server to another.

Environment

• BusinessObjects Enterprise XI 3.1 Server Pack 3
• Oracle 10.2
• Desktop Intelligence document (DeskI)

Reproducing the Issue

1. Prepare two Oracle servers on two environments separately.
2. Create Oracle users with same user name and rights on two separate oracle server.
3. Create tables with same table name on both Oracle database servers.
4. Insert different data into tables on two Oracle database server 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. Create new Desktop Intelligence document (via InfoView or client tool) based on the universe created on step 6. 
8. Change database server IP address from server 1 to server 2 in "tnsnames.ora" file on BOE server.
9. Refresh DeskI report and check the data doesn't get updated at all.

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 under steps below:

1. Close DeskI document and client tool.
2. Reopen the document.
3. Refresh the document and check data to be updated.

See Also

1540204 - Database connection in Web 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:22:29
Release Status	Released to Customer
Component	BI-RA-DKI Desktop Intelligence
Priority	Normal
Category	Problem