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.
