ORA-01843: not a valid month

[vuppla]

i am getting below error how to slove this problem. Please can any one help, this is very argent please..

SQL Exception while executing the following:UPDATE PRD.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-09-28 14:45:28.894' 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)

[BJ Freeman]

what svn number are you using?
can you give more of the log to see where this is being called from?

2007-09-28
14:45:28.894 it the correct format. so need to figure out how ORA-01843
got introduced.

vuppla sent the following on 9/28/2007 1:40 PM:
> i am getting below error how to slove this problem. Please can any one help,
> this is very argent please..
>
> SQL Exception while executing the following:UPDATE PRD.JOB_SANDBOX SET
> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-09-28
> 14:45:28.894' 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)

[Jacopo Cappellato]

Hi,

here you will find useful tips about running OFBiz with Oracle
(including the one to fix your error):

http://docs.ofbiz.org/display/~jacopoc/OFBiz+and+Oracle

Jacopo


vuppla wrote:
> i am getting below error how to slove this problem. Please can any one help,
> this is very argent please..
>
> SQL Exception while executing the following:UPDATE PRD.JOB_SANDBOX SET
> RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2007-09-28
> 14:45:28.894' 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)