ISA Service Fails With "Object Reference not Set to an Instance of an Object" Error. (Doc ID 1499096.1)

Last updated on JUNE 30, 2014

Applies to:

Oracle Health Sciences InForm Adapter - Version 1.3.0 and later
Information in this document applies to any platform.

Symptoms

 The InformServerAdapter (ISA) service encounters the following error:

550 [548] ERROR InFormAdapter.ServerAdapter.Service.ServerAdapterService An error occurred while detecting transactions in InForm.
Platform.Storage.Exceptions.DBProviders.Messages.DbProviderException: ExecuteQuery() failed.  Internal Exception : System.NullReferenceException: Object reference not set to an instance of an object.
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Platform.Storage.Providers.CommandProxy.System.Data.IDbCommand.ExecuteReader() in E:\ICEPlatform\AppServer\Storage\Providers\CommandProxy.cs:line 49
   at Platform.Storage.DBProvider.ExecuteReader(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 1033.  DB Command Text : SELECT     INDEX_NAME, TABLE_NAME
FROM         SYS.USER_INDEXES
WHERE     (INDEX_NAME = :indexName). ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at PhaseFPlatform.Storage.Providers.CommandProxy.System.Data.IDbCommand.ExecuteReader() in E:\ICEPlatform\AppServer\Storage\Providers\CommandProxy.cs:line 49
   at PhaseFPlatform.Storage.DBProvider.ExecuteReader(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 1033
   --- End of inner exception stack trace ---
   at Platform.Storage.DBProvider.ExecuteReader(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 1058
   at InFormAdapter.Framework.Common.DataUtilities.ExecuteReader(IDBProvider provider, IDbCommand cmd) in D:\InformAdapter\Framework\Common\DataUtilities.cs:line 449
   at InFormAdapter.ServerAdapter.Database.TransactionXmlTable.IndexExists(String indexName) in D:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 104
   at InFormAdapter.ServerAdapter.Database.TransactionXmlTable.EnsureTableExists() in D:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 135
   at InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 53
   at InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 159
   at InFormAdapter.ServerAdapter.Service.ServerAdapterService.UpdateCacheProc(Object stateInfo) in D:\InformAdapter\ServerAdapter\Service\ServerAdapterService.cs:line 436 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms