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)
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.
Spectrum integrated with CABI 4.1 SP3 on Linux
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:
3. Change to:
4. Save the file.
5. Restart all servers from SIA using stopservers and startservers command.