ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: Getting SQL Exceptions during ant run
Date Sun, 04 May 2008 03:57:56 GMT
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 <bjfree@free-man.net>:
> 
>> 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)
>>
> 


Mime
View raw message