Error when connecting to an Oracle data source using the Oracle Client Data Provider in TIBCO Spotfire: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" – Revvity Signals

Date Posted: 2020-09-22
Product: TIBCO Spotfire®

Problem:

Error when connecting to an Oracle data source using the Oracle Client Data Provider in TIBCO Spotfire: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater"

Solution:

While using the Oracle client data provider to connect to Oracle database, below error message is received
====================
Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data source query for data source "". --->
System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<>c__DisplayClass23_1.<GetPromptModels>b__0()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)
   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<GetPromptModels>d__23.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
   --- End of inner exception stack trace ---
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
   at Spotfire.Dxp.Data.DataFlow.<ConnectAndGetPromptModels>d__12.MoveNext()
   at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.<GetPromptModelsCore>d__4.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()
======================== To resolve this, make sure to install the Oracle ODAC component on the Spotfire Analyst client machine and/or the Node Manager server machine.

Example: ODAC122011_x64.zip can be downloaded from the link: https://www.oracle.com/database/technologies/odac-downloads.html

Related articles