Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Error : Attempt to continue working after transaction rolledback !

    Hi,

    SomeTimes while I am testing my application I getting the following error

    Code:
    java.lang.IllegalStateException: Attempt to continue working after transaction rolledback !
    
                    at com.ibm.ejs.j2c.ConnectionEventListener.localTransactionStarted(ConnectionEventListener.java:882) ~[com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processLocalTransactionStartedEvent(WSRdbManagedConnectionImpl.java:2012) ~[com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginLocalTransactionIfNecessary(WSJdbcConnection.java:596) ~[com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:794) ~[com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:1642) ~[com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.createStatement(WSJdbcConnection.java:1620) ~[com.ibm.ws.runtime.jar:na]
    
                    at org.apache.commons.dbcp.DelegatingConnection.createStatement(DelegatingConnection.java:257) ~[isc_commons-dbcp-1.3.jar:1.3]
    
                    at com.isomorphic.sql.SQLDriver.createFetchStatement(SQLDriver.java:1439) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:599) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:913) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:521) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:515) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1546) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:408) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:352) ~[isc_isomorphic_sql.jar:na]
    
                    at com.isomorphic.datasource.DataSource.execute(DataSource.java:1447) ~[isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:723) ~[isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658) ~[isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.application.AppBase.execute(AppBase.java:491) ~[isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2431) [isc_isomorphic_core_rpc.jar:na]
    
                    at qa.gov.moi.erp.web.dmi.DepartmentMainDMI.fetch(DepartmentMainDMI.java:46) ~[classes/:na]
    
                    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0]
    
                    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48) ~[na:1.6.0]
    
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0]
    
                    at java.lang.reflect.Method.invoke(Method.java:600) ~[na:1.6.0]
    
                    at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:973) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:416) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2427) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:215) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:172) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:137) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73) [isc_isomorphic_core_rpc.jar:na]
    
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) [javax.j2ee.servlet.jar:na]
    
                    at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152) [isc_isomorphic_core_rpc.jar:na]
    
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) [javax.j2ee.servlet.jar:na]
    
                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260) [isc_isomorphic_core_rpc.jar:na]
    
                    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191) [com.ibm.ws.webcontainer.jar:na]
    
                    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453) [com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515) [com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306) [com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:277) [com.ibm.ws.runtime.jar:na]
    
                    at com.ibm.ws390.channel.xmem.XMemConnLink.ready(XMemConnLink.java:858) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws390.channel.xmem.XMemInboundChannel.handleRequest(XMemInboundChannel.java:340) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws390.xmem.XMemSRBridgeImpl.httpinvoke(XMemSRBridgeImpl.java:104) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws390.xmem.XMemSRCppUtilities.httpinvoke(XMemSRCppUtilities.java:74) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws390.orb.ServerRegionBridge.httpinvoke(ServerRegionBridge.java:215) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws390.orb.ORBEJSBridge.httpinvoke(ORBEJSBridge.java:281) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) ~[na:na]
    
                    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0]
    
                    at java.lang.reflect.Method.invoke(Method.java:600) ~[na:1.6.0]
    
                    at com.ibm.ws390.orb.parameters.HTTPInvoke.HTTPInvokeParmSetter(HTTPInvoke.java:101) [bootstrapws390.jar:WAS70.SERV1 [cf291321.01]]
    
                    at com.ibm.ws390.orb.CommonBridge.nativeRunApplicationThread(Native Method) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws390.orb.CommonBridge.runApplicationThread(CommonBridge.java:472) [com.ibm.ws.runtime.ws390.jar:na]
    
                    at com.ibm.ws.util.ThreadPool$ZOSWorker.run(ThreadPool.java:1864) [com.ibm.ws.runtime.jar:na]
    Any hint or comments ?


    We are working on the below environment:

    Version:Isomorphic SmartClient/SmartGWT Framework (v9.0p_2013-10-26/PowerEdition Deployment 2013-10-26)

    Browser: Internet Explorer 8

    Server: WebSphere 7.0

    Database : DB2

    OS : Z/OS

    #2
    Assuming you're using the Automatic Transactions feature, this suggests that you've got a queue of requests, one of them has failed, causing transaction rollback, and yet you've got logic in a DMI that still tries to execute a request after this failure has occurred:

    at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2431) [isc_isomorphic_core_rpc.jar:na]

    at qa.gov.moi.erp.web.dmi.DepartmentMainDMI.fetch(DepartmentMainDMI.java:46) ~[classes/:na]
    You can check for the condition of a failure earlier in the queue via the server-side API RPCManager.queueHasFailures().

    Comment


      #3
      do you mean by the "Automatic Transactions feature" the autoJoinTransactions. in my server.properties I am not setting the value of the autoJoinTransactions and not in my code as well. so autoJoinTransactions is kept as the default value

      please to elaborate as this is urgent issue

      Comment


        #4
        For urgent issues, be sure to provide as much information as you can, make good use of the docs, and thoroughly investigate possibly causes that are raised by Support.

        This is the most important aspect of solving your problems quickly, as we will not be able to do much for you if you provide information that is too limited, and of course the problem will not get closer to resolution if you ignore Support's advice.

        Yes, we were referring to the autoJoinTransactions feature. It is automatically on (as the documentation tells you) unless you've disabled it. You haven't provided complete server logs (as the forums reminds you to do every time), otherwise, we would have been able to see clearly from the logs whether the feature is enabled.

        As far as the issue you're having, here again is the possible cause we suggested:

        Assuming you're using the Automatic Transactions feature, this suggests that you've got a queue of requests, one of them has failed, causing transaction rollback, and yet you've got logic in a DMI that still tries to execute a request after this failure has occurred
        With the information you've provided, we can't investigate this possible cause, but you can.

        Comment

        Working...
        X