Sitemap

Amicuk Programming Answers

Failed to load database information in Crystal 2011 using DB2 connection

2015-10-11   Views:8

Advertisement

Hello, we have a Problem using Crystal Reports 2011 on SAP SBOP 4.0 SP2 Patch 10. BI 4.0 Server is running on AIX. The Datasource is an DB2 database a connect from the OS is possible. The x32 libarys of the DB2 client are availabe because the crystal

Hello,
we have a Problem using Crystal Reports 2011 on SAP SBOP 4.0 SP2 Patch 10.
BI 4.0 Server is running on AIX. The Datasource is an DB2 database a connect from the OS is possible.
The x32 libarys of the DB2 client are availabe because the crystal 2011 reports server is running with 32 bit environment.
While opening / executing the crystal 2011 report the following error occur: "failed to load database information".
I've made a trace of crystal 2011 server with crlog. I found the following:
2012-1-27-7-17-33       9371804 searchpath.cpp  379     Failed to load libcrdb_db2cli.so        1
2012-1-27-7-17-33       9371804 qecommon.cpp    117     This value is write-only. File Name: "QEProperty.cpp". Line: 145       
2012-1-31-13-8-23       9371804 QESession.cpp   445     Set Product View Locale: 1033   20
2012-1-31-13-8-23       9371804 QESession.cpp   479     Set Preferred View Locale: 1033 20
2012-1-31-13-8-23       9371804 QESession.cpp   501     Set Process Locale: 1033        20
2012-1-31-13-8-23       9371804 qecommon.cpp    117     This property is currently in a read-only state and cannot be modified. File Name: "QEProperty.cpp".
An ldd on the operating system says all libarys are availabe:
bash-3.2$ ldd /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/crpe/libcrdb_db2cli.so
/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/crpe/libcrdb_db2cli.so needs:
         /usr/lib/libC.a(shr2.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libetc.so
         /usr/lib/libC.a(ansi_32.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libBCM.so
         /usr/lib/libC.a(shr.o)
         /usr/lib/libC.a(shr3.o)
         /usr/lib/libc_r.a(shr.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libcxlibw.so
         /usr/lib/libpthreads.a(shr_xpg5.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libOCAhelperw.so
         /home/boeadm/sqllib/lib32/libdb2.a(shr.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libsatlw.so
         /usr/lib/libC.a(shrcore.o)
         /usr/lib/libC.a(ansicore_32.o)
         /usr/lib/libpthread.a(shr_comm.o)
         /usr/lib/libpthread.a(shr_xpg5.o)
         /usr/lib/libC_r.a(ansi_32.o)
         /usr/lib/librtl.a(shr.o)
         /usr/lib/libc.a(shr.o)
         /unix
         /usr/lib/libcrypt.a(shr.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libTraceLog.so
         /usr/lib/libiconv.a(shr4.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libicuuc.so
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libicui18n.so
         /usr/lib/libdl.a(shr.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libboez.so
         /usr/lib/libpthreads.a(shr_comm.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libebus.so
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libfssl.so
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/liblocale_fallback.so
         /home/boeadm/sqllib/lib32/libdb2osse.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2locale.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2g11n.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2osse_db2.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2genreg.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2install.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2trcapi.a(shr.o)
         /home/boeadm/sqllib/lib32/libdb2dascmn.a(shr.o)
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libicudata30.so
         /usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/libicuuc30.so
bash-3.2$
Does somebody have an idea where to search to get a solution for this error?
PS: With Crystal for Enterprise 4.0 everything works fine, but the Crystal for Enterprise 4.0 services are running with 64 bit.

The replay answer
Advertisement
Hello All,
the Problem has been found by SAP. The Business Objects Server is searching for an env variable called LIBPATH32.
By default this has not been set to the DB2 x32 Libary path by AIX or SBOP setup.
We solved the issue by adding the following (LIBPATH32) into the file .profile
The following three lines have been added by IBM DB2 instance utilities.
if [ -f /home/boeadm/sqllib/db2profile ]; then
    . /home/boeadm/sqllib/db2profile
    LIBPATH32=/home/boeadm/sqllib/lib32:$LIBPATH32; export LIBPATH32
fi
After doing:
bash-3.2$ cd /usr/sbop/sap_bobj/
bash-3.2$ . setup/env.sh
The path has been set correctly to the x32 libarys:
LIBPATH32=/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/:/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/crpe/:/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/crpe/mw/:/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/ras:/home/boeadm/sqllib/lib32::/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/crpe/mw//lib-aix4:/usr/sbop/sap_bobj/enterprise_xi40/aix_rs6000/crpe/mw//lib-aix4_optimized
Kind regards
Marc Reiter

Go to See the other 6 answers

Failed to load database information in Crystal 2011 using DB2 connection

Category:DefaultRelease time:2015-10-11Views:130

Hello, we have a Problem using Crystal Reports 2011 on SAP SBOP 4.0 SP2 Patch 10. BI 4.0 Server is running on AIX. The Datasource is an DB2 database a connect from the OS is possible. The x32 libarys of the DB2 client are availabe because the crystal[More]

Linux - Oracle - Crystal Report Server XI : Error in File Report1: Failed to load database information.

Category:DefaultRelease time:2015-10-11Views:130

I am using Crystal Reports Server XI on Linux Server with Oracle Server 10g. I did install Oracle Client on Report Server and config Oracle SID in tnsnames.ora also. It works well with tnsping command. Then, I published a report which was created in[More]

Crystal Reports exception: "failed to load database information" error in file guid.rpt file

Category:DefaultRelease time:2015-10-11Views:130

Please also see attachment (same info as below). Background This code works in windows XP (32 bit), using/complied VS2005 with no problems. Please contact: Hamid Deljoo at work 416-867-8977 (8am to 4pm EST) Problem is: We are migrating this code from[More]

Failed to load database information. Error in File temp_

Category:DefaultRelease time:2015-10-11Views:130

Our environment: Windows Server 2012 R2 Data-center Edition 64 bit Visual Studio Pro 2013 Version 12.0.3.30110.00 Update 1 .Net 4.5.51641 Crystal Reports for VS 2013 V13.0.9.1312 Oracle ODAC 11.2.0 We created a winform application to generate a form[More]

Hot
I have an external monitor with only VGA input, and it's resolution is 1680 x 1050. Will my MacBook be capable of using this display at it's native resolution using a mini-DVI to VGA adapter? The display is the HP w2007v in case anyone is interested. [More]
Hi, This one is confusing. Up until today myself and my kids all had ipods and all use one itunes library (mine) for songs etc. This way we all share music. Today I purchased my son a new macbook pro. It is his first computer. I would like him to be [More]
Hi Guys! So I recently purchased a new laptop and downloaded iTunes. Every time I attempt to sign into iTunes using my Apple ID - a error message pops up saying that it cannot connect to the iTunes store as it is unavailable and I should try again la [More]
I have been dealing with several issues over the past few weeks and have been given false information on a number of occasions. I was double billed on my checking account asa  result of this incompetence and the lead to believe I could upgrade my pho [More]
Dear All,               Is there any BAPI available for Planned Progress and Actual Progress for PS Project. Regards, SohailHi, Try using this report s_alr_87013532. Also for planned and actual progress the table is rpsqt. Could not find any bapi for [More]
Hi guys, I have a problem with the check box in the selection screen.When i select a check box then a field in the selection screen should be enabled for entering a value.Again if i unselect the checkbox then the field should be disabled for entering [More]
I would like to understand what is major difference between Dead Locks and Blocking Locks in Oracle. If someone could explain or point me to good web Link I would really appreciate Thanks.Tony's advise is very good. In simple terms a blocking lock is [More]
Hi everyone,,i bought a used iphone 5 with iOs 7.0.3. i want to delete the icloud account and add mine. I have sent an e-mail to the current account being used in my iphone. How can i get rid of this account plzzz help me ouno i called the store owne [More]
I am lazy... well, not really, but I am looking for the lazy way to do this: I have been pretty good about organizing my calendars so that I have a separate one for work, home, social, medical, church, family, and other random types of events. This i [More]
I have a hp officejet pro 7580 and I'm unable to print. I'm unable to communicate with the printer via Mac or PC. I have added the printer again and downloaded a recent update via the PC. I have restarted the ethernet router and the printer, still no [More]