Topic
  • 1 reply
  • Latest Post - ‏2013-05-06T19:00:36Z by PRF9_sandeep_ambula
SystemAdmin
SystemAdmin
3556 Posts

Pinned topic DB table is getting locked and the following exception is displayed

‏2012-10-25T11:59:26Z |
While updating the rows in sql server using websphere integration developer6.2,I am getting the following error.Can anyone please suggest to fix the isssue

SQL Exception: A lock could not be obtained within the time requested
10/23/12 12:15:01:827 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl initialize FFDC0009I: FFDC opened incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.01_0.txt
10/23/12 12:15:02:124 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.01_0.txt
10/23/12 12:15:02:124 BOT 0000008d WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
10/23/12 12:15:02:124 BOT 0000008d WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XA_RBTIMEOUT (106). Exception is: <null>
10/23/12 12:15:02:155 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.02_0.txt
10/23/12 12:15:02:171 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.02_0.txt
10/23/12 12:15:02:171 BOT 0000008d XATransaction E J2CA0027E: An exception occurred while invoking end on an XA Resource Adapter from dataSource jdbc/BPEDB, within transaction ID {XidImpl: formatId(57415344), gtrid_length(36), bqual_length(54), data(0000013a8e66f053000000090000009cb014bff4f78a4ca6fbb88b78c4b1c2a7277e243f0000013a8e66f053000000090000009cb014bff4f78a4ca6fbb88b78c4b1c2a7277e243f000000010000000000000000000000000002)}: javax.transaction.xa.XAException
at org.apache.derby.jdbc.EmbedXAConnection.end(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.end(WSRdbXaResourceImpl.java:556)
at com.ibm.ejs.j2c.XATransactionWrapper.end(XATransactionWrapper.java:574)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.end(JTAResourceBase.java:237)
at com.ibm.ws.Transaction.JTA.RegisteredResources.sendEnd(RegisteredResources.java:1358)
at com.ibm.ws.Transaction.JTA.RegisteredResources.distributeEnd(RegisteredResources.java:1332)
at com.ibm.ws.Transaction.JTA.TransactionImpl.internalRollback(TransactionImpl.java:2744)
at com.ibm.ws.Transaction.JTA.TransactionImpl.rollback(TransactionImpl.java:1941)
at com.ibm.ws.Transaction.JTA.TranManagerImpl.rollback(TranManagerImpl.java:290)
at com.ibm.ws.Transaction.JTA.TranManagerSet.rollback(TranManagerSet.java:196)
at com.ibm.ejs.csi.TranStrategy.rollback(TranStrategy.java:977)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:171)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:3988)
at com.ibm.ejs.container.MessageEndpointHandler.afterDelivery(MessageEndpointHandler.java:1353)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMessageEndpointMethod(MessageEndpointHandler.java:775)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:736)
at $Proxy8.afterDelivery(Unknown Source)
at com.ibm.ws.sib.ra.inbound.impl.SibRaTransactionalDispatcher.afterDelivery(SibRaTransactionalDispatcher.java:469)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:800)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:585)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
.
10/23/12 12:15:02:452 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.02_1.txt
10/23/12 12:15:02:468 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.02_1.txt
10/23/12 12:15:02:796 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl open FFDC0009I: FFDC opened incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.02_2.txt
10/23/12 12:15:02:811 BOT 0000008d ServiceLogger I com.ibm.ws.ffdc.IncidentStreamImpl resetIncidentStream FFDC0010I: FFDC closed incident stream file C:\Program Files\IBM\WID61\pf\wps\logs\ffdc\server1_0000008d_12.10.23_12.15.02_2.txt
10/23/12 12:16:02:827 BOT 00000092 BpelEngine I
SQL Exception: A lock could not be obtained within the time requested
10/23/12 12:16:02:827 BOT 00000092 WSRdbXaResour E DSRA0304E:
  • PRF9_sandeep_ambula
    PRF9_sandeep_ambula
    1 Post

    Re: DB table is getting locked and the following exception is displayed

    ‏2013-05-06T19:00:36Z  

    Hi,

    I am receiving the similar error as you mentioned above. Could you please let me know if you were able to fix the issue ? If yes how ? Thanks in advance.

    [5/6/13 9:37:32:645 PDT] 0000001d WSRdbXaResour E   DSRA0304E:  XAException occurred. XAException contents and details are: "".
    [5/6/13 9:37:32:648 PDT] 0000001d WSRdbXaResour E   DSRA0302E:  XAException occurred.  Error code is: XA_RBTIMEOUT (106).  Exception is: [jcc][10401][12067][3.53.95] XA exception: XA_RBTIMEOUT ERRORCODE=-422
    8, SQLSTATE=null
    [5/6/13 9:37:32:745 PDT] 0000001d XATransaction E   J2CA0027E: An exception occurred while invoking end on an XA Resource Adapter from DataSource jdbc/a*****2, within transaction ID {XidImpl: formatId(574153
    44), gtrid_length(36), bqual_length(54),
    data(0000013e7ab3876b000000010000000efe19bda16c842bd7074acd57d00d403727b622930000013e7ab3977f000000010000000427d2d5314776be9a39aa32abd54840799a4463b8000000010000000000000000000000000001)} : com.ibm.db2.jcc.b
    .qo: [jcc][10401][12067][3.53.95] XA exception: XA_RBTIMEOUT ERRORCODE=-4228, SQLSTATE=null
            at com.ibm.db2.jcc.b.bd.c(bd.java:453)
            at com.ibm.db2.jcc.b.bd.c(bd.java:477)
            at com.ibm.db2.jcc.uw.UWXAResource.a(UWXAResource.java:601)
            at com.ibm.db2.jcc.uw.UWXAResource.end(UWXAResource.java:179)
            at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.end(WSRdbXaResourceImpl.java:606)
            at com.ibm.ejs.j2c.XATransactionWrapper.end(XATransactionWrapper.java:603)
            at com.ibm.ws.Transaction.JTA.JTAResourceBase.end(JTAResourceBase.java:240)
            at com.ibm.tx.jta.RegisteredResources.sendEnd(RegisteredResources.java:1108)
            at com.ibm.tx.jta.RegisteredResources.distributeEnd(RegisteredResources.java:1082)
            at com.ibm.tx.jta.TransactionImpl.internalRollback(TransactionImpl.java:1950)
            at com.ibm.tx.jta.TransactionImpl.internalRollback(TransactionImpl.java:1915)
            at com.ibm.ws.Transaction.JTS.TransactionWrapper.rollback(TransactionWrapper.java:712)
            at com.ibm.ws.Transaction.JTS.WSCoordinatorImpl.rollback(WSCoordinatorImpl.java:179)
            at com.ibm.ws.Transaction.JTS._WSCoordinatorImplBase._invoke(_WSCoordinatorImplBase.java:67)
            at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:623)
            at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:476)
            at com.ibm.rmi.iiop.ORB.process(ORB.java:513)
            at com.ibm.CORBA.iiop.ORB.process(ORB.java:1574)
            at com.ibm.rmi.iiop.Connection.respondTo(Connection.java:2845)
            at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2718)
            at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:63)
            at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:118)
            at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)