Sunday, September 26, 2010

Failed to load DLL

I installed OBIEE on a new machine and when I tried to update the row count of an existing RPD, I got the following error

The error information was not clear enough, so I tried to connect to the database using sql plus.
I was able to connect with the database.
Then I tried to view the table data through RPD, I got the following error.

"[nQSError: 46029] Failed to load the DLL C:\OracleBI\server\Bin\nqsdbgatewayoci10g.dll. Check if 'Oracle OCI 10G' database client is installed."

The error seems like BI Server was not able to find the Oracle client installed on the system.
I have many Oracle homes, so went and checked the Path variable.
In the path variable , I have the Oracle client’s path was available but it was mentioned last after other Oracle applications path.

So I copied the Oracle client path and past it at the beginnig of the path variable value.

Then I closed the RPD and reopened it and I was able to connect with DB.
So changing the path helped me in solving this issue.

Other related posts