cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to load database information

Former Member

Hi,

When viewing a Crystal report from CMC/Infoview (right click --> view), i get the following error..

Error in File ~tmp7b0393deaddffd0.rpt: Failed to load database information.

ENVIRONMENT:..

BO Server

64 bit

Oracle client 11.1.0-x86-64bit

BOE 4.2 SP2

Reporting Database Server (DB server)

64 bit

Oracle 12c

ENV Variables:

LD_LIBRARY_PATH=/nas/apps/util/oracle/product/11.1.0-x86-64bit/lib

ORACLE_SID=DBOXI

ORACLE_BASE=/nas/apps/util/oracle

ORACLE_HOME=/nas/apps/util/oracle/product/11.1.0-x86-64bit

PATH=/nas/apps/util/oracle/product/11.1.0-x86-64bit/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin

ADDITIONAL INFORMATION:

- I have double checked the 'Database Configuration' into for the report in CMC. All seems ok.

- BO Server is able to successfully connect to DB Server

Any help will be greatly appreciated!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I was able to solve this issue by installing the 32 bit client on the BOXI server and including these env variables.

ORACLE_BASE=/apps/util/oracle

ORACLE_DOC=$ORACLE_HOME/doc

ORACLE_HOME=$ORACLE_BASE/product/11.1.0-x86-64bit

ORACLE_HOME32=$ORACLE_BASE/product/11.2.0-32bit

ORACLE_SID=DBOXI

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME32/lib:$LD_LIBRARY_PATH PATH=$ORACLE_HOME/bin:$ORACLE_HOME32/bin:$PATH

You have to install both first 64 and 32 bit clients on the BOXI server even the crystal report server is on a different machine.

Answers (2)

Answers (2)

0 Kudos

Ah, good thing you post to .NET forums...

I'll move it to Java

0 Kudos

Hello,

CR for VS does not connect to BOE servers so need to know what SDK package you are using?

Is it .NET or Java?

Don

Former Member
0 Kudos

we are using java SDK