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 MARCH 08, 2017

Applies to:

Oracle Healthcare Master Person Index - Version 3.0.0 and later
Information 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:30 AM EST> <Info> <JTA> <hssc-cdw-mpi-p> <AdminServer> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1454684190504> <BEA-111015> <The commit operation for transaction BEA1-673EF6BB3C8E250DD0F8 timed out after 30 seconds.>
####<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

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