MergeSystemRecord Times Out After 30 Seconds: BEA-111015, MDM-MI-QUE538, ORA-01013 "user requested cancel of current operation"
(Doc ID 2105702.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Healthcare Master Person Index - Version 3.0.0 and laterInformation in this document applies to any platform.
Symptoms
When calling mergeSystemRecord the transaction times out after 30 seconds while waiting for a database query to be returned.
The errors displayed are BEA-111015, MDM-MI-MSC582, MDM-MI-UPD522, MDM-MI-QUE541, MDM-MI-QUE538, ORA-01013:
The web service response after around 40 seconds is:
####<Feb 5, 2016 9:56:40 AM EST> <Error> <com.sun.mdm.index.ejb.master.MasterControllerCoreImpl> <hssc-cdw-mpi-p> <AdminServer> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <MasterIndex.WSUser> <BEA1-673EF6BB3C8E250DD0F8> <> <1454684200576> <BEA-000000> <MDM-MI-MSC582: MasterControllerImpl encountered a ProcessingException: name=com.sun.mdm.index.update.UpdateException, message=MDM-MI-UPD522: Could not retrieve all merged SystemObjects: com.sun.mdm.index.query.QMException: MDM-MI-QUE541: findMergedToLID() failed at findAllMergedLIDs(): com.sun.mdm.index.query.QMException: MDM-MI-QUE538: Could not find the "merged to" Local ID: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
...
javax.ejb.EJBException: Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out after 30 seconds
BEA1-673EF6BB3C8E250DD0F8
at weblogic.transaction.internal.ServerTransactionImpl.wakeUp(ServerTransactionImpl.java:1842)
at weblogic.transaction.internal.ServerTransactionManagerImpl.processTimedOutTransactions(ServerTransactionManagerImpl.java:1724)
...
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused By: weblogic.transaction.internal.TimedOutException: Transaction timed out after 30 seconds
BEA1-673EF6BB3C8E250DD0F8
at weblogic.transaction.internal.ServerTransactionImpl.wakeUp(ServerTransactionImpl.java:1842)
...
Due this issue, they are unable to process the merge transactions from the source system. Given that updates to patients in pessimistic mode do not automatically cause an assumed match, the A34 merge transactions must be processed. This worked in the past.
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 |
| References |