Didier DUMETZ Posted September 26, 2019 Share Posted September 26, 2019 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 Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted September 26, 2019 Share Posted September 26, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now