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

2a). For Version 7.0 and below - Web Player Application Pool identity has insufficient access permission for the Oracle Client Installation folder.
2b). For Version 7.5 and above - Node Manager Service Account 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.
e.g.  download the Oracle client from  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

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

3).  For Version 7.0 and below , verify that the Web Player Application pool identity user has full access permission on the Oracle Client installation folder and its subfolders.

 For version 7.5 and above , verify that the Node Manager service Account 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 attached screenshot (Filename Oraclehome.png).
 

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