Database access error. Reason Loading shared object failed

User might receive below error during Business Objects(Boxi ) or Data services installation when using Oracle as database.

Error
An error has occurred.

Database access error. Reason Loading shared object failed. First tried to load library clntsh and failed because of error: . Second tried to load library libclntsh.so and failed because of error: .
(FWB 00090)

The system cannot verify the database logon information. That means the path might not be correct.

User will receive this error when below environment variables are not set properly.

1. The environment variable "LD_LIBRARY_PATH" is not set.
2. environment variable for ORACLE client is not setup properly
3. the user where you are running the BOXI install not able to tnsping to the listener service

Resolution

Make sure you set the below library paths in .profile of the user by which Business objects is installed

• ORACLE_HOME=<Oracle client home path>
• LD_LIBRARY_PATH=<$ORACLE_HOME/lib>

Note : ORACLE_HOME may be set also in the bash_profile. After setting variables, tomcat should be restarted.

Regards,
Satishbabu Gunukula, Oracle ACE

License key not valid INS00140 in Unix

You might encounter below error during the installation of Business Objects (BODS/BOBJ), Data Services  install will stop

License key not valid INS00140 in Unix

Cause

A library is missing

Resolution

Use strace or ldd to find what library is missing.

strace -ff -v isKeycodeValid

Note: Using strace, you can watch something similar like this: 10isKeycodeValid: error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory.

If using ldd

Run ldd on /usr/dlc/odbc/lib/pgoe1023.so to ensure all dependencies are found.

Find out which library is missing , in my case  libstdc++.so.6 would be the library that is missing.

Installed the library using below command

sudo yum install libstdc++.so.6

Rerun the install and install working fine.

Regards

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com

[01000][unixODBC][Driver Manager]Can't open lib…file not found

I have installed a new BOXI system and working on unixODBC configuration to connect to Microsoft SQLServer Database and received below error message

$ isql -v test_ds test_username test_password

[01000][unixODBC][Driver Manager]Can't open lib '/u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/ odbc/7.0.1/lib/CRsqls26.so' : file not found

[ISQL]ERROR: Could not SQLConnect

First I thought the issue with invalid patch and I have corrected the issue but I still see same error

It looks like LD_LIBRARY_PATH was not updated properly, which might be reason it’s not able to find the library. I have updated the updated LD_LIBRARY_PATH and I was able to connect successfully.

In some cases you will see the same error, if all dependent libraries are not installed. Run “ldd on the library /u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/CRsqls24.so to ensure all dependencies are found. If something not found in below output then required PRM’s or soft links are missing.

$ ldd /u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/CRsqls24.so
linux-vdso.so.1 => (0x00007ffd43be6000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc9cf77e000)
librt.so.1 => /lib64/librt.so.1 (0x00007fc9cf575000)
libCRicu26.so => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/libCRicu26.so (0x00007fc9ce67e000)
libodbcinst.so => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/libodbcinst.so (0x00007fc9ce45a000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fc9ce255000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fc9cdf4f000)
libm.so.6 => /lib64/libm.so.6 (0x00007fc9cdccb000)
libc.so.6 => /lib64/libc.so.6 (0x00007fc9cd936000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fc9cd720000)
/lib64/ld-linux-x86-64.so.2 (0x0000003ebc200000)

Regards ,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Failed to get connections for connection [http://hostname:8000] using session locale [English]

Failed to get connections for connection [http://hostname:8000] using session locale [English].

I was trying to create a OLAP connection from CMC to HANA in BOXI4.1 SP6 for Analysis Office 2.x SSO setup and receive below error. All the server details verified and everything seems to be correct.

After doing some investigation I found that the issue is due to limitation in BI platform4.1 sp06 or lower.

It cannot able to connect to HANA in CMC because there is no data provider available.

Errors in MDAS log file
Creating a BICS application with alias [session-2:http://hostname:8000:dev:en_US:HTTP:CREDENTIALS:null]
JCoDestinationDataProvider adding destination session-2:http://hostname:8000:dev:en_US:HTTP:CREDENTIALS:null.
JCoDestinationDataProvider setting jco.destination.pool_capacity property to 0 because it was not specified. <exception> com.sap.ip.bi.base.service.connection.impl.ConnectionException: No connection factory found for type session-2:http://hostname:8000:dev:en_US:HTTP:CREDENTIALS:null/HTTP.
Possible Solution: Upgrade to BI 4.1 SP07 or higher then you should be able to connect using HTTP provider.

Refer below SAP Note for more info
2182585 - Cannot connect to the Hana via SAP Hana Http OLAP connection in CMC

Regards

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com

Database error : (CS) "Java Class not found in classpath : com.mysql.jdbc.Driver"(WIS 10901)

The users will see below error if they don’t configure JDBC connection properly to connect MYSQL database.

Database error : (CS) "Java Class not found in classpath : com.mysql.jdbc.Driver" . (WIS 10901)

Follow below troubleshooting steps

1. Locate jdbc.sbo file and make sure that you have added “ClassPath” with correct MySQL Connector jar file.

<ClassPath>
<Path>/home/boxi/ bobj/enterprise_xi40/dataAccess/connectionServer/jdbc/mysql-connector-java-5.1.25-bin.jar</Path>
</ClassPath>

2. Update environment variable CLASSPATH with correct jar file path.

3. Make sure that the MySQL Connector jar file is right version, means for 64bit O/S or app use 64bit jar file.

Common Error in ODBC:- 

1. The below error message is very common when using ODBC(.odbc.ini) connection

[01000][unixODBC][Driver Manager]Can't open lib '/home/boxi/bobj/enterprise_xi40/linux_x64/odbc/lib/libmyodbc5a.so' : /home/boxi/bobj/enterprise_xi40/linux_x64/odbc/lib/libmyodbc5a.so: wrong ELF class: ELFCLASS32

Cause: The file is not the right version

Possible Solution: The file is not 64-bits version of the libmyodbc5a.so, install the right version. Use 32bit version of the libmyodbc5a.so, if using 32bit.

Download MySQL Connector/ODBC

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com 

cannot open shared object file: No such file or directory

This is very generic error and you will see this error with many situations.

I have received this error when connecting to Mysql using isql

$ isql -v MySQL test_user testpass
[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libmyodbc.so' : /usr/lib/libmyodbc.so: cannot open shared object file: No such file or directory
[ISQL]ERROR: Could not SQLConnect 

Cause: The Mysql cannot find the required library

Possible Solution: Locate the file libmyodbc.so, if you don’t find the file then you might be using a different version. Find the lib file that you are using ‘libmyodbc*’ and create a link.

     For ex:- ln –s <Path to file> < Link Name>
     $ ln –s /home/mysql/lib/libmyodbc3-3.51.07.so /usr/lib/libmyodbc.so

In many causes users will see this error, if they don’t include the library path in LD_LIBRARY_PATH

Users might receive below error, when connecting using “odbcinst”. This is also one of the common error.

$ odbcinst –q -s
odbcinst: SQLGetPrivateProfileString failed with . 

Cause: The environment variables are not set properly

Solution: For Linux, edit .bash_profile and add following environment variables 

export ODBCSYSINI=/etc
export ODBCINI=/etc/odbc.ini

In caseof CSH,

setenv ODBCSYSINI /etc
setenv ODBCINI /etc/odbc.ini

Reference:

Configure a Connector/ODBC DNS on Unix
Problems with connecting other platforms to MySQL with ODBC
Download MySQL Connector/ODBC

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com