Getting Error in JobPoller while using Oracle 11g

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Getting Error in JobPoller while using Oracle 11g

bashsrinivasan
2012-08-07 07:37:56,241 (org.ofbiz.service.job.JobPoller@1b61805) [    TransactionUtil.java:344:INFO ] [TransactionUtil.rollback] transaction rolled back

2012-08-07 07:37:56,241 (org.ofbiz.service.job.JobPoller@1b61805) [    TransactionUtil.java:269:WARN ] [TransactionUtil.commit] Not committing transaction, status is No Transaction (6)

2012-08-07 07:37:56,242 (org.ofbiz.service.job.JobPoller@1b61805) [   GenericDelegator.java:1278: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 ofbiz.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2012-08-07 07:30:36.408' 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')) (ORA-01843: not a valid month
)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition (SQL Exception while executing the following:UPDATE ofbiz.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2012-08-07 07:30:36.408' 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')) (ORA-01843: not a valid month
))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:UPDATE ofbiz.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2012-08-07 07:30:36.408' 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')) (ORA-01843: not a valid month
)
---- cause ---------------------------------------------------------------------
Exception: java.sql.SQLDataException
Message: ORA-01843: not a valid month

---- stack trace ---------------------------------------------------------------
java.sql.SQLDataException: ORA-01843: not a valid month
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:159)
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:137)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:468)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:418)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1089)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1250)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1516)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3889)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4033)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:4008)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:419)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:332)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:185)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1267)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1242)
org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
java.lang.Thread.run(Unknown Source)