Getting SQL Exceptions during ant run
Locked
 
|
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 (org.ofbiz.service.job.JobPoller@946d22) [ 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) |
Re: Getting SQL Exceptions during ant run
|
|
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 (org.ofbiz.service.job.JobPoller@946d22) [ > 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) |
Re: Getting SQL Exceptions during ant run
|
|
This may help:
http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle 2008/5/4 BJ Freeman <[hidden email]>: > 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 (org.ofbiz.service.job.JobPoller@946d22) > [ > > 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) > > |
Re: Getting SQL Exceptions during ant run
|
|
thanks Scott
Scott Gray sent the following on 5/3/2008 1:42 PM: > This may help: > http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle > > 2008/5/4 BJ Freeman <[hidden email]>: > >> 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 (org.ofbiz.service.job.JobPoller@946d22) >> [ >>> 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) >> > |
|
|
In reply to this post by Scott Gray
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.
|
Re: Getting SQL Exceptions during ant run
|
|
this is a Java, oracle problem.
I suggest you take what was suggested and ask on the Oracle forum, for the speediest answer. the change from java timestamp to oracle is at the JDBC level, i believe. you might also check java forums on sun. feel free, once you have solved the problem, to add to the page for future users. jaki sent the following on 5/4/2008 11:02 PM: > 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 <[hidden email]>: >> >>> 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 (org.ofbiz.service.job.JobPoller@946d22) >>> [ >>>> 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) >>> >> > |
|
|
Thanks a lot for all the help and suggestions. I got that trigger to work by removing the lines making the check for username. Don't know why it doesn't work with those lines included but I'll make a post as soon as I find out
|
|
|
Ok I got the trigger given on that site working too. Just replace 'ofbiz' in the 'if' condn with 'OFBIZ' and it works. Seems Oracle converts it to uppercase.
|
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |