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!
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)
--------------------------------------------------------------------------------
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/ORA-01830-installing-OFBiz-with-Oracle-10g-tp2955805p2955805.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
