Topic
No replies
SystemAdmin
SystemAdmin
3556 Posts
ACCEPTED ANSWER

Pinned topic Error message on system consol

‏2012-12-17T18:55:25Z |
Hi everybody,
Used environment:
WebSphere Process Server 7.0.0.4
WebSphere Application Server 7.0.0.21
Database : MS SQL server 2008

I am having the following error message on system consol. The same message is repeating on both process server nodes with different Id.Is there any solution to this problem? All applications seem to be working fine despite the error.

17.12.12 12:50:37:769 CET 00000066 LocalExceptio E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "invokeProcessSessionBean" on bean "BeanId(BPEContainer_CentralProcessServer.AppTarget#bpecontainer.jar#CScopeProvider, null)". Exception data: com.ibm.bpe.api.UnexpectedFailureException: CWWBA0010E: Unexpected exception during execution.
com.ibm.bpe.database.TomSQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 322) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.ibm.bpe.database.ActivityInstanceB.selectDbByPIIDATIDEHIIDnullEnclosingFEIIDnull(ActivityInstanceB.java:2182)
at com.ibm.bpe.database.Tom.getActivityInstanceB(Tom.java:12098)
at com.ibm.bpe.engine.BpelActivityKindComplexBegin.doActivate(BpelActivityKindComplexBegin.java:262)
at com.ibm.bpe.engine.BpelActivityStateInactive.activateOrSkip(BpelActivityStateInactive.java:280)
at com.ibm.bpe.engine.BpelEngineCore.continueControlLink(BpelEngineCore.java:291)
at com.ibm.bpe.engine.BpelContinueLinkMessage3.execute(BpelContinueLinkMessage3.java:88)
at com.ibm.bpe.engine.BpelEngine.onMessage(BpelEngine.java:1541)
at com.ibm.bpe.framework.GenericAPIServicesImpl$7.run(GenericAPIServicesImpl.java:440)
at com.ibm.bpe.framework.infrastructure.InfrastructureServicesSupportBean.runInCScopeTxClassLoaderContextsWithException(InfrastructureServicesSupportBean.java:167)
at com.ibm.bpe.framework.infrastructure.EJSLocalStatelessInfrastructureServicesSupportBea_70e9f9d4.runInCScopeTxClassLoaderContextsWithException(Unknown Source)
at com.ibm.bpe.framework.infrastructure.InfrastructureServicesImpl.runInCScopeTxClassLoaderContextsWithException(InfrastructureServicesImpl.java:350)
at com.ibm.bpe.framework.infrastructure.InfrastructureServicesImpl$2.run(InfrastructureServicesImpl.java:251)
at com.ibm.bpe.framework.sca.AbstractBPCImplementationHandler.handleInvocationEnvironmentRequest(AbstractBPCImplementationHandler.java:187)
at com.ibm.bpe.framework.sca.AbstractBPCImplementationHandler.processMessage(AbstractBPCImplementationHandler.java:130)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:755)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1607)
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java:980)
at com.ibm.ws.sca.internal.webmodule.handler.WebModuleContextSwitchHandler.processMessage(WebModuleContextSwitchHandler.java:146)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:766)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1607)
at com.ibm.ws.sca.internal.proxy.impl.ProxyInvocationHandlerImpl.invoke(ProxyInvocationHandlerImpl.java:783)
at $Proxy66.processMessage(Unknown Source)
at com.ibm.bpe.framework.sca.InvocationEnvironmentProviderImpl.runInInvocationEnvironment(InvocationEnvironmentProviderImpl.java:158)
at com.ibm.bpe.framework.infrastructure.InfrastructureServicesImpl.runInScaCScopeTxClassLoaderContextsWithException(InfrastructureServicesImpl.java:257)
at com.ibm.bpe.framework.GenericAPIServicesImpl.bpc_onMessage(GenericAPIServicesImpl.java:427)
at com.ibm.bpe.framework.navigation.CScopeProviderBean$1.run(CScopeProviderBean.java:168)
at java.security.AccessController.doPrivileged(AccessController.java:202)
at com.ibm.bpe.framework.navigation.CScopeProviderBean.invokeProcessSessionBean(CScopeProviderBean.java:165)
at com.ibm.bpe.framework.navigation.EJSLocalStatelessCScopeProvider_19c383f5.invokeProcessSessionBean(Unknown Source)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4ContextSwitch.processV6EngineMessage(NavigationWorkObject4ContextSwitch.java:409)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4ContextSwitch.processNextMessage(NavigationWorkObject4ContextSwitch.java:302)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4ContextSwitch.run(NavigationWorkObject4ContextSwitch.java:142)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:268)
at java.security.AccessController.doPrivileged(AccessController.java:202)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:768)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:86)
at com.ibm.bpe.framework.ProcessExecutionContextImpl$2.run(ProcessExecutionContextImpl.java:169)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.bpe.framework.ProcessExecutionContextImpl.go(ProcessExecutionContextImpl.java:159)
at com.ibm.bpe.framework.navigation.ProcessNavigationBean.processNextMessage(ProcessNavigationBean.java:345)
at com.ibm.bpe.framework.navigation.EJSLocalStatelessProcessNavigation_0f2917d9.processNextMessage(Unknown Source)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4WorkMgrThread.run(NavigationWorkObject4WorkMgrThread.java:103)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:268)
at java.security.AccessController.doPrivileged(AccessController.java:224)
at javax.security.auth.Subject.doAs(Subject.java:495)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:131)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:89)
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:335)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:777)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:159)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)

17.12.12 12:50:37:784 CET 00000066 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
17.12.12 12:50:37:800 CET 00000066 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_NOTA (-4). Exception is: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***"
17.12.12 12:50:37:800 CET 00000066 XATransaction E J2CA0027E: An exception occurred while invoking rollback on an XA Resource Adapter from DataSource jdbc/BPEDB, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54),
data(0000013ba8b387800000000300003b72eb62c55299d47fcb8ea4ff8798563fbd02af1fa00000013ba8b387800000000300003b72eb62c55299d47fcb8ea4ff8798563fbd02af1fa0000000010000000000000000000000000001)} : javax.transaction.xa.XAException: The function ROLLBACK: has failed. The status is: -4. Error: "*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***"
at java.lang.Throwable.<init>(Throwable.java:67)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQLServerXAResource.java:334)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.rollback(SQLServerXAResource.java:713)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.rollback(WSRdbXaResourceImpl.java:1319)
at com.ibm.ejs.j2c.XATransactionWrapper.rollback(XATransactionWrapper.java:1303)
at com.ibm.tx.jta.JTAXAResourceImpl.rollback(JTAXAResourceImpl.java:363)
at com.ibm.tx.jta.RegisteredResources.deliverOutcome(RegisteredResources.java:1647)
at com.ibm.tx.jta.RegisteredResources.distributeOutcome(RegisteredResources.java:1926)
at com.ibm.tx.jta.RegisteredResources.distributeRollback(RegisteredResources.java:2579)
at com.ibm.tx.jta.TransactionImpl.internalRollback(TransactionImpl.java:1952)
at com.ibm.tx.jta.TransactionImpl.internalRollback(TransactionImpl.java:1915)
at com.ibm.tx.jta.TransactionImpl.rollback(TransactionImpl.java:1317)
at com.ibm.ws.tx.jta.TransactionImpl.rollback(TransactionImpl.java:3704)
at com.ibm.ws.tx.jta.TranManagerImpl.rollback(TranManagerImpl.java:476)
at com.ibm.tx.jta.TranManagerSet.rollback(TranManagerSet.java:186)
at com.ibm.ws.tx.jta.UserTransactionImpl.rollback(UserTransactionImpl.java:398)
at com.ibm.ejs.container.UserTransactionWrapper.rollback(UserTransactionWrapper.java:425)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4ContextSwitch.processNextMessage(NavigationWorkObject4ContextSwitch.java:328)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4ContextSwitch.run(NavigationWorkObject4ContextSwitch.java:142)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:268)
at java.security.AccessController.doPrivileged(AccessController.java:202)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:768)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:86)
at com.ibm.bpe.framework.ProcessExecutionContextImpl$2.run(ProcessExecutionContextImpl.java:169)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.bpe.framework.ProcessExecutionContextImpl.go(ProcessExecutionContextImpl.java:159)
at com.ibm.bpe.framework.navigation.ProcessNavigationBean.processNextMessage(ProcessNavigationBean.java:345)
at com.ibm.bpe.framework.navigation.EJSLocalStatelessProcessNavigation_0f2917d9.processNextMessage(Unknown Source)
at com.ibm.bpe.framework.navigation.NavigationWorkObject4WorkMgrThread.run(NavigationWorkObject4WorkMgrThread.java:103)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:268)
at java.security.AccessController.doPrivileged(AccessController.java:224)
at javax.security.auth.Subject.doAs(Subject.java:495)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:131)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:89)
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:335)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:777)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:159)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)