You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by jaki <ja...@infosys.com> on 2008/05/03 12:10:04 UTC
Getting SQL Exceptions during ant run
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.
Re: Getting SQL Exceptions during ant run
Posted by jaki <ja...@infosys.com>.
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.
jaki wrote:
>
> 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
>
>
> BJ Freeman wrote:
>>
>> 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 <bj...@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)
>>>>>
>>>>
>>>
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Getting-SQL-Exceptions-during-ant-run-tp17033489p17224305.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting SQL Exceptions during ant run
Posted by jaki <ja...@infosys.com>.
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
BJ Freeman wrote:
>
> 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 <bj...@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)
>>>>
>>>
>>
>
>
>
--
View this message in context: http://www.nabble.com/Getting-SQL-Exceptions-during-ant-run-tp17033489p17071567.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Getting SQL Exceptions during ant run
Posted by BJ Freeman <bj...@free-man.net>.
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 <bj...@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)
>>>
>>
>
Re: Getting SQL Exceptions during ant run
Posted by jaki <ja...@infosys.com>.
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 <bj...@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)
>>
>>
>
>
--
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.
Re: Getting SQL Exceptions during ant run
Posted by BJ Freeman <bj...@free-man.net>.
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 <bj...@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)
>>
>
Re: Getting SQL Exceptions during ant run
Posted by Scott Gray <le...@gmail.com>.
This may help:
http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle
2008/5/4 BJ Freeman <bj...@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)
>
>
Re: Getting SQL Exceptions during ant run
Posted by BJ Freeman <bj...@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)