Tried the trigger given on that site but the problem persists. It comes up a bit later now (after a 100 or so more lines in the log) but it still comes.
Scott Gray wrote: > > 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) >> >> > > -- View this message in context: http://www.nabble.com/Getting-SQL-Exceptions-during-ant-run-tp17033489p17053934.html Sent from the OFBiz - User mailing list archive at Nabble.com.
