InformServerAdapter (ISA) 0x80041c0f error (Doc ID 1500634.1)

Last updated on JULY 13, 2019

Applies to:

Symptoms

 The InformServerAdapter (ISA) service does not populate the pfex_transactionxml because of the following errors (occurring every 5 minutes as per the ISA sleep interval) due to the following as seen in the Inform app server event log:

pferror[error] 7183 SQL query returned no records or more than one record. Header=Unloged exception HRESULT=0x80041c0f Details=Table=PF_TransactionHistory, where clause=ExternalGUID=<GUID>' Activity={B43162D3-CE3E-4C69-A269-9F8D1DE31A26} Location=..\inc\UdaHelper.h(116)

informserveradapterservice[error] 00:05:03,079 [7252] ERROR InFormAdapter.ServerAdapter.Service.ServerAdapterService An error occurred while detecting transactions in
InForm.InFormAdapter.Framework.Common.Resources.InFormAdapterException: A General Error Occurred ---> System.Runtime.InteropServices.COMException (0x80041C0F):
<PFError> <ErrorCode>0x80041c0f</ErrorCode> <Details>Table=PF_TransactionHistory,
where clause=ExternalGUID='GUID>'</Details> <Activity>{B43162D3-CE3E-4C69-A269-9F8D1DE31A26}</Activity> <Location>..\inc\UdaHelper.h(116)</Location> <Loged>0</Loged> </PFError> at
InFormAdapter.ServerAdapter.Interop.PFMngrSync.PFDefaultFilterClass.Initialize(Object trial, Object vector, EFirstTransactionType flag, Object firstTrans, Object enumCLSID) at
InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in
D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 460 --- End of inner exception stack trace --- at InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in
D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 583 at InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName) in
D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 96 at InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateCache(String trialName) in
D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 171 at InFormAdapter.ServerAdapter.Service.ServerAdapterService.UpdateCacheProc(Object stateInfo) in
D:\InformAdapter\ServerAdapter\Service\ServerAdapterService.cs:line 482

Cause

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