Error: "System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available."

Error: "System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available."

book

Article ID: KB0082467

calendar_today

Updated On:

Products Versions
Spotfire Web Player 7.0 and prior

Description

Description:

Analysis created with "OracleClient Data Provider" connection fails to open through Web Player. The Web Player log reports the following:

Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
 

Symptoms:

The analysis created with the "OracleClient Data Provider" connection fails to open through the Web Player, and the Web Player reports:

 

Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query. ---> System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
      at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
      at System.Data.OracleClient.OciEnvironmentHandle..ctor(MODE environmentMode, Boolean unicode)
......
......

Cause:

Possible causes include the following:

1). Oracle Client packages are not installed properly or an incorrect version has been installed.

2). Web Player Application Pool identity has insufficient access permission for the Oracle Client Installation folder.

3). The ORACLE_HOME environment variable is not set on the Web Player server.

 

Issue/Introduction

Error: "System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available."

Resolution

1).  Verify that the correct version of the Oracle client is installed on the Web Player server.

2).  Try to reinstall the Oracle Client software with full Administrative credentials.

3).  Verify that the Web Player Application pool identity user has full access permission on the Oracle Client installation folder and its subfolders.

4).  Create the ORACLE_HOME environment variable and set it to the Oracle Client installation folder path. (e.g., C:\oracle\product\11.2.0\client).

Powered by Wolken Software