criteria: {operator:"and",_constructor:"AdvancedCriteria",criteria:[{fieldName:"II0_STATUS",operator:"inSet",value:["COMPLETED","DRAFT","NOTCOMPLETE","RETURNED_APPROVER","PENDING"]},{value:["019","037","042","044"],operator:"inSet",fieldName:"II0_ISSUE_DEPARTMENT"},{value:"CSRT",operator:"equals",fieldName:"II0_DOC_TYPE"}]} values: {operator:"and",_constructor:"AdvancedCriteria",criteria:[{fieldName:"II0_STATUS",operator:"inSet",value:["COMPLETED","DRAFT","NOTCOMPLETE","RETURNED_APPROVER","PENDING"]},{value:["019","037","042","044"],operator:"inSet",fieldName:"II0_ISSUE_DEPARTMENT"},{value:"CSRT",operator:"equals",fieldName:"II0_DOC_TYPE"}]} [12/3/13 13:19:20:424 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,424 [ : 3] INFO SQLDataSource - [builtinApplication.listByEditor] derived query: SELECT II0_ID, II0_MODE, II0_DOC_TYPE, II0_DOC_NUMBER, II0_DOC_SUB_TYPE_V, II0_DOC_HEADER, II0_DOC_DESCRIPTION, II0_REQ_DEPARTMENT, II0_REQ_SECTION_ID, II0_REQ_UNIT_ID, II0_ISSUE_DEPARTMENT, II0_WAREHOUSE_NUMBER, II0_STATUS, II0_LOCK_ID, II0_IS_LINKED, II0_LINKED_DOC_TYPE, II0_LINKED_DOC_KEY, II0_CREATED_USER_ID, II0_CREATED_USER_ROLE, II0_CREATED_USER_SMP, II0_LASTUPDATED_USER_ID, II0_LASTUPDATED_USER_ROLE, II0_LASTUPDATED_USER_SMP, (SELECT AT0_USER_REMARKS FROM EAD.VAT0_AUDIT_TRAIL_MAIN WHERE EAD.VAT0_AUDIT_TRAIL_MAIN.AT0_DOCUMENT_NUMBER = EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_NUMBER ORDER BY AT0_TIME_STAMP DESC FETCH FIRST 1 ROWS ONLY) FEEDBACK FROM EAD.VII0_ISSUE_ITEM_MAIN WHERE ($defaultWhereClause) AND (( EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = 'D' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ID = $session.user.name and EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ROLE = $session.user.currentRole.name ) OR (EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = '0' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ID NOT IN (SELECT EAD.VII0_ISSUE_ITEM_MAIN.II0_ID FROM EAD.VII0_ISSUE_ITEM_MAIN a WHERE a.II0_ID = EAD.VII0_ISSUE_ITEM_MAIN.II0_ID AND a.II0_MODE='D' AND a.II0_LASTUPDATED_USER_ID = $session.user.name AND a.II0_LASTUPDATED_USER_ROLE = $session.user.currentRole.name ))) [12/3/13 13:19:20:424 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,424 [ : 3] DEBUG SQLDataSource - [builtinApplication.listByEditor] Executing row count query: SELECT COUNT(*) FROM EAD.VII0_ISSUE_ITEM_MAIN WHERE ($defaultWhereClause) AND (( EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = 'D' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ID = $session.user.name and EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ROLE = $session.user.currentRole.name ) OR (EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = '0' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ID NOT IN (SELECT EAD.VII0_ISSUE_ITEM_MAIN.II0_ID FROM EAD.VII0_ISSUE_ITEM_MAIN a WHERE a.II0_ID = EAD.VII0_ISSUE_ITEM_MAIN.II0_ID AND a.II0_MODE='D' AND a.II0_LASTUPDATED_USER_ID = $session.user.name AND a.II0_LASTUPDATED_USER_ROLE = $session.user.currentRole.name ))) [12/3/13 13:19:20:424 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,424 [ : 3] DEBUG SQLDataSource - [builtinApplication.listByEditor] Eval'd row count query: SELECT COUNT(*) FROM EAD.VII0_ISSUE_ITEM_MAIN WHERE ((((EAD.VII0_ISSUE_ITEM_MAIN.II0_STATUS IN ('COMPLETED', 'DRAFT', 'NOTCOMPLETE', 'RETURNED_APPROVER', 'PENDING')) AND EAD.VII0_ISSUE_ITEM_MAIN.II0_STATUS IS NOT NULL) AND ((EAD.VII0_ISSUE_ITEM_MAIN.II0_ISSUE_DEPARTMENT IN ('019', '037', '042', '044')) AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ISSUE_DEPARTMENT IS NOT NULL) AND (EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_TYPE = 'CSRT' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_TYPE IS NOT NULL))) AND (( EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = 'D' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ID = '00001' and EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ROLE = 'STRCTLOFFC' ) OR (EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = '0' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ID NOT IN (SELECT EAD.VII0_ISSUE_ITEM_MAIN.II0_ID FROM EAD.VII0_ISSUE_ITEM_MAIN a WHERE a.II0_ID = EAD.VII0_ISSUE_ITEM_MAIN.II0_ID AND a.II0_MODE='D' AND a.II0_LASTUPDATED_USER_ID = '00001' AND a.II0_LASTUPDATED_USER_ROLE = 'STRCTLOFFC' ))) [12/3/13 13:19:20:424 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,424 [ : 3] DEBUG SQLConnectionManager - [builtinApplication.listByEditor] Borrowed connection '806891544' [12/3/13 13:19:20:424 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,424 [ : 3] DEBUG SQLDriver - [builtinApplication.listByEditor] About to execute SQL query in 'EAD' using connection '806891544' [12/3/13 13:19:20:424 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,424 [ : 3] INFO SQLDriver - [builtinApplication.listByEditor] Executing SQL query on 'EAD': SELECT COUNT(*) FROM EAD.VII0_ISSUE_ITEM_MAIN WHERE ((((EAD.VII0_ISSUE_ITEM_MAIN.II0_STATUS IN ('COMPLETED', 'DRAFT', 'NOTCOMPLETE', 'RETURNED_APPROVER', 'PENDING')) AND EAD.VII0_ISSUE_ITEM_MAIN.II0_STATUS IS NOT NULL) AND ((EAD.VII0_ISSUE_ITEM_MAIN.II0_ISSUE_DEPARTMENT IN ('019', '037', '042', '044')) AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ISSUE_DEPARTMENT IS NOT NULL) AND (EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_TYPE = 'CSRT' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_TYPE IS NOT NULL))) AND (( EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = 'D' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ID = '00001' and EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ROLE = 'STRCTLOFFC' ) OR (EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = '0' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ID NOT IN (SELECT EAD.VII0_ISSUE_ITEM_MAIN.II0_ID FROM EAD.VII0_ISSUE_ITEM_MAIN a WHERE a.II0_ID = EAD.VII0_ISSUE_ITEM_MAIN.II0_ID AND a.II0_MODE='D' AND a.II0_LASTUPDATED_USER_ID = '00001' AND a.II0_LASTUPDATED_USER_ROLE = 'STRCTLOFFC' ))) [12/3/13 13:19:20:440 AST] 00000020 SystemOut O === 2013-12-03 13:19:20,440 [ : 4] DEBUG SQLConnectionManager - About to close PoolableConnection with hashcode "197921740" [12/3/13 13:19:20:440 AST] 00000020 SystemOut O === 2013-12-03 13:19:20,440 [ : 4] INFO Compression - /ERP/isomorphic/IDACall: 14273 -> 2298 bytes [12/3/13 13:19:20:440 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,440 [ : 3] DEBUG SQLTransform - [builtinApplication.listByEditor] isBeforeFirst()/isAfterLast() throwing exceptions - attempting workaround [12/3/13 13:19:20:440 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,440 [ : 3] DEBUG SQLDataSource - [builtinApplication.listByEditor] JDBC driver windowed select rows 0->13, result size 13. Query: SELECT II0_ID, II0_MODE, II0_DOC_TYPE, II0_DOC_NUMBER, II0_DOC_SUB_TYPE_V, II0_DOC_HEADER, II0_DOC_DESCRIPTION, II0_REQ_DEPARTMENT, II0_REQ_SECTION_ID, II0_REQ_UNIT_ID, II0_ISSUE_DEPARTMENT, II0_WAREHOUSE_NUMBER, II0_STATUS, II0_LOCK_ID, II0_IS_LINKED, II0_LINKED_DOC_TYPE, II0_LINKED_DOC_KEY, II0_CREATED_USER_ID, II0_CREATED_USER_ROLE, II0_CREATED_USER_SMP, II0_LASTUPDATED_USER_ID, II0_LASTUPDATED_USER_ROLE, II0_LASTUPDATED_USER_SMP, (SELECT AT0_USER_REMARKS FROM EAD.VAT0_AUDIT_TRAIL_MAIN WHERE EAD.VAT0_AUDIT_TRAIL_MAIN.AT0_DOCUMENT_NUMBER = EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_NUMBER ORDER BY AT0_TIME_STAMP DESC FETCH FIRST 1 ROWS ONLY) FEEDBACK FROM EAD.VII0_ISSUE_ITEM_MAIN WHERE ((((EAD.VII0_ISSUE_ITEM_MAIN.II0_STATUS IN ('COMPLETED', 'DRAFT', 'NOTCOMPLETE', 'RETURNED_APPROVER', 'PENDING')) AND EAD.VII0_ISSUE_ITEM_MAIN.II0_STATUS IS NOT NULL) AND ((EAD.VII0_ISSUE_ITEM_MAIN.II0_ISSUE_DEPARTMENT IN ('019', '037', '042', '044')) AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ISSUE_DEPARTMENT IS NOT NULL) AND (EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_TYPE = 'CSRT' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_DOC_TYPE IS NOT NULL))) AND (( EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = 'D' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ID = '00001' and EAD.VII0_ISSUE_ITEM_MAIN.II0_LASTUPDATED_USER_ROLE = 'STRCTLOFFC' ) OR (EAD.VII0_ISSUE_ITEM_MAIN.II0_MODE = '0' AND EAD.VII0_ISSUE_ITEM_MAIN.II0_ID NOT IN (SELECT EAD.VII0_ISSUE_ITEM_MAIN.II0_ID FROM EAD.VII0_ISSUE_ITEM_MAIN a WHERE a.II0_ID = EAD.VII0_ISSUE_ITEM_MAIN.II0_ID AND a.II0_MODE='D' AND a.II0_LASTUPDATED_USER_ID = '00001' AND a.II0_LASTUPDATED_USER_ROLE = 'STRCTLOFFC' ))) [12/3/13 13:19:20:440 AST] 00000020 LocalTranCoor W WLTC0033W: Resource jdbc/erp rolled back in cleanup of LocalTransactionContainment. [12/3/13 13:19:20:456 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,456 [ : 3] DEBUG SQLDataSource - [builtinApplication.listByEditor] Using paging strategy 'jdbcScroll' - scrolling to absolute position 1 [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,456 [ : 3] DEBUG DataSourceDMI - Invocation threw exception com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10120][10898] Invalid operation: result set is closed. at com.ibm.db2.jcc.c.wf.mb(wf.java:3193) at com.ibm.db2.jcc.c.wf.h(wf.java:1639) at com.ibm.db2.jcc.c.wf.absolute(wf.java:1627) at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.absolute(WSJdbcResultSet.java:164) at org.apache.commons.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.java:373) at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2308) at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1540) at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:408) at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:352) at com.isomorphic.datasource.DataSource.execute(DataSource.java:1447) at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:723) at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658) at com.isomorphic.application.AppBase.execute(AppBase.java:491) at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2431) at qa.gov.moi.erp.web.dmi.CustodyReturnMainDMI.fetch(CustodyReturnMainDMI.java:42) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:599) at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:973) at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:416) at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2427) at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:215) at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:172) at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:137) at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1449) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1384) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131) at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:852) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:785) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527) [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,534 [ : 3] WARN RequestContext - dsRequest.execute() failed: com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][10120][10898] Invalid operation: result set is closed. at com.ibm.db2.jcc.c.wf.mb(wf.java:3193) at com.ibm.db2.jcc.c.wf.h(wf.java:1639) at com.ibm.db2.jcc.c.wf.absolute(wf.java:1627) at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.absolute(WSJdbcResultSet.java:164) at org.apache.commons.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.java:373) at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2308) at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1540) at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:408) at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:352) at com.isomorphic.datasource.DataSource.execute(DataSource.java:1447) at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:723) at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658) at com.isomorphic.application.AppBase.execute(AppBase.java:491) at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2431) at qa.gov.moi.erp.web.dmi.CustodyReturnMainDMI.fetch(CustodyReturnMainDMI.java:42) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:599) at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:973) at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:416) at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64) at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2427) at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:215) at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:172) at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:137) at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:738) at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1449) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1384) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131) at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:852) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:785) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527) [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,534 [ : 3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,534 [ : 3] DEBUG RPCManager - non-DMI response, dropExtraFields: false [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,534 [ : 3] DEBUG SQLDriver - Freeing SQLDriver dbConnection 806891544 [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,534 [ : 3] DEBUG SQLConnectionManager - About to close PoolableConnection with hashcode "806891544" [12/3/13 13:19:20:534 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,534 [ : 3] INFO Compression - /ERP/isomorphic/IDACall: 191 -> 166 bytes [12/3/13 13:19:20:534 AST] 00000020 MCWrapper E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection WSRdbManagedConnectionImpl@36863686 from resource jdbc/erp. 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.(DataStoreAdapterException.java:251) at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.(DataStoreAdapterException.java:200) at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:407) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4403) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:3853) at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1511) at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:489) at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1812) at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2356) at com.ibm.ejs.j2c.LocalTransactionWrapper.afterCompletion(LocalTransactionWrapper.java:1230) at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.driveSynchronization(LocalTranCoordImpl.java:1692) at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.informSynchronizations(LocalTranCoordImpl.java:1590) at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:1307) at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.end(LocalTranCoordImpl.java:1419) at com.ibm.ws.webcontainer.collaborator.WebAppTransactionCollaboratorImpl.postInvoke(WebAppTransactionCollaboratorImpl.java:331) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:1042) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:859) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527) [12/3/13 13:19:20:721 AST] 00000020 LocalTranCoor W WLTC0032W: One or more local transaction resources were rolled back during the cleanup of a LocalTransactionContainment. [12/3/13 13:19:20:940 AST] 0000001f SystemOut O === 2013-12-03 13:19:20,940 [ : 3] INFO Download - Returning 304: Not modified on conditional get of: D:\WorkSpace\SVN\29Oct2013\ERPWeb\WebContent\isomorphic\skins\TreeFrog\images\opacity.png