[
https://issues.apache.org/jira/browse/OFBIZ-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tremal Naik resolved OFBIZ-3997.
--------------------------------
Resolution: Fixed
The script in the "How to set the format of Timestamps" section, in
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+and+Oracle page,
resolves this Oracle error too.
> ORA-01830 installing OFBiz with Oracle 10g
> ------------------------------------------
>
> Key: OFBIZ-3997
> URL: https://issues.apache.org/jira/browse/OFBIZ-3997
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: Release 09.04
> Environment: Windows XP SP3
> Oracle 10g R2
> Reporter: Tremal Naik
> Fix For: Release Branch 09.04
>
>
> Hi,
> I'm trying install the OFBiz 9.04 into a oracle10g database. I've loaded the
> seed and demo data correcty, but when I run the "ant.bat" the log begins an
> infinite loop showing the ORA-01830. Somebody knows the origin of this
> behavior? Thanks!
> ******************************
> I believe that a solution is like this one:
> UPDATE OFBIZ.JOB_SANDBOX
> SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ?
> WHERE (
> (
> RUN_TIME <= *to_date('2010-10-04 13:15:55.897')* 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'
> )
> )
> ******************************
> 2010-10-04 13:17:26,444 (org.ofbiz.service.job.jobpol...@1bb9696)
> [JobManager.java:187:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error in polling 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 <= '2010-10-04 13:15:55.897' 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-01830: date format picture ends before converting entire
> input string)
> )
> ].
> Rolling back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> 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 <= '2010-10-04 13:15:55.897' 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-01830: date format picture ends before converting entire
> input string)
> )
>
> ---- cause
> ---------------------------------------------------------------------
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: SQL Exception while executing the following:UPDATE OFBIZ.JOB_SANDBOX
> SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2010-10-04
> 13:15:55.897' 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-01830: date format picture ends before converting entire input string)
> ---- cause
> ---------------------------------------------------------------------
> Exception: java.sql.SQLException
> Message: ORA-01830: date format picture ends before converting entire input
> string
> ---- stack trace
> ---------------------------------------------------------------
> java.sql.SQLException: ORA-01830: date format picture ends before converting
> entire input string
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
> oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
> oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
> oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2076)
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1986)
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2697)
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:429)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:329)
> org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:288)
> org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1276)
> org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1246)
> org.ofbiz.service.job.JobManager.poll(JobManager.java:157)
> org.ofbiz.service.job.JobPoller.run(JobPoller.java:90)
> java.lang.Thread.run(Unknown Source)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
