How to fix OBIEE 11g: Error nQSError 46029 -Failed to load the DLL | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

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

About Sandeep Venu

    Blogger Comment
    Facebook Comment

0 comments:

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands