ERROR - "Oracle.DataAccess.Client.OracleException.get_Number()" while opening an analysis in Web Player.
Article ID: KB0075874
Updated On:
| Products | Versions |
|---|---|
| Spotfire Web Player | ALL Versions |
Description
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:
Cause:
The error is returned if the Oracle OPD.NET driver is not installed correctly or is corrupted.
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.
Issue/Introduction
ERROR - "Oracle.DataAccess.Client.OracleException.get_Number()" while opening an analysis in Web Player.
Resolution
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.
Additional Information
https://community.oracle.com/thread/413148
Feedback
Yes
No
Powered by
