Problem with Tibco Spotfire 7.7 to Oracle

[Giuseppe Verardi]

I have a problem to connect to Oracle with Tibco Analyst 7.7, the error is:

 

ImportException at Spotfire.Dxp.Data:

An exception was thrown by the data connection.

Exception text:

System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleConnectionStringBuilder' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'OraOps12.dll': Impossibile trovare il modulo specificato. (Exception from HRESULT: 0x8007007E)

at Oracle.DataAccess.Client.OpsInit.CheckVersionCompatibility(String version)

at Oracle.DataAccess.Client.OracleInit.Initialize()

at Oracle.DataAccess.Client.OracleConnectionStringBuilder..cctor()

--- End of inner exception stack trace ---

at Oracle.DataAccess.Client.OracleConnectionStringBuilder..ctor()

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.BuildConnectionString(AdapterCredentialsValue credentials, OracleConnectionSettings oracleConnectionSettings)

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.ExecuteQueryCommon(SqlQuery query, CommandType commandType, String queryString, List`1 parameters, Dictionary`2 parameterValues, IList`1 storedProcedureColumns, QueryResultWriter resultWriter, CancellationToken cancellationToken)

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.ExecuteTextQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken)

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.ExecuteQueryCore(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.ExecuteQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext)

at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.c__DisplayClass60.c__DisplayClass62.b__5e(CancellationToken token)

at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod(ImpersonationPolicy impersonationPolicy, AdapterMethodDelegate method, Nullable`1 cancellationToken)

 

Data connection:

TIS-Liv1 (7)

 

Server:

rsdw1c.db.enel

 

Connect using:

SID:RSDW1C

 

Authentication method:

Oracle authentication (HRESULT: 80131500)

 

Stack Trace:

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(CxxSession session, GlobalMethodRegistry globalMethodRegistry, NotificationService notificationService, Int32 rowLimit)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.GetColumnsAndProperties()

at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(DataColumnProducer producer, Boolean forceUpdate)

at Spotfire.Dxp.Data.Persistence.DataPool.GetDerivedData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Persistence.DataPool.GetData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.PoolReferenceCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.LookupOrEvaluateValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.GetValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

at Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.b__4()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__16.MoveNext()

at Spotfire.Dxp.Data.DataTable.d__5e.MoveNext()

 

I installed Oracle ODAC

[Shashank Gurnalkar]

Hello Giuseppe,

Oracle connector supports connection to Oracle 11/12 (Oracle

Oracle connector supports connection to Oracle 11/12 (Oracle 11gR1, 11gR2, 12c) and the above error indicates that the Oracle database version is older then the supported one. To verify the Oracle database version, run the following command in an Oracle client.

SELECT * FROM V$VERSION

Resolution:

To resolve this issue, request your DBA to upgrade your Oracle database to a supported version.

Till the time database version is upgraded, you can connect to an existing Oracle database by making use of Information Designer (information link).

Reference: https://supportapps.tibco.com/ka/article/375/000031375.htm

Reference:https://docs.tibco.com/pub/spotfire/general/sr/GUID-6E3DA40C-CD73-4EB7-8A84-ADE29BF68716.html#GUID-6E3DA40C-CD73-4EB7-8A84-ADE29BF68716__TABLE_7E475A41B47C48CCA7E53423B83525BF_unique_14