InformServerAdapter (ISA) 0x80041c0f error
(Doc ID 1500634.1)
Last updated on JULY 13, 2019
Applies to:
Oracle Health Sciences InForm Adapter - Version 1.3.4 and laterOracle Health Sciences InForm - Version 4.6.2 and later
Information in this document applies to any platform.
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
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 |