InformServerAdapter (ISA) Fails Due to Invalid PFEX_PENDINGTRANSACTIONS.EXTERNALGUID Value (Doc ID 1526796.1)

Last updated on JULY 10, 2019

Applies to:

Symptoms

 The InformServerAdapter (ISA) service stops populating the pfex_transactionxml table and the following error is seen in the Event log:

informserveradapterservice[error] 0 158 [2172] 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='{<EXTERNAL_GUID>}'</Details> <Activity>{08BCB1D1-8C48-4C14-829C-8B8DC7044275}</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.