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.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.
