Jump to content
We've recently updated our Privacy Statement, available here. ×

Problem with Tibco Spotfire 7.7 to Oracle


Giuseppe Verardi

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...