InForm Adapter Install fails with: InFormAdapter.IAConfigurationConsole.IAConfigurationConsole Update to data table INFORMADAPTER.PFIA_SINGLETONS failed. (Doc ID 1485921.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Full error in the Inform Adapter installation log is as follows:

ERROR InFormAdapter.IAConfigurationConsole.IAConfigurationConsole Update to data table INFORMADAPTER.PFIA_SINGLETONS failed.
InsertSql:
*** Command Parameters ***
                No parameters were found.
UpdateSql: UPDATE INFORMADAPTER.PFIA_SINGLETONS SET SINGLETONID = :SINGLETONID, IAVERSION = :IAVERSION, LASTUPDATE = to_timestamp_tz(:LASTUPDATE, 'DD-MM-RRRR HH24.MI.SS.FF7 TZH:TZM'), CUSTOMERURI = :CUSTOMERURI, APPLICATIONNAME = :APPLICATIONNAME, APPLICATIONID = :APPLICATIONID, SECURITYDOMAIN = :SECURITYDOMAIN, ALTERNATEWSHOST = :ALTERNATEWSHOST WHERE SINGLETONID = :SINGLETONID
*** Command Parameters ***
                Parameter Name: SINGLETONID
                Source Column: SINGLETONID
                Parameter Value: <Singleton GUID>
                Parameter Name: IAVERSION
                Source Column: IAVERSION
                Parameter Value: InForm Adapter 1.3.3
                Parameter Name: LASTUPDATE
                Source Column: LASTUPDATE
                Parameter Value: <last update>
                Parameter Name: CUSTOMERURI
                Source Column: CUSTOMERURI
                Parameter Value: <customer URI>
                Parameter Name: APPLICATIONNAME
                Source Column: APPLICATIONNAME
                Parameter Value: CentralServices
                Parameter Name: APPLICATIONID
                Source Column: ALTERNATEWSHOST
                Parameter Value:
                Parameter Name: SINGLETONID
                Source Column: SINGLETONID
                Parameter Value: <Singleton GUID>
DeleteSql:
*** Command Parameters ***
                No parameters were found.
   DB Provider Message: 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(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.UpdateRowExecute(RowUpdatedEventArgs rowUpdatedEvent, IDbCommand dataCommand, StatementType cmdIndex)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at Oracle.DataAccess.Client.OracleDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
   at Platform.Storage.Providers.ODPOracleProvider.Update(IDbDataAdapter dbAdapter, DataTable data)
   at Platform.Storage.DBProvider.InternalUpdateTable(DataTable data, String owner, IDBUpdateBuilder updateBuilder, Boolean ignoreDeleteConcurrencyException)
2012-07-19 13:55:18,142 [728] ERROR InFormAdapter.IAConfigurationConsole.IAConfigurationConsole
Server stack trace:
   at Platform.Storage.DBProvider.InternalUpdateTable(DataTable data, String owner, IDBUpdateBuilder updateBuilder, Boolean ignoreDeleteConcurrencyException)
   at Platform.DataSetManager.DataSetWriter.UpdateDataTable(DataTable table, DataTable auditTable, LocalizedBusinessAuditContext localizedBusinessAuditContext, ConcurrencyModeType concurrencyMode, String concurrencyColumn, IDataPipeline pipeline)
   at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at PhaseForward.Platform.DataSetManager.DataSetWriter.UpdateDataTable(DataTable table, DataTable auditTable, LocalizedBusinessAuditContext localizedBusinessAuditContext, ConcurrencyModeType concurrencyMode, String concurrencyColumn, IDataPipeline pipeline)
   at Platform.DataSetManager.BaseDataSetManager.UpdateDataTable(DataTable table, DataTable auditTable, ConcurrencyModeType concurrencyMode, String concurrencyColumn)
   at Platform.DataSetManager.BaseDataSetManager.UpdateDataTable(DataTable table, DataTable auditTable)
   at InFormAdapter.Framework.Common.Configuration.CommonConfiguration.SingletonDataSetManagerBase.UpdateSingleton(CommonConfigurationDS dataSet)
   at InFormAdapter.Framework.Common.Configuration.CommonConfiguration.SingletonManagerBase.UpdateSingletonList(Singleton[] dataList)
   at InFormAdapter.Framework.Common.Configuration.CommonConfiguration.SingletonManagerBase.UpdateSingleton(Singleton data)
   at InFormAdapter.Framework.Common.Configuration.CommonConfiguration.CommonConfigurationWrapper.SetSingletonData(Singleton singletonData)
   at InFormAdapter.IAConfigurationUtilities.SingletonStorage.SingletonConfiguration.SetConfigurationValues()
   at InFormAdapter.IAConfigurationUtilities.SingletonStorage.SingletonConfiguration.Configure()
   at InFormAdapter.IAConfigurationConsole.IAConfigurationConsole.Main(String[] args) in D:\InformAdapter\Install\IAConfiguration\IAConfigurationConsole\IAConfigurationConsole.cs:line 47
2012-07-19 13:55:18,142 [728] ERROR InFormAdapter.IAConfigurationConsole.IAConfigurationConsole  Singleton set /customeruri <customer URI>
2012-07-19 13:55:18,142 [728] ERROR InFormAdapter.IAConfigurationConsole.IAConfigurationConsole  end.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.