dcsimg
Help!! Regarding Global Transaction Exception
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Belde_Chandrakanth
Posted On:   Thursday, January 27, 2005 09:11 PM

Hi, I am working on task of making my product to run on websphere app server version 6. I am getting this following exception while calling conn.preparedStatement(sqlstr). This situation is on the latest Trail version of Websphere 6 . In earlier version of this(i.e., in Developer version it has not came). [1/21/05 19:36:20:812 IST] 00000058 MCWrapper E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection WSRdbManagedConnectionImpl@1cc2c726 from resource jdbc/BBEDataSource. Caught exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction   More>>

Hi,

I am working on task of making my product to run on websphere app server version 6. I am getting this following exception while calling conn.preparedStatement(sqlstr). This situation is on the latest Trail version of Websphere 6 . In earlier version of this(i.e., in Developer version it has not came).
[1/21/05 19:36:20:812 IST] 00000058 MCWrapper E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection WSRdbManagedConnectionImpl@1cc2c726 from resource jdbc/BBEDataSource. Caught exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction..
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException. (DataStor eAdapterException.java:224)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException. (DataStor eAdapterException.java:175)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.ja va:232)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbMa nagedConnectionImpl.java:3262)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnect ionImpl.java:2902)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1331)
at com.ibm.ejs.j2c.poolmanager.FreePool.cleanupAndDestroyMCWrapper(FreePool.java:6 18)
at com.ibm.ejs.j2c.poolmanager.FreePool.returnToFreePool(FreePool.java:427)
at com.ibm.ejs.j2c.poolmanager.PoolManager.release(PoolManager.java:1471)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:1860)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:662 )
at com.ibm.ejs.j2c.ConnectionEventListener.localTransactionStarted(ConnectionEvent Listener.java:574)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processLocalTransactionStar tedEvent(WSRdbManagedConnectionImpl.java:1660)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginLocalTransactionIfNecessary(WSJ dbcConnection.java:447)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcCo nnection.java:608)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.ja va:1827)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.ja va:1782)
at com.stc.eindex.ops.ObjectPersistenceService.getStatement(ObjectPersistenceServi ce.java:74)
at com.stc.eindex.ops.EnterpriseDB.get(EnterpriseDB.java:108)
at com.stc.eindex.ejb.ops.TransactionMgrBean.getEnterpriseObject(TransactionMgrBea n.java:112)
at com.stc.eindex.ejb.ops.EJSLocalStatelessTransactionMgrEJB_a5d56077.getEnterpris eObject(Unknown Source)
at com.stc.eindex.ejb.master.MasterControllerEJB.getEnterpriseObject(MasterControl lerEJB.java:298)
at com.stc.eindex.ejb.master.EJSRemoteStatelessMasterController_c7831b90.getEnterp riseObject(Unknown Source)
at com.stc.eindex.ejb.master._MasterController_Stub.getEnterpriseObject(_MasterCon troller_Stub.java:608)
at com.stc.eindex.qws.forms.EOViewEditForm.setEuid(EOViewEditForm.java:767)
at com.stc.eindex.qws.forms.EOViewEditForm.processAction(EOViewEditForm.java:984)
at com.stc.eindex.qws.actions.LeaveEOViewEditAction.doPerform(LeaveEOViewEditActio n.java:94)
at com.stc.eindex.qws.actions.QwsBaseAction.execute(QwsBaseAction.java:123)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor .java:446)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212 )
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.jav a:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletW rapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpI nboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpI nboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCa llback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.j ava:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:60 1)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:93 4)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1 021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)

[1/21/05 19:36:20:875 IST] 00000058 LocalTransact E J2CA0030E: Method enlist caught java.lang.IllegalStateException: Cannot enlist Resource for cleanup. A Global transaction is active. at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.enlistForCleanup(LocalTranCoordI mpl.java:489)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:646 )
at com.ibm.ejs.j2c.ConnectionEventListener.localTransactionStarted(ConnectionEvent Listener.java:574)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processLocalTransactionStar tedEvent(WSRdbManagedConnectionImpl.java:1660)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginLocalTransactionIfNecessary(WSJ dbcConnection.java:447)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcCo nnection.java:608)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.ja va:1827)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.ja va:1782)
at com.stc.eindex.ops.ObjectPersistenceService.getStatement(ObjectPersistenceServi ce.java:74)
at com.stc.eindex.ops.EnterpriseDB.get(EnterpriseDB.java:108)
at com.stc.eindex.ejb.ops.TransactionMgrBean.getEnterpriseObject(TransactionMgrBea n.java:112)
at com.stc.eindex.ejb.ops.EJSLocalStatelessTransactionMgrEJB_a5d56077.getEnterpris eObject(Unknown Source)
at com.stc.eindex.ejb.master.MasterControllerEJB.getEnterpriseObject(MasterControl lerEJB.java:298)
at com.stc.eindex.ejb.master.EJSRemoteStatelessMasterController_c7831b90.getEnterp riseObject(Unknown Source)
at com.stc.eindex.ejb.master._MasterController_Stub.getEnterpriseObject(_MasterCon troller_Stub.java:608)
at com.stc.eindex.qws.forms.EOViewEditForm.setEuid(EOViewEditForm.java:767)
at com.stc.eindex.qws.forms.EOViewEditForm.processAction(EOViewEditForm.java:984)
at com.stc.eindex.qws.actions.LeaveEOViewEditAction.doPerform(LeaveEOViewEditActio n.java:94)
at com.stc.eindex.qws.actions.QwsBaseAction.execute(QwsBaseAction.java:123)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor .java:446)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212 )
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.jav a:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletW rapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpI nboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpI nboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCa llback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.j ava:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:60 1)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:93 4)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1 021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
while trying to enlist resources from datasource jdbc/BBEDataSource with the Transaction Manager for the current transaction, and threw a Exception.
[1/21/05 19:36:20:938 IST] 00000058 ConnectionEve E J2CA0074E: Unable to enlist connection from resource jdbc/BBEDataSource with current transaction in method localTransactionStarted due to exception. Initiating destruction of connection. Exception is: javax.resource.ResourceException: enlist: caught Exception
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:666 )
at com.ibm.ejs.j2c.ConnectionEventListener.localTransactionStarted(ConnectionEvent Listener.java:574)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processLocalTransactionStar tedEvent(WSRdbManagedConnectionImpl.java:1660)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginLocalTransactionIfNecessary(WSJ dbcConnection.java:447)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcCo nnection.java:608)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.ja va:1827)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.ja va:1782)
at com.stc.eindex.ops.ObjectPersistenceService.getStatement(ObjectPersistenceServi ce.java:74)
at com.stc.eindex.ops.EnterpriseDB.get(EnterpriseDB.java:108)
at com.stc.eindex.ejb.ops.TransactionMgrBean.getEnterpriseObject(TransactionMgrBea n.java:112)
at com.stc.eindex.ejb.ops.EJSLocalStatelessTransactionMgrEJB_a5d56077.getEnterpris eObject(Unknown Source)
at com.stc.eindex.ejb.master.MasterControllerEJB.getEnterpriseObject(MasterControl lerEJB.java:298)
at com.stc.eindex.ejb.master.EJSRemoteStatelessMasterController_c7831b90.getEnterp riseObject(Unknown Source)
at com.stc.eindex.ejb.master._MasterController_Stub.getEnterpriseObject(_MasterCon troller_Stub.java:608)
at com.stc.eindex.qws.forms.EOViewEditForm.setEuid(EOViewEditForm.java:767)
at com.stc.eindex.qws.forms.EOViewEditForm.processAction(EOViewEditForm.java:984)
at com.stc.eindex.qws.actions.LeaveEOViewEditAction.doPerform(LeaveEOViewEditActio n.java:94)
at com.stc.eindex.qws.actions.QwsBaseAction.execute(QwsBaseAction.java:123)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor .java:446)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212 )
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.jav a:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletW rapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpI nboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpI nboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCa llback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.j ava:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:60 1)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:93 4)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1 021)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
Caused by: java.lang.IllegalStateException: Cannot enlist Resource for cleanup. A Global transaction is active.
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.enlistForCleanup(LocalTranCoordI mpl.java:489)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:646 )
... 36 more

[1/21/05 19:36:21:000 IST] 00000058 ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for resource jdbc/BBEDataSource. The exception which was received is null

I am using session beans with Bean Managed Transactions. I have specified Local transaction element for every session bean in Application Extension file(ibm-ejb-jar.ext.xmi).
If I am not giving this local transaction element in .ext file I am getting CSITransactionRollbackException..
Please help in this Regards!!.

   <<Less

Re: Help!! Regarding Global Transaction Exception

Posted By:   Anonymous  
Posted On:   Sunday, February 6, 2005 01:07 PM

It could 'coz of transactional attributes u specified in DDs or 'coz of a problem in connection pool.Check these two things


GLuck
About | Sitemap | Contact