cancel
Showing results for 
Search instead for 
Did you mean: 

Infoview report error - Database logon information incomplete or incorrect

Former Member
0 Kudos
47

Hi all,

I've just installed Business Objects XI R2 SP2 on AIX 5.3 TL-6. The CMS database is on a different AIX system, also 5.3 TL-6, running IBM DB2 9.1. The Business Objects AIX server has also the IBM DB2 client and the Oracle 10g client installed. The Oracle 10g client is 64bit - I cannot find a 32bit client for AIX. The account that runs all Business Objects processes is using a LIBPATH/LD_LIBRARY_PATH that points to the $ORACLE_HOME/lib32 directory.

We've created a universe and defined the data source for the universe as an Oracle 10g server. The universe was exported to BOE, and it is visible. We created test reports using Crystal Reports XI R2 and these reports work just fine. However, when these reports are saved/exported to Business Objects and made available through Infoview, the reports won't run. I've updated the Database properties for the report objects within CMC, and have tried many different options. However the error seems to surround getting to the database, or the id/password is incorrect.

It seems to me that we cannot communicate to the Oracle database from within CMS/Infoview, but the userid hosting the Business Objects processes can successfully tnsping and sqlplus to this database using the defined tnsnames.ora definition.

I've read through many threads and have tried most of what I've read. If anyone can help with this I'd be eternally gratefeul.

Regards,

Sean Boone

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Sean,

as far as I know you MUST use a 32bit DB client with BO even if the host OS is 64bit. What you may try to do is to use the oracle instant client:

[http://www.oracle.com/technology/tech/oci/instantclient/index.html]

There is a download for AIX 32bit available.

The driver is not officially supported (see Supported Platforms document) but it may work for a simple data connection.

Regards,

Stratos

PS: Have you looked for any directories named like lib32 under your current client installation? It may be the case that the 32bit version is also delivered in the 64bit package.

Former Member
0 Kudos

Good morning,

I resolved this problem by installing BO XI R2 SP4. As we were building a new environment, there was nothing to backup so I simply removed and reinstalled Business Objects. While this did resolve the issue, I'm not sure why.

Once I had SP4 up and running the Oracle connectivity issues disappeared. Since we use a DB2 database for CMS, we didn't need the Oracle Client at install time. I'm wondering if adding the Oracle Client AFTER the Business Objects server was a bad move? Many other applications require all middleware to be installed prior. Could this have had any bearing on this issue?

In response to your question, we didn't try the "Oracle Instant Client", but our DBA instructed me to setup the AIX LPAR's environment to use the $ORACLE_HOME/lib32 libraries explicitly.

Thanks so much for your response.

Sean Boone