nQSError 77005 When Importing Oracle OLAP Cube

最新推荐文章于 2021-04-08 13:48:10 发布

转载最新推荐文章于 2021-04-08 13:48:10 发布 · 1.3k 阅读

BIEE 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个在使用Oracle BI Enterprise Edition客户端工具导入Oracle OLAP立方体时遇到的问题，即收到错误消息[nQSError:77005] An invalid parameter was passed to the nQWebIBot API.dll. 解决方案涉及配置JavaHost，以指向运行在另一台机器上的BIServer。

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.