InForm Server Adapter Stops Generating Transactions (Doc ID 2121617.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Health Sciences InForm Adapter - Version 1.3.0 and later
Oracle Health Sciences InForm - Version 6.0 to 6.0 [Release 6.0]
Information in this document applies to any platform.

Symptoms

 InForm Server Adapter service stops generating transactions after users are cooked into a study.

Event log shows errors:

pferror[error] 7183 SQL query returned no records or more than one record.
]Header=Unlogged exception HRESULT=0x80041c0f
Details=SQL query returned no records or more than one record.
Query=SELECT DISTINCT EnteredReason, b.SubjectKeyType FROM PF_ItemData a, PF_ItemContext b WHERE TransactionID=<transacitonid> AND SubjectKeyID=<subjectkeyid> AND a.ContextID=b.ContextID
Activity={86B0054F-D02B-48DE-BCF0-B045E689F438}
Transaction=<ExternalGUID>
Location=e:\Athena\INFORM\Server\inc\UDAHelper.h(137)
ProcessID=3212 ThreadID=6280
CallStack= 0x0000000010A712E0, \PFXMLGateway.dll(0x0000000010A70000), ()+. 0x0000000010A8E668, \PFXMLGateway.dll(0x0000000010A70000), ()+. 0x0000000010AA6466, \PFXMLGateway.dll(0x0000000010A70000), ()+. 0x0000000010AC5BB5, \PFXMLGateway.dll(0x0000000010A70000), DllUnregisterServer()+9701. 0x000007FEFD45F4A5, \RPCRT4.dll(0x000007FEFD430000), RpcBindingSetAuthInfoW()+229. 0x000007FEFD454502, \RPCRT4.dll(0x000007FEFD430000), NdrStubCall2()+722. 0x000007FEFD8C376F, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+31263. 0x000007FEFDA910D4, \OLEAUT32.dll(0x000007FEFDA00000), DllRegisterServer()+3556. 0x000007FEFD8C0CCD, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+20349. 0x000007FEFD8C0C43, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+20211. 0x000007FEFD77A500, \ole32.dll(0x000007FEFD750000),

 

informserveradapterservice[error] 0 2016-03-29 00:25:23,330 [<trial name>:e5c76209c2ec4b808136af4b1f09a0dc]
ERROR Oracle.InForm.ServerAdapter.Service.ServerAdapterService Trial <trial name>: The thread <trial name>:e5c76209c2ec4b808136af4b1f09a0dc encountered an error when getting transaction XML from XMLGateway and this thread will exit.
Oracle.InForm.ServerAdapter.Common.Resources.InFormServerAdapterException: Failed to download InForm transaction from trial '<trial name>'. (<keyid starting with 53 >) ---> System.Runtime.InteropServices.COMException (0x80041C0F):
<PFError>
<ErrorCode>0x80041c0f</ErrorCode>
<Details>ObjRef=<keyid starting with 53 >. </Details>
<Activity>{CCAF5CDC-C781-4F2F-8837-03D90A7DF57B}</Activity>
<Transaction>{A77CF4B8-D900-44D3-84EB-A862A9952366}</Transaction>
<Location>.\PFXMLRequestDispatcher.cpp(191)</Location>
<ProcessID>3212</ProcessID>
<ThreadID>8028</ThreadID>
<CallStack>
0x0000000010AC5C17, \PFXMLGateway.dll(0x0000000010A70000), DllUnregisterServer()+9799. 0x000007FEFD45F4A5, \RPCRT4.dll(0x000007FEFD430000), RpcBindingSetAuthInfoW()+229. 0x000007FEFD454502, \RPCRT4.dll(0x000007FEFD430000), NdrStubCall2()+722. 0x000007FEFD8C376F, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+31263. 0x000007FEFDA910D4, \OLEAUT32.dll(0x000007FEFDA00000), DllRegisterServer()+3556. 0x000007FEFD8C0CCD, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+20349. 0x000007FEFD8C0C43, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+20211. 0x000007FEFD77A500, \ole32.dll(0x000007FEFD750000), CoSetState()+5200. 0x000007FEFD8C14D6, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+22406. 0x000007FEFD8C122B, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+21723. 0x000007FEFD8BFD6D, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+16413. 0x000007FEFD452924, \RPCRT4.dll(0x000007FEFD430000), NdrServerCall2()+6852. 0x000007FEFD452A86, \RPCRT4.dll(0x000007FEFD430000), NdrServerCall2()+7206.
</CallStack>
<Logged>0</Logged>
</PFError>
<PFError>
<ErrorCode>0x80041c0f</ErrorCode>
<Details>SQL query returned no records or more than one record. Query=SELECT DISTINCT EnteredReason, b.SubjectKeyType FROM PF_ItemData a, PF_ItemContext b WHERE TransactionID=<transactionid> AND SubjectKeyID=<subjectkeyid AND a.ContextID=b.ContextID </Details>
<Activity>{CCAF5CDC-C781-4F2F-8837-03D90A7DF57B}</Activity>
<Transaction>{A77CF4B8-D900-44D3-84EB-A862A9952366}</Transaction>
<Location>e:\Athena\INFORM\Server\inc\UDAHelper.h(137)</Location>
<ProcessID>3212</ProcessID> <ThreadID>8028</ThreadID>
<CallStack> 0x0000000010A712E0, \PFXMLGateway.dll(0x0000000010A70000), ()+. 0x0000000010A8E668, \PFXMLGateway.dll(0x0000000010A70000), ()+. 0x0000000010AA6466, \PFXMLGateway.dll(0x0000000010A70000), ()+. 0x0000000010AC5BB5, \PFXMLGateway.dll(0x0000000010A70000), DllUnregisterServer()+9701. 0x000007FEFD45F4A5, \RPCRT4.dll(0x000007FEFD430000), RpcBindingSetAuthInfoW()+229. 0x000007FEFD454502, \RPCRT4.dll(0x000007FEFD430000), NdrStubCall2()+722. 0x000007FEFD8C376F, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+31263. 0x000007FEFDA910D4, \OLEAUT32.dll(0x000007FEFDA00000), DllRegisterServer()+3556. 0x000007FEFD8C0CCD, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+20349. 0x000007FEFD8C0C43, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+20211. 0x000007FEFD77A500, \ole32.dll(0x000007FEFD750000), CoSetState()+5200. 0x000007FEFD8C14D6, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+22406. 0x000007FEFD8C122B, \ole32.dll(0x000007FEFD750000), CoGetInstanceFromFile()+21723.
</CallStack>
<Logged>0</Logged>
</PFError>
at PhaseForward.InFormAdapter.ServerAdapter.Interop.PFXMLGateway60.IPFXMLGateway.Export(Object trial, String objectReference)
at Oracle.InForm.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml60(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher)
in C:\InformServerAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 481
--- End of inner exception stack trace ---
at Oracle.InForm.ServerAdapter.Service.InFormServerAdapterImpl.GetTransactionXml60(String trial, IPFTransaction transaction, PFXMLRequestDispatcher pfRequestDispatcher)
in C:\InformServerAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 524
at Oracle.InForm.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction)
in C:\InformServerAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 704
at Oracle.InForm.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName)
in C:\InformServerAdapter\ServerAdapter\Service\TransactionCache.cs:line 112
at Oracle.InForm.ServerAdapter.Service.ServerAdapterService.WorkerThreadProc(Object stateInfo)
in C:\InformServerAdapter\ServerAdapter\Service\ServerAdapterService.cs:line 301

 

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