My Oracle Support Banner

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 AUGUST 10, 2018

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)'> <> <> <> <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

To view full details, 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 a vibrant support community of peers and Oracle experts.