ERROR - "Oracle.DataAccess.Client.OracleException.get_Number()" while opening an analysis in Web Player. – Revvity Signals

Date Posted: 2020-03-24
Product: TIBCO Spotfire®

Problem:

ERROR - "Oracle.DataAccess.Client.OracleException.get_Number()" while opening an analysis in Web Player.

Solution:

Description:
TIBCO Spotfire Web Player throws ERROR - "Oracle.DataAccess.Client.OracleException.get_Number()" while opening an analysis via Web Player.

Symptoms:
The following ERROR trace can be found in the Web Player logs:

ERROR xxxx-xx-xx xx:xx:xx,xxx [qk5dy5wz4d11xf3c3ej4wr3z, 2696, WorkThread 73,xxxxxx@xxxxx] Spotfire.Dxp.Framework.ApplicationModel.NotificationService - 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.OracleException.get_Number()

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

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__DisplayClass28.<>c__DisplayClass2a.<ExecuteQueryAndCreateTable>b__26(CancellationToken token)

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

Data connection:

Connection

Server:

<Oracle_host>

Connect using:

SID:<SIDNAME>

Authentication method:

Oracle authentication

Cause:
The error is returned if the Oracle OPD.NET driver is not installed correctly or is corrupted.

To fix the problem:

1). Confirm that you are using a 32-bit or 64-bit driver.

2). Try to reinstall ODP.NET driver with a full Administrative user.

3). Confirm that the PATH variable is properly set in the Environment Variables , e.g. c:\Oracle & c:\Oracle\bin where c:\Oracle is the folder you have installed the OPD.NET driver.

4). Confirm that you are using the correct ODAC version for the ODP.NET install. It is best to download and install the ODAC version that is same as your database version.

https://community.oracle.com/thread/413148