Search

Your Notifications (0)

There are currently no notifications. You're all set!

Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Image Artist Spectrus, Percepta, Katalyst, Luminata and more
Downloads
Downloads
Community
Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

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

Tanno, Shinichi
  • Updated
Date Posted:
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

Related articles

Comments

0 comments

Article is closed for comments.