PFEX_TransactionXML table stops populating (Doc ID 1472296.1)

Last updated on MAY 15, 2014

Applies to:

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

Symptoms

 0x80042c05 error in the InForm event log shows something similar to the following:

informserveradapterservice[error] 0 2010-08-09 03:29:05,382 [3924]
ERROR PhaseForward.InFormAdapter.ServerAdapter.Service.ServerAdapterService GENERAL_TRANS_DETECT_ERROR
Exception: PhaseForward.InFormAdapter.Framework.Common.Exceptions.Messages.IAException
Message: A General Error Occured
Source: PhaseForward.InFormAdapter.ServerAdapter.Service
at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction)
in E:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 179
at PhaseForward.InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName)
in E:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 63
at PhaseForward.InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateCache(String trialName)
in E:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 123
at PhaseForward.InFormAdapter.ServerAdapter.Service.ServerAdapterService.UpdateCacheProc(Object stateInfo)
in E:\InformAdapter\ServerAdapter\Service\ServerAdapterService.cs:line 125
Nested Exception Exception: PhaseForward.InFormAdapter.Framework.Common.Exceptions.Messages.IAException
Message: Failed to create InForm Object Inform.PFTransaction. Please make sure Service or Trial '<trial name>' has started
Source: PhaseForward.InFormAdapter.ServerAdapter.Service
at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction)
in E:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 166
Nested Exception
Exception: PhaseForward.InFormAdapter.Framework.Common.Exceptions.Messages.IAException
Message: Failed to download InForm transaction from trial '<trial name>'. (59 234404 293026919596078.000)
Source: PhaseForward.InFormAdapter.ServerAdapter.Service
at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher)
in E:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 93
at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction)
in E:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 159
Nested Exception
Exception: System.Runtime.InteropServices.COMException
Message:
<PFError>
    <ErrorCode>0x80042c05</ErrorCode>
    <Details>ObjRef=59 234404 293026919596078.000</Details>
    <Activity>{46C78ED9-967A-41B1-8755-B29BBE5A8C9E}</Activity>
    <Location>.\PFIDMapper.cpp(181) .\PFXMLRequestDispatcher.cpp(159)</Location>
    <Loged>0</Loged>
</PFError>
Source: Inform.PFXMLRequestDispatcher.1
at PhaseForward.InFormAdapter.ServerAdapter.Interop.PFXMLGateway.IPFXMLGateway.Export(Object trial, String objectReference)
at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher)
in E:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 70

 Error can also come in this form (note "ObjRef=57" rather than "ObjRef=59"):

<PFError>
<ErrorCode>0x80042c05</ErrorCode>
<Details>
ObjRef=57 7387694 371592599942071.000</Details>
<Activity>{A31BCF8C-945A-4577-83C4-FD6CF7DE55CD}</Activity>
<Location>.\PFIDMapper.cpp(181)
.\PFXMLRequestDispatcher.cpp(159)</Location>
<Loged>0</Loged>
</PFError>
   at PhaseForward.InFormAdapter.ServerAdapter.Interop.PFXMLGateway.IPFXMLGateway.Export(Object trial, String objectReference)
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 142
   --- End of inner exception stack trace ---
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 165
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 525
   --- End of inner exception stack trace ---
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 561
   --- End of inner exception stack trace ---
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 583
   at PhaseForward.InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 96
   at PhaseForward.InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 171
   at PhaseForward.InFormAdapter.ServerAdapter.Service.ServerAdapterService.UpdateCacheProc(Object stateInfo) in D:\InformAdapter\ServerAdapter\Service\ServerAdapterService.cs:line 482

 

Error can also come from this form:

<PFError>
<ErrorCode>0x80042c05</ErrorCode>
<Details>
ObjRef=57 598071 357650486008056.000</Details>
<Activity>{BF6B6B8B-7845-4882-A31C-1103D3885CA8}</Activity>
<Location>.\PFIDMapper.cpp(185)
.\PFXMLRequestDispatcher.cpp(160)</Location>
<Logged>0</Logged>
</PFError>
   at PhaseForward.InFormAdapter.ServerAdapter.Interop.PFXMLGateway50.IPFXMLGateway.Export(Object trial, String objectReference)
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml50(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 282
   --- End of inner exception stack trace ---
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml50(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 305
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 539
   --- End of inner exception stack trace ---
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 561
   --- End of inner exception stack trace ---
   at PhaseForward.InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 583
   at PhaseForward.InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 96
   at PhaseForward.InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 171
   at PhaseForward.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