nQSError 77005 When Importing Oracle OLAP Cube

77005 When Importing Oracle OLAP Cube

 

Posted on September 30, 2011 by Paul McGarrick
Filed Under Admin Tool, OBIEE 11g, OBIEE Errors, OLAP

   

I came across an interesting problem today when importing an Oracle OLAP cube using the Administration Tool that comes with the OBIEE 11g Client Tools. The import failed with the error message:

[nQSError: 77005] An invalid parameter was passed to the nQWebIBotAPI.dll. Verify that the Agent configuration is correct.

When you install the client tools it creates a ‘lite’ version of the full server install using may of the same files as the full install. One thing that isn’t present is a JavaHost so it is necessary to point the Admin Tool at a JavaHost running on another machine. To do this I edited:

C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\config\OracleBIServerComponent\coreapplication\NQSConfig.INI

In the [JAVAHOST] section I put:

JAVAHOST_HOSTNAME_OR_IP_ADDRESSES = “x.x.x.x”:9810;

where x.x.x.x is the IP address or fully qualified address of the BI Server.

After restarting the Admin Tool I was able to import the cubes as expected.