OBIEE 11g Client Admin Tool Connection To Datasource In Offline Mode Fails With Error "The Connection Has Failed" (Doc ID 1296370.1)

Last updated on MARCH 07, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.3.0 [1905] and later
Generic Windows
***Checked for relevance on 02-Oct-2013***
***Checked for relevance on 02-Apr-2015***

Symptoms

Created a new repository (RPD) using the Oracle Business Intelligence Enterprise Edition (OBIEE) Admin Tool.  When trying to import data in offline mode, the following error occurs with both ODBC and OCI connection:

Error
The Connection has failed.

You may also notice all or some of the following errors in NQSAdminTool.log:

[2011-02-07T11:26:19.000+00:00] [OracleBIServerComponent] [nQSError: 17003] Oracle gateway error: OCIEnvNlsCreate or OCIEnvInit failed to initialize environment. Please check your Oracle Client installation and make sure the correct version of OCI libraries are in the library path.
...
[2011-02-08T15:42:58.000+00:00] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach
...
]]
[2011-02-08T15:46:08.000+00:00] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12705, message: ORA-12705: Cannot access NLS data files or invalid environment specified at OCI call OCISessionBegin
...

The issue is not reproducible while in Online mode.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms