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

Last updated on JULY 07, 2014

Applies to:

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

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='{98F29756-48F4-4416-B4D6-7339672C210A}'</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

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