Trying to import tables from Database and running into this error:
(Failed to load the DLL C:\OracleBI\server\Bin\nqsdbgatewayoci10g.dll. Check if ‘Oracle OCI 10G’ database client is installed)
Tried to incorporate the client path into the environment variables and still no luck.
Need some assistance......thanks!
Its Oracle Doc ID 1215723.1, you need Oracle support login to check that.
You need to have give privileges (using Administrator->Manage Privileges )to end users create/edit/publish
and then 'Add Folders' from BI Pub using Admin>Roles and Permissions
If helps pls mark
Hope all is well with other post as per last night :)
Edited by: Srini VEERAVALLI on Jan 7, 2013 3:09 PM
Still having issue with nQSError: . I am able to establish an ODBC connection, allowing me to connect to the BI server. The client tools that I have (10.1.3.4.1) were the only tools that Oracle could offer me. When I go into the RPD and try to view data from a physical column I still get "Failed to load the DLL C:\OracleBIServer|Bin\nqsdbgatewayoci10g.dll. Check if 'Oracle OCI 10G' database client is installed." I have contacted Oracle Support and the only help they have given me is a download for an 11G client. I am working with 10G, and they are of no help. I need to import tables, and need help now. I am working through VPN directly into clients database.
From the Document 1215723.1 I read this "OBIEE 10.1.3.4 is compatible with the 11g client as per the following bookshelf document" so I downloaded the 11G client and now I'm getting Login failed due to nQSError 43090 Server version (10.1.3.4.1 090414.1900) is incompatible with the client. The client protocol version range is 12 - 12. Server range is 6 - 6. nQSError 37001 Could not connect to the Oracle BI Server Instance.