Error with Oracle Data Connector in Web Player

[Didier DUMETZ]

Hello,

We have an issue in our Web Playerwhere no Oracle Data Connector is working.

ODAC 12.1 64 bits is installed and we use Spotfire server component 7.7

When connecting with Analyst on the node manager server hosting Web Player, everything is working fine.

I suspect an issue with ODAC registration with .NET but after googling for hours, I didn't find any clue pointing to this.

We have other servers installed with exactly the same software components where it is running fine.

Does anyone have ever encountered this

Here is the stack trace :

Messages

Data connection:

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.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, 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__DisplayClass71_0.b__3(CancellationToken token)

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

 

Data connection:

xxxxxxxxxx

 

Server:

xxxxxxxxxxxxx

 

Connect using:

SID:xxxxxxxxxx

 

Authentication method:

Oracle authentication

[Shashank Gurnalkar]

Can you try to uninstall the existing driver from Node Manager machine and reinstall it or (12.1.0.2.4) and see if this helps.