DBDriver failed to load in Ad Hoc report

Products

• CA Spectrum

Issue/Introduction

The steps outlined in the "Generating Ad Hoc Reports" section of the documentation to configure the CABI 4.1 SP3 in Linux to generate Ad Hoc reports were followed but the following error is seen when trying to generate an Ad Hoc reports:

java.util.concurrent.ExecutionException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Database error: [unixODBC][Driver Manager]Can't open lib '/usr/local/lib64/libmyodbc5w.so' : file not found. (IES 10901)

Environment

Spectrum integrated with CABI 4.1 SP3 on Linux

Cause

The MySQL driver file name placed in /usr/local/lib64 does not match with the name in the <CABI install directory>/sap_bobje/enterprise_xi40/odbc.ini file.

Resolution

Edit the odbc.ini file and replace with the correct MySQL drive file name as follows:

1. Edit the <CABI install directory>/sap_bobje/enterprise_xi40/odbc.ini file

2. Locate the following entry:

Driver=/usr/local/lib64/libmyodbc5w.so 

3. Change to:

Driver=/usr/local/lib64/libmyodbc5.so

4. Save the file.

5. Restart all servers from SIA using stopservers and startservers command.