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

Date Posted: 2018-02-28
Product: TIBCO Spotfire®

Problem:

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

Solution:

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:

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.

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).