Hi, lately we started having transaction relatedproblems (duplicate acquisitions for customers who pressed the SUBMIT button consecutively) in our production ofbiz cluster (3 machines).. We noticed DB update errors related to the JOB_SANDBOX in the ofbiz.log. Could this be the cause of the transaction problems? We are using MSSQL.
Here is a snippet from the ofbiz.log ---- exception report ---------------------------------------------------------- WARNING: In setTransactionBeginStack a stack placeholder was already in place, here is the current location: Exception: java.lang.Exception Message: Current Stack Trace ---- stack trace --------------------------------------------------------------- java.lang.Exception: Current Stack Trace org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:531) org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:525) org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57) org.ofbiz.service.job.JobManager.poll(JobManager.java:140) org.ofbiz.service.job.JobPoller.run(JobPoller.java:96) java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- 40377562[ GenericDelegator.java:959:ERROR] ---- exception report ---------------------------------------------------------- Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE dbo.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-01-22 18:13:01.149' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.)). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE dbo.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-01-22 18:13:01.149' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.)) ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE dbo.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-01-22 18:13:01.149' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.)) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:315) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:199) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:956) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:931) org.ofbiz.service.job.JobManager.poll(JobManager.java:152) org.ofbiz.service.job.JobPoller.run(JobPoller.java:96) java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE dbo.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-01-22 18:13:01.149' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool')) (The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:357) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:312) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:199) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:956) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:931) org.ofbiz.service.job.JobManager.poll(JobManager.java:152) org.ofbiz.service.job.JobPoller.run(JobPoller.java:96) java.lang.Thread.run(Thread.java:534) java.sql.SQLException: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525) net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487) net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421) org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:357) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:312) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:199) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:956) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:931) org.ofbiz.service.job.JobManager.poll(JobManager.java:152) org.ofbiz.service.job.JobPoller.run(JobPoller.java:96) java.lang.Thread.run(Thread.java:534) -------------------------------------------------------------------------------- -- View this message in context: http://www.nabble.com/JobSandbox-Update-errors-tf3059538.html#a8507340 Sent from the OFBiz - Dev mailing list archive at Nabble.com.
