How to fix OBIEE 11g: Error nQSError 46029 -Failed to load the DLL

OBIEE 11g: Error: "[nQSError: 46029] Failed to load the DLL /u01/app/oracle/product/11.1/middleware/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewaydb2cli3564.so" after Upgrade to OBIEE 11.1.1.7

You have upgraded OBIEE from 11.1.1.6.0 to 11.1.1.7.0.  When you re-start the services, you get the following error:

[nQSError: 46029] Failed to load the DLL /u01/app/oracle/product/11.1/middleware/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewaydb2cli3564.so. Check if 'DB2 CLI' database client is installed.
libdb2.so.1: cannot open shared object file: No such file or directory

Reason --> The libnqsdbgatewaydb2cli3564.so file not found in the library folder

Update LD_LIBRARY_PATH to include the folders:
/Oracle_BI1/server/bin
/sqllib/lib64 

Make sure all services are stopped using the command:

1. opmnctl stopall
2. Take a back up copy of opmn.xml.
3. Open opmn.xml for editing.
4. Add the following:
5. <ias-component id="coreapplication_obis1" inherit-environment="true">
6. <environment>
7. <variable id="LD_PRELOAD" value="<DB2INSTANCE>/sqllib/lib64/libdb2.so.1"/>
8. Save the changes.
9. Restart the services using the command:
10. opmnctl startall

work with your system administrator to update the profile with the saved environment settings and to remove any repeated or invalid entries.
Remember to set 64-bit libraries instead of 32-bit libraries while using a 64-bit operating system.

Thanks,

Sandeep 

Reference Oracle Doc

SHARE SHARE SHARE

About test