Fixes are available
APAR status
Closed as fixed if next.
Error description
The following deadlock may appear during the event handling of a 'processDeleted' event: [8/27/11 14:08:51:714 CDT] 000005c5 TraceBPE 3 com.ibm.bpe.engine.BpelEngine.onMessage(BpelEngine.java:1564) CWWBE0013E: An error occurred during the event handling of 'processDeleted' in the observer plug-in type 'com.ibm.bpe.engine.observer.DatabaseAuditBStateObserverPlugin'. com.ibm.bpe.api.EngineStateObserverEventError: CWWBE0013E: An error occurred during the event handling of 'processDeleted' in the observer plug-in type 'com.ibm.bpe.engine.observer.DatabaseAuditBStateObserverPlugin'. com.ibm.bpe.database.TomSQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 210) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.ibm.bpe.database.ProcessInstanceB.get(ProcessInstanceB.java: 162) at com.ibm.bpe.database.Tom.getProcessInstanceB(Tom.java:11387) at com.ibm.bpe.database.ProcessInstanceB.getParentProcessInstanceB( ProcessI nstanceB.java:980) at com.ibm.bpe.database.ProcessInstanceInternalImpl.getParentProces sInstanc e(ProcessInstanceInternalImpl.java:856) at com.ibm.bpe.engine.observer.DatabaseAuditBStateObserverPlugin.pr ocessIns tanceEvent(DatabaseAuditBStateObserverPlugin.java:369) at com.ibm.bpe.engine.observer.BpelStateObserver.observe(BpelStateO bserver. java:1442) at com.ibm.bpe.engine.observer.BpelStateObserver.observeOrDelay(Bpe lStateOb server.java:1406) at com.ibm.bpe.engine.observer.BpelStateObserver.processDeleted(Bpe lStateOb server.java:733) at com.ibm.bpe.engine.BpelDeleteProcessEngineMessage.execute(BpelDe leteProc essEngineMessage.java:74) at com.ibm.bpe.engine.BpelEngine.onMessage(BpelEngine.java:1536) at com.ibm.bpe.framework.GenericAPIServicesImpl$7.run(GenericAPISer vicesImp l.java:440) at com.ibm.bpe.framework.infrastructure.InfrastructureServicesSuppo rtBean.r unInCScopeTxClassLoaderContextsWithException(InfrastructureServi cesSuppo rtBean.java:167) at com.ibm.bpe.framework.infrastructure.EJSLocalStatelessInfrastruc tureServ icesSupportBea_70e9f9d4.runInCScopeTxClassLoaderContextsWithExce ption(Un known Source) at com.ibm.bpe.framework.infrastructure.InfrastructureServicesImpl. runInCSc opeTxClassLoaderContextsWithException(InfrastructureServicesImpl .java:35 0) at com.ibm.bpe.framework.infrastructure.InfrastructureServicesImpl$ 2.run(In frastructureServicesImpl.java:251) at com.ibm.bpe.framework.sca.AbstractBPCImplementationHandler.handl eInvocat ionEnvironmentRequest(AbstractBPCImplementationHandler.java:187) at com.ibm.bpe.framework.sca.AbstractBPCImplementationHandler.proce ssMessag e(AbstractBPCImplementationHandler.java:130) at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.proce ssMessag eWithPCI(MessageDispatcherImpl.java:755) at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.proce ssMessag e(MessageDispatcherImpl.java:1607) at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process( ManagedM essageImpl.java:980) at com.ibm.ws.sca.internal.webmodule.handler.WebModuleContextSwitch Handler. processMessage(WebModuleContextSwitchHandler.java:146) at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.proce ssMessag eWithPCI(MessageDispatcherImpl.java:766) at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.proce ssMessag e(MessageDispatcherImpl.java:1607) at com.ibm.ws.sca.internal.proxy.impl.ProxyInvocationHandlerImpl.in voke(Pro xyInvocationHandlerImpl.java:783) at $Proxy99.processMessage(Unknown Source) at com.ibm.bpe.framework.sca.InvocationEnvironmentProviderImpl.runI nInvocat ionEnvironment(InvocationEnvironmentProviderImpl.java:158) at com.ibm.bpe.framework.infrastructure.InfrastructureServicesImpl. runInSca CScopeTxClassLoaderContextsWithException(InfrastructureServicesI mpl.java :257) at com.ibm.bpe.framework.GenericAPIServicesImpl.bpc_onMessage(Gener icAPISer vicesImpl.java:427) at com.ibm.bpe.framework.BpelProcessWorkObjectImpl.processV6EngineM essage(B pelProcessWorkObjectImpl.java:261) at com.ibm.bpe.framework.BpelProcessWorkObjectImpl.run(BpelProcessW orkObjec tImpl.java:160) at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java :268) at java.security.AccessController.doPrivileged(AccessController.jav a:202) at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:768) at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextI mpl.java :86) at com.ibm.bpe.framework.ProcessExecutionContextImpl$1.run(ProcessE xecution ContextImpl.java:106) at java.security.AccessController.doPrivileged(AccessController.jav a:251) at com.ibm.bpe.framework.ProcessExecutionContextImpl.go(ProcessExec utionCon textImpl.java:94) at com.ibm.bpe.framework.ProcessMDB.processEngineMessage(ProcessMDB .java:79 3) at com.ibm.bpe.framework.ProcessMDB.onMessage(ProcessMDB.java:431) at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(Mes sageEndp ointHandler.java:1093) at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpo intHandl er.java:778) at $Proxy52.onMessage(Unknown Source) at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEn dpoint(J msJcaEndpointInvokerImpl.java:233) at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDis patcher. java:900) at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaW ork.run( SibRaSingleProcessListener.java:552) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)
Local fix
N/A
Problem summary
************************************************************** * Maintenance stream beyond BPM Adv. 7.5.0 Fixpack 1 will be * * 7.5.1. APAR has been fixed with 7.5.1 GA. * ************************************************************** The following deadlock may appear during the event handling of a 'processDeleted' event: [8/27/11 14:08:51:714 CDT] 000005c5 TraceBPE 3 com.ibm.bpe.engine.BpelEngine.onMessage(BpelEngine.java:1564) CWWBE0013E: An error occurred during the event handling of 'processDeleted' in the observer plug-in type 'com.ibm.bpe.engine.observer.DatabaseAuditBStateObserverPlugin'. com.ibm.bpe.api.EngineStateObserverEventError: CWWBE0013E: An error occurred during the event handling of 'processDeleted' in the observer plug-in type 'com.ibm.bpe.engine.observer.DatabaseAuditBStateObserverPlugin'. com.ibm.bpe.database.TomSQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 210) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.ibm.bpe.database.ProcessInstanceB.get(ProcessInstanceB.java: 162) at com.ibm.bpe.database.Tom.getProcessInstanceB(Tom.java:11387) at com.ibm.bpe.database.ProcessInstanceB.getParentProcessInstanceB( ProcessInstanceB.java:980) at com.ibm.bpe.database.ProcessInstanceInternalImpl.getParentProces sInstance(ProcessInstanceInternalImpl.java:856) at com.ibm.bpe.engine.observer.DatabaseAuditBStateObserverPlugin.pr ocessInstanceEvent(DatabaseAuditBStateObserverPlugin.java:369) at com.ibm.bpe.engine.observer.BpelStateObserver.observe(BpelStateO bserver.java:1442) at com.ibm.bpe.engine.observer.BpelStateObserver.observeOrDelay(Bpe lStateObserver.java:1406) at com.ibm.bpe.engine.observer.BpelStateObserver.processDeleted(Bpe lStateObserver.java:733) at com.ibm.bpe.engine.BpelDeleteProcessEngineMessage.execute(BpelDe leteProcessEngineMessage.java:74) at com.ibm.bpe.engine.BpelEngine.onMessage(BpelEngine.java:1536) ... This Fix solves the deadlock by avoiding the database select statement at this point in time.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR40510
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
750
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-08-30
Closed date
2011-11-11
Last modified date
2011-11-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R751 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021