ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jaki <jackie_ja...@infosys.com>
Subject Getting SQL Exceptions during ant run
Date Sat, 03 May 2008 10:10:04 GMT

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)
-- 
View this message in context: http://www.nabble.com/Getting-SQL-Exceptions-during-ant-run-tp17033489p17033489.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Mime
View raw message