Error While accessing ofbiz
Locked
 
|
Hi All,
I am getting following error while accessing ofbiz. The deployment is fine and it is not giving any error while starting the server but while accessing it is giving following Error. Please help. Unable to enlist XAResource org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b, errorCode: 0 javax.transaction.xa.XAException: Count not turn off auto commit for a XA transaction Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096. Below is the Detailed Log ---------------------------> Httpd started on port: 9989 Sessiond started on port: 9990 2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:100:INFO ] Started BeanShell telnet service on 9989, 9990 2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:101:INFO ] NOTICE: BeanShell service ports are not secure. Please protect the ports 2009-12-21 15:55:05,037 (org.ofbiz.service.jms.JmsListenerFactory@17eeb7e) [ JmsListenerFactory.java:75 :INFO ] JMS Listener Factory Thread Finished; All listeners connected. 2009-12-21 15:55:15,055 (org.ofbiz.service.job.JobPoller@223279) [ GenericDispatcher.java:61 :INFO ] Creating new dispatcher [JobDispatcher] (org.ofbiz.service.job.JobPoller@223279) 2009-12-21 15:55:15,747 (default-invoker-Thread-11) [ JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-11] received job [Auto-create Fixed Asset Maintenances] from poller [org.ofbiz.service.job.JobPoller@223279] 2009-12-21 15:55:15,747 (default-invoker-Thread-9) [ JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-9] received job [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] 2009-12-21 15:55:15,749 (default-invoker-Thread-7) [ JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-7] received job [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] 2009-12-21 15:55:15,750 (default-invoker-Thread-10) [ JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-10] received job [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] 2009-12-21 15:55:15,750 (default-invoker-Thread-8) [ JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-8] received job [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] 2009-12-21 15:55:16,171 (default-invoker-Thread-9) [ SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [JobSandbox]; curSeqId=65900, maxSeqId=66000, bankSize=100 2009-12-21 15:55:16,219 (default-invoker-Thread-7) [PersistedServiceJob.java:178:INFO ] org.ofbiz.service.job.PersistedServiceJob@e1b74e[65803] -- Next runtime: Mon Dec 21 16:10:15 IST 2009 2009-12-21 15:55:16,219 (default-invoker-Thread-11) [PersistedServiceJob.java:178:INFO ] org.ofbiz.service.job.PersistedServiceJob@b65057[65825] -- Next runtime: Mon Dec 21 16:00:15 IST 2009 2009-12-21 15:55:16,220 (default-invoker-Thread-8) [PersistedServiceJob.java:178:INFO ] org.ofbiz.service.job.PersistedServiceJob@165520d[65801] -- Next runtime: Mon Dec 21 16:10:15 IST 2009 2009-12-21 15:55:16,220 (default-invoker-Thread-9) [PersistedServiceJob.java:178:INFO ] org.ofbiz.service.job.PersistedServiceJob@ee0989[65800] -- Next runtime: Mon Dec 21 16:10:15 IST 2009 2009-12-21 15:55:16,222 (default-invoker-Thread-10) [PersistedServiceJob.java:178:INFO ] org.ofbiz.service.job.PersistedServiceJob@f183bd[65804] -- Next runtime: Mon Dec 21 16:10:15 IST 2009 2009-12-21 15:55:16,305 (default-invoker-Thread-8) [ AbstractEngine.java:73 :INFO ] Loaded Service Locations : [main-rmi=rmi://localhost:1099/RMIDispatcher, main-http= http://localhost:80/webtools/control/httpService, entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-http= http://localhost:8080/webtools/control/httpService, rita-rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test= http://localhost:8080/webtools/control/httpService] 2009-12-21 15:55:17,299 (default-invoker-Thread-8) [ ServiceDispatcher.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [1032] milliseconds 2009-12-21 15:55:17,303 (default-invoker-Thread-10) [ ServiceDispatcher.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [1027] milliseconds 2009-12-21 15:55:17,308 (default-invoker-Thread-9) [ ServiceDispatcher.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [1038] milliseconds 2009-12-21 15:55:17,364 (default-invoker-Thread-11) [ Log.java:111:INFO ] [CommonPermissionServices.xml#genericBasePermissionCheck] Checking for primary permission ACCOUNTING_CREATE 2009-12-21 15:55:17,389 (default-invoker-Thread-11) [ ServiceEcaRule.java:134:INFO ] For Service ECA [fixedAssetPermissionCheck] on [return] got false for condition: [hasPermission][equals][false][true][Boolean] 2009-12-21 15:55:17,389 (default-invoker-Thread-11) [ ServiceDispatcher.java:586:INFO ] Sync service [JobDispatcher/fixedAssetPermissionCheck] finished in [1060] milliseconds 2009-12-21 15:55:17,403 (default-invoker-Thread-7) [ ServiceDispatcher.java:586:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [1133] milliseconds 2009-12-21 15:55:17,511 (default-invoker-Thread-11) [ ServiceDispatcher.java:586:INFO ] Sync service [JobDispatcher/createMaintsFromTimeInterval] finished in [1241] milliseconds 2009-12-21 15:56:35,573 (org.ofbiz.service.job.JobPoller@223279) [ TransactionImpl.java:212:WARN ] Unable to enlist XAResource org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b, errorCode: 0 javax.transaction.xa.XAException: Count not turn off auto commit for a XA transaction at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) at org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) at org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) at java.lang.Thread.run(Thread.java:619) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source) at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) ... 21 more 2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,626 (org.ofbiz.service.job.JobPoller@223279) [ GenericDelegator.java:1290:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,627 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:322:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,628 (org.ofbiz.service.job.JobPoller@223279) [ JobManager.java:187:ERROR] ---- exception report ---------------------------------------------------------- Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction)]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,630 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:286:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) org.ofbiz.service.job.JobManager.poll(JobManager.java:190) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction rolled back 2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6) 2009-12-21 15:56:35,632 (org.ofbiz.service.job.JobPoller@223279) [ TransactionImpl.java:212:WARN ] Unable to enlist XAResource org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@1d69f44, errorCode: 0 javax.transaction.xa.XAException: Count not turn off auto commit for a XA transaction at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) at org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) at org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) at java.lang.Thread.run(Thread.java:619) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(1) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], IO:80c2b, Dbc:29dc5]. PktNum:0. TotalReceived:0. PktSize:4,096. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source) at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) ... 21 more 2009-12-21 15:56:35,654 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ GenericDelegator.java:1290:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:322:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ JobManager.java:187:ERROR] ---- exception report ---------------------------------------------------------- Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction)]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:286:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) org.ofbiz.service.job.JobManager.poll(JobManager.java:190) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction rolled back 2009-12-21 15:56:35,658 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6) 2009-12-21 15:56:35,659 (org.ofbiz.service.job.JobPoller@223279) [ TransactionImpl.java:212:WARN ] Unable to enlist XAResource org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@532d42, errorCode: 0 javax.transaction.xa.XAException: Count not turn off auto commit for a XA transaction at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) at org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) at org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) at java.lang.Thread.run(Thread.java:619) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(3) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], IO:e3a05, Dbc:4611a]. PktNum:0. TotalReceived:0. PktSize:4,096. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source) at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) ... 21 more 2009-12-21 15:56:35,663 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ GenericDelegator.java:1290:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,666 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:322:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ JobManager.java:187:ERROR] ---- exception report ---------------------------------------------------------- Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction)]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:286:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) org.ofbiz.service.job.JobManager.poll(JobManager.java:190) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction rolled back 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6) 2009-12-21 15:56:35,687 (org.ofbiz.service.job.JobPoller@223279) [ TransactionImpl.java:212:WARN ] Unable to enlist XAResource org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@662c35, errorCode: 0 javax.transaction.xa.XAException: Count not turn off auto commit for a XA transaction at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) at org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) at org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) at java.lang.Thread.run(Thread.java:619) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(4) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], IO:07975, Dbc:305e8]. PktNum:0. TotalReceived:0. PktSize:4,096. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source) at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) ... 21 more 2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ GenericDelegator.java:1290:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:322:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ JobManager.java:187:ERROR] ---- exception report ---------------------------------------------------------- Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction)]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:286:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) org.ofbiz.service.job.JobManager.poll(JobManager.java:190) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction rolled back 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6) 2009-12-21 15:56:35,716 (org.ofbiz.service.job.JobPoller@223279) [ TransactionImpl.java:212:WARN ] Unable to enlist XAResource org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@390d8f, errorCode: 0 javax.transaction.xa.XAException: Count not turn off auto commit for a XA transaction at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) at org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) at org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) at org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) at org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) at org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) at org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) at org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) at org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) at org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) at java.lang.Thread.run(Thread.java:619) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(2) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], IO:e05f4, Dbc:a98bf]. PktNum:0. TotalReceived:0. PktSize:4,096. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source) at org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) ... 21 more 2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:138:ERROR] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Commit can not be set while enrolled in a transaction 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ SQLProcessor.java:174:WARN ] ---- exception report ---------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ GenericDelegator.java:1290:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:322:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ JobManager.java:187:ERROR] ---- exception report ---------------------------------------------------------- Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction)]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception occurred on commit (Commit can not be set while enrolled in a transaction) ---- cause --------------------------------------------------------------------- Exception: java.sql.SQLException Message: Commit can not be set while enrolled in a transaction ---- stack trace --------------------------------------------------------------- java.sql.SQLException: Commit can not be set while enrolled in a transaction org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) org.ofbiz.service.job.JobManager.poll(JobManager.java:157) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:286:ERROR] ---- exception report ---------------------------------------------------------- [TransactionUtil.rollback] Exception: java.lang.Exception Message: Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Stack Trace org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) org.ofbiz.service.job.JobManager.poll(JobManager.java:190) org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction rolled back 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6) -- Abhijeet Pandey |
|
|
Abhijeet,
What version MS JDBC driver are you using? Did you follow the detailed instructions with the driver for setting up XA Transactions? What ofbiz version are you using? Have you ever managed to get access to the system without an error? Cheers, Chris Abhijeet Pandey wrote: > Hi All, > > I am getting following error while accessing ofbiz. The deployment is fine > and it is not giving any error while starting the server but while accessing > it is giving following Error. > > Please help. > > Unable to enlist XAResource > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception > occurred during the DBComms.receive method. Operation:Connection reset. > Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], > IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096. > > Below is the Detailed Log ---------------------------> > > Httpd started on port: 9989 > Sessiond started on port: 9990 > 2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:100:INFO ] Started > BeanShell telnet service on 9989, 9990 > 2009-12-21 15:55:03,023 (main) [ BeanShellContainer.java:101:INFO ] NOTICE: > BeanShell service ports are not secure. Please protect the ports > 2009-12-21 15:55:05,037 (org.ofbiz.service.jms.JmsListenerFactory@17eeb7e) [ > JmsListenerFactory.java:75 :INFO ] JMS Listener Factory Thread Finished; All > listeners connected. > 2009-12-21 15:55:15,055 (org.ofbiz.service.job.JobPoller@223279) [ > GenericDispatcher.java:61 :INFO ] Creating new dispatcher [JobDispatcher] > (org.ofbiz.service.job.JobPoller@223279) > 2009-12-21 15:55:15,747 (default-invoker-Thread-11) [ > JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-11] received job > [Auto-create Fixed Asset Maintenances] from poller > [org.ofbiz.service.job.JobPoller@223279] > 2009-12-21 15:55:15,747 (default-invoker-Thread-9) [ > JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-9] received job > [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] > 2009-12-21 15:55:15,749 (default-invoker-Thread-7) [ > JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-7] received job > [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] > 2009-12-21 15:55:15,750 (default-invoker-Thread-10) [ > JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-10] received job > [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] > 2009-12-21 15:55:15,750 (default-invoker-Thread-8) [ > JobInvoker.java:232:INFO ] Invoker [default-invoker-Thread-8] received job > [Send Email] from poller [org.ofbiz.service.job.JobPoller@223279] > 2009-12-21 15:55:16,171 (default-invoker-Thread-9) [ > SequenceUtil.java:341:INFO ] Got bank of sequenced IDs for [JobSandbox]; > curSeqId=65900, maxSeqId=66000, bankSize=100 > 2009-12-21 15:55:16,219 (default-invoker-Thread-7) > [PersistedServiceJob.java:178:INFO ] > org.ofbiz.service.job.PersistedServiceJob@e1b74e[65803] -- Next runtime: Mon > Dec 21 16:10:15 IST 2009 > 2009-12-21 15:55:16,219 (default-invoker-Thread-11) > [PersistedServiceJob.java:178:INFO ] > org.ofbiz.service.job.PersistedServiceJob@b65057[65825] -- Next runtime: Mon > Dec 21 16:00:15 IST 2009 > 2009-12-21 15:55:16,220 (default-invoker-Thread-8) > [PersistedServiceJob.java:178:INFO ] > org.ofbiz.service.job.PersistedServiceJob@165520d[65801] -- Next runtime: > Mon Dec 21 16:10:15 IST 2009 > 2009-12-21 15:55:16,220 (default-invoker-Thread-9) > [PersistedServiceJob.java:178:INFO ] > org.ofbiz.service.job.PersistedServiceJob@ee0989[65800] -- Next runtime: Mon > Dec 21 16:10:15 IST 2009 > 2009-12-21 15:55:16,222 (default-invoker-Thread-10) > [PersistedServiceJob.java:178:INFO ] > org.ofbiz.service.job.PersistedServiceJob@f183bd[65804] -- Next runtime: Mon > Dec 21 16:10:15 IST 2009 > 2009-12-21 15:55:16,305 (default-invoker-Thread-8) [ > AbstractEngine.java:73 :INFO ] Loaded Service Locations : > [main-rmi=rmi://localhost:1099/RMIDispatcher, main-http= > http://localhost:80/webtools/control/httpService, > entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-http= > http://localhost:8080/webtools/control/httpService, > rita-rmi=rmi://localhost:1099/RMIDispatcher, eedcc-test= > http://localhost:8080/webtools/control/httpService] > 2009-12-21 15:55:17,299 (default-invoker-Thread-8) [ > ServiceDispatcher.java:586:INFO ] Sync service > [JobDispatcher/sendEmailDated] finished in [1032] milliseconds > 2009-12-21 15:55:17,303 (default-invoker-Thread-10) [ > ServiceDispatcher.java:586:INFO ] Sync service > [JobDispatcher/sendEmailDated] finished in [1027] milliseconds > 2009-12-21 15:55:17,308 (default-invoker-Thread-9) [ > ServiceDispatcher.java:586:INFO ] Sync service > [JobDispatcher/sendEmailDated] finished in [1038] milliseconds > 2009-12-21 15:55:17,364 (default-invoker-Thread-11) [ > Log.java:111:INFO ] > [CommonPermissionServices.xml#genericBasePermissionCheck] Checking for > primary permission ACCOUNTING_CREATE > 2009-12-21 15:55:17,389 (default-invoker-Thread-11) [ > ServiceEcaRule.java:134:INFO ] For Service ECA [fixedAssetPermissionCheck] > on [return] got false for condition: > [hasPermission][equals][false][true][Boolean] > 2009-12-21 15:55:17,389 (default-invoker-Thread-11) [ > ServiceDispatcher.java:586:INFO ] Sync service > [JobDispatcher/fixedAssetPermissionCheck] finished in [1060] milliseconds > 2009-12-21 15:55:17,403 (default-invoker-Thread-7) [ > ServiceDispatcher.java:586:INFO ] Sync service > [JobDispatcher/sendEmailDated] finished in [1133] milliseconds > 2009-12-21 15:55:17,511 (default-invoker-Thread-11) [ > ServiceDispatcher.java:586:INFO ] Sync service > [JobDispatcher/createMaintsFromTimeInterval] finished in [1241] milliseconds > 2009-12-21 15:56:35,573 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionImpl.java:212:WARN ] Unable to enlist XAResource > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@19c741b, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) > at > org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) > at > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) > at > org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) > at > org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) > at > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) > at > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) > at > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > at > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > at java.lang.Thread.run(Thread.java:619) > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception > occurred during the DBComms.receive method. Operation:Connection reset. > Context:(5) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], > IO:04fe1, Dbc:cfdd0]. PktNum:0. TotalReceived:0. PktSize:4,096. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown > Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown > Source) > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) > ... 21 more > 2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,604 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,624 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,625 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,626 (org.ofbiz.service.job.JobPoller@223279) [ > GenericDelegator.java:1290:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,627 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:322:WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this > stack trace shows where this is happening: > Exception: java.lang.Exception > Message: Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Failure in storeByCondition operation for entity > [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception > occurred on commit (Commit can not be set while enrolled in a transaction). > Rolling back transaction. > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,628 (org.ofbiz.service.job.JobPoller@223279) [ > JobManager.java:187:ERROR] > ---- exception report > ---------------------------------------------------------- > Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: > SQL Exception occurred on commit (Commit can not be set while enrolled in a > transaction)]. Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,630 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:286:ERROR] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) > org.ofbiz.service.job.JobManager.poll(JobManager.java:190) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction > rolled back > 2009-12-21 15:56:35,631 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing > transaction, status is No Transaction (6) > 2009-12-21 15:56:35,632 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionImpl.java:212:WARN ] Unable to enlist XAResource > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@1d69f44, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) > at > org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) > at > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) > at > org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) > at > org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) > at > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) > at > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) > at > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > at > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > at java.lang.Thread.run(Thread.java:619) > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception > occurred during the DBComms.receive method. Operation:Connection reset. > Context:(1) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], > IO:80c2b, Dbc:29dc5]. PktNum:0. TotalReceived:0. PktSize:4,096. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown > Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown > Source) > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) > ... 21 more > 2009-12-21 15:56:35,654 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,655 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,656 (org.ofbiz.service.job.JobPoller@223279) [ > GenericDelegator.java:1290:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:322:WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this > stack trace shows where this is happening: > Exception: java.lang.Exception > Message: Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Failure in storeByCondition operation for entity > [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception > occurred on commit (Commit can not be set while enrolled in a transaction). > Rolling back transaction. > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ > JobManager.java:187:ERROR] > ---- exception report > ---------------------------------------------------------- > Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: > SQL Exception occurred on commit (Commit can not be set while enrolled in a > transaction)]. Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:286:ERROR] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) > org.ofbiz.service.job.JobManager.poll(JobManager.java:190) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,657 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction > rolled back > 2009-12-21 15:56:35,658 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing > transaction, status is No Transaction (6) > 2009-12-21 15:56:35,659 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionImpl.java:212:WARN ] Unable to enlist XAResource > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@532d42, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) > at > org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) > at > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) > at > org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) > at > org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) > at > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) > at > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) > at > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > at > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > at java.lang.Thread.run(Thread.java:619) > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception > occurred during the DBComms.receive method. Operation:Connection reset. > Context:(3) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], > IO:e3a05, Dbc:4611a]. PktNum:0. TotalReceived:0. PktSize:4,096. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown > Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown > Source) > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) > ... 21 more > 2009-12-21 15:56:35,663 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,664 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,665 (org.ofbiz.service.job.JobPoller@223279) [ > GenericDelegator.java:1290:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,666 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:322:WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this > stack trace shows where this is happening: > Exception: java.lang.Exception > Message: Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Failure in storeByCondition operation for entity > [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception > occurred on commit (Commit can not be set while enrolled in a transaction). > Rolling back transaction. > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ > JobManager.java:187:ERROR] > ---- exception report > ---------------------------------------------------------- > Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: > SQL Exception occurred on commit (Commit can not be set while enrolled in a > transaction)]. Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:286:ERROR] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) > org.ofbiz.service.job.JobManager.poll(JobManager.java:190) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction > rolled back > 2009-12-21 15:56:35,686 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing > transaction, status is No Transaction (6) > 2009-12-21 15:56:35,687 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionImpl.java:212:WARN ] Unable to enlist XAResource > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@662c35, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) > at > org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) > at > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) > at > org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) > at > org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) > at > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) > at > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) > at > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > at > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > at java.lang.Thread.run(Thread.java:619) > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception > occurred during the DBComms.receive method. Operation:Connection reset. > Context:(4) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], > IO:07975, Dbc:305e8]. PktNum:0. TotalReceived:0. PktSize:4,096. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown > Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown > Source) > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) > ... 21 more > 2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,692 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,693 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ > GenericDelegator.java:1290:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,694 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:322:WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this > stack trace shows where this is happening: > Exception: java.lang.Exception > Message: Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Failure in storeByCondition operation for entity > [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception > occurred on commit (Commit can not be set while enrolled in a transaction). > Rolling back transaction. > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ > JobManager.java:187:ERROR] > ---- exception report > ---------------------------------------------------------- > Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: > SQL Exception occurred on commit (Commit can not be set while enrolled in a > transaction)]. Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:286:ERROR] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) > org.ofbiz.service.job.JobManager.poll(JobManager.java:190) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction > rolled back > 2009-12-21 15:56:35,695 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing > transaction, status is No Transaction (6) > 2009-12-21 15:56:35,716 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionImpl.java:212:WARN ] Unable to enlist XAResource > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource@390d8f, > errorCode: 0 > javax.transaction.xa.XAException: Count not turn off auto commit for a XA > transaction > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:134) > at > org.apache.geronimo.transaction.manager.TransactionImpl.enlistResource(TransactionImpl.java:208) > at > org.apache.commons.dbcp.managed.TransactionContext.setSharedConnection(TransactionContext.java:89) > at > org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:131) > at > org.apache.commons.dbcp.managed.ManagedConnection.<init>(ManagedConnection.java:55) > at > org.apache.commons.dbcp.managed.ManagedDataSource.getConnection(ManagedDataSource.java:77) > at > org.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:53) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:128) > at > org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:85) > at > org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:95) > at > org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:73) > at > org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:240) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:346) > at > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:317) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:323) > at > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > at > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > at > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > at org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > at org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > at java.lang.Thread.run(Thread.java:619) > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception > occurred during the DBComms.receive method. Operation:Connection reset. > Context:(2) [Thread[org.ofbiz.service.job.JobPoller@223279,5,main], > IO:e05f4, Dbc:a98bf]. PktNum:0. TotalReceived:0. PktSize:4,096. > at > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown > Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.doConnectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection$ConnectionCommandRequest.execute(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown > Source) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown > Source) > at > org.apache.commons.dbcp.managed.LocalXAConnectionFactory$LocalXAResource.start(LocalXAConnectionFactory.java:132) > ... 21 more > 2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,718 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:331) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:290) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,719 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:138:ERROR] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:173:WARN ] [SQLProcessor.rollback]: SQL Exception while > rolling back insert. Error was:java.sql.SQLException: Commit can not be set > while enrolled in a transaction > 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ > SQLProcessor.java:174:WARN ] > ---- exception report > ---------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.rollback(ManagedConnection.java:217) > org.ofbiz.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:161) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:140) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ > GenericDelegator.java:1290:ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,720 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:322:WARN ] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this > stack trace shows where this is happening: > Exception: java.lang.Exception > Message: Failure in storeByCondition operation for entity [JobSandbox]: > org.ofbiz.entity.GenericDataSourceException: SQL Exception occurred on > commit (Commit can not be set while enrolled in a transaction). Rolling back > transaction. > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Failure in storeByCondition operation for entity > [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: SQL Exception > occurred on commit (Commit can not be set while enrolled in a transaction). > Rolling back transaction. > org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:322) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:269) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1293) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ > JobManager.java:187:ERROR] > ---- exception report > ---------------------------------------------------------- > Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: > SQL Exception occurred on commit (Commit can not be set while enrolled in a > transaction)]. Rolling back transaction. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception occurred on commit (Commit can not be set while > enrolled in a transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Commit can not be set while enrolled in a transaction > ---- stack trace > --------------------------------------------------------------- > java.sql.SQLException: Commit can not be set while enrolled in a transaction > org.apache.commons.dbcp.managed.ManagedConnection.commit(ManagedConnection.java:210) > org.ofbiz.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:135) > org.ofbiz.entity.jdbc.SQLProcessor.close(SQLProcessor.java:186) > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:293) > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1279) > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1249) > org.ofbiz.service.job.JobManager.poll(JobManager.java:157) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:286:ERROR] > ---- exception report > ---------------------------------------------------------- > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace > --------------------------------------------------------------- > java.lang.Exception: Stack Trace > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:285) > org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:267) > org.ofbiz.service.job.JobManager.poll(JobManager.java:190) > org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:296:INFO ] [TransactionUtil.rollback] transaction > rolled back > 2009-12-21 15:56:35,721 (org.ofbiz.service.job.JobPoller@223279) [ > TransactionUtil.java:219:WARN ] [TransactionUtil.commit] Not committing > transaction, status is No Transaction (6) > > > -- Chris Snow - CEng MBCS CITP MBA (Tech Mgmt) (Open) CISSP Tel: 01453 890660 Mob: 07944 880950 Www: www.snowconsulting.co.uk |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |