OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-3997) ORA-01830 installing OFBiz with Oracle 10g

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-3997) ORA-01830 installing OFBiz with Oracle 10g

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.JobPoller@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.

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-3997) ORA-01830 installing OFBiz with Oracle 10g

[ https://issues.apache.org/jira/browse/OFBIZ-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tremal Naik closed OFBIZ-3997.
------------------------------

> 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.JobPoller@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.

Nicolas Malin (Jira)

[jira] Resolved: (OFBIZ-3997) ORA-01830 installing OFBiz with Oracle 10g

In reply to this post by Nicolas Malin (Jira)

[ 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.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.