problem with oracle database data connection.

[messi regina]

i am having a problem with the data connection. When importing a data table into spotfire I get an error. i am using the oracle connector to connect with the oracle database. can anyone help me

 

Error message: An exception was thrown by the data connection.

ImportException at Spotfire.Dxp.Data:

An exception was thrown by the data connection.

Exception text:

System.NullReferenceException: Object reference not set to an instance of an object.

at Oracle.DataAccess.Client.OracleConnection.Open()

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.TryOpenConnection(OracleConnection connection)

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

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.c__DisplayClass56_0.b__0(NativeQueryExecutionDiagnostics executionDia)

at Spotfire.Dxp.Data.Access.QueryExecution.QueryTrackerService.ExecuteQuery(QueryExecutionInfo queryExecutionInfo, QueryExecutor queryExecutor, CancellationToken cancellationToken)

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, IDictionary`2 logContext, CancellationToken cancellationToken)

at Spotfire.Dxp.Data.Adapters.Oracle.OracleAdapterConnection.ExecuteTextQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, IDictionary`2 logContext, 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, IDictionary`2 logContext, CancellationToken cancellationToken)

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

at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.c__DisplayClass83_1.b__1(CancellationToken token)

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

[Prashant Ajjannavar]

Hello,

Can you try the suggestions mentioned in this KB article and see if it resolves your issue.

https://support.tibco.com/s/article/ERROR-Oracle-DataAccess-Client-Oracl...