This may help: http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle
2008/5/4 BJ Freeman <[EMAIL PROTECTED]>: > there was some discussion about a month ago. > it is an oracle specific problem. > I don't remember a specific solution on the ML since it has to with > oracle. > > > jaki sent the following on 5/3/2008 3:10 AM: > > hi, > > I got my database changed from derby to oracle 10g Enterprise Edition > > Release 10.1.0.2.0 with jdbc Oracle driver Version 9.2.0.1.0. The > 'ant.bat > > run-intall' got over successfully though whenever I start the server > using > > 'ant.bat run', I keep getting SQL Exceptions as below. And the ant run > just > > keeps on going without any end in sight (infact once when I redirected > > output to a txt file, it got as big as 400mb after which I manually quit > > it!). But inspite of this the ecommerce, webtools and other apps which > come > > default with ofbiz seems to work fine. Kindly help > > > > Sample of the error log: > > > > [java] 2008-05-03 14:13:16,478 ([EMAIL PROTECTED]) > [ > > GenericDelegator.java:1103:ERROR] > > [java] ---- exception report > > ---------------------------------------------------------- > > [java] 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 <= '2008-05-03 14:13:16.415' 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 > > [java] )). Rolling back transaction. > > [java] Exception: org.ofbiz.entity.GenericDataSourceException > > [java] 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 <= '2008-05-03 > > 14:13:16.415' 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 > > [java] )) > > [java] ---- stack trace > > --------------------------------------------------------------- > > [java] 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 <= '2008-05-03 14:13:16.415' 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 > > [java] )) > > [java] > > > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291) > > [java] > > > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > > [java] > > > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1100) > > [java] > > > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1075) > > [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > > [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > > [java] java.lang.Thread.run(Thread.java:595) > > [java] org.ofbiz.entity.GenericDataSourceException: SQL Exception > while > > executing the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID > = ?, > > STATUS_ID = ? WHERE ((RUN_TIME <= '2008-05-03 14:13:16.415' 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 > > [java] ) > > [java] > > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:433) > > [java] > > > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:329) > > [java] > > > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > > [java] > > > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > > [java] > > > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1100) > > [java] > > > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1075) > > [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > > [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > > [java] java.lang.Thread.run(Thread.java:595) > > [java] java.sql.SQLException: ORA-01843: not a valid month > > [java] > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) > > [java] oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) > > [java] oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) > > [java] > oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) > > [java] > > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) > > [java] > > > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047) > > [java] > > > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940) > > [java] > > > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709) > > [java] > > > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) > > [java] > > > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) > > [java] > > > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) > > [java] > > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429) > > [java] > > > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:329) > > [java] > > > org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288) > > [java] > > > org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186) > > [java] > > > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1100) > > [java] > > > org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1075) > > [java] org.ofbiz.service.job.JobManager.poll(JobManager.java:151) > > [java] org.ofbiz.service.job.JobPoller.run(JobPoller.java:90) > > [java] java.lang.Thread.run(Thread.java:595) > >
