Fixes are available
APAR status
Closed as program error.
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
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 iFix solves the deadlock by avoiding the database select statement at this point in time.
Problem conclusion
Problem fixed iFix available on top of V7004
Temporary fix
Comments
APAR Information
APAR number
IV07044
Reported component name
BUS PRC CHOREOG
Reported component ID
5655FLW11
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-08-30
Closed date
2011-11-08
Last modified date
2011-11-08
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
BUS PRC CHOREOG
Fixed component ID
5655FLW11
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS7J6S","label":"WebSphere Enterprise Service Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 September 2024