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:
Oracle Life Sciences InForm Adapter - Version 1.3.0 to 1.3.5 [Release 1.3.0]Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |