schedule service does not create a new record.

[pratibhaG]

I am using ofbiz and oracle database.
I am running a schedule service where the service is supposed to run every 10 minutes.
I found an unexpected behavior sometimes. And the strange thing is that  it happens at random at anytime.
The schedule service runs. Tries to create a new record for the same service in JOB_SANDBOX with status id SERVICE_PENDING it throws following error:

ORA-01461: can bind a LONG value only for insert into a LONG column

Why is it so? What makes the service fail for some time and run sometimes successfully? While creating a new record most of the values for columns are same. Foe which column this error is thrown?

Please help ................

-----Pratibha

The whole logs are as follows:

Console log error on intapp01
-----------------------------------------

2008-04-25 00:00:17,603 (directordelegator-invoker-Thread-248084) [JobInvoker.java:run:212 :INFO ] :: Invoker: directordelegator-invoker-Thread-248084 received job -- Purge Old Jobs from poller - org.ofbiz.service.job.JobPoller@12f195

2008-04-25 00:00:17,604 (directordelegator-invoker-Thread-248081) [JobInvoker.java:run:212 :INFO ] :: Invoker: directordelegator-invoker-Thread-248081 received job -- Service for exporting orders and Registered users from poller - org.ofbiz.service.job.JobPoller@12f195

2008-04-25 00:00:17,661 (directordelegator-invoker-Thread-248081) [GenericDelegator.java:create:600 :ERROR] ::
---- exception report ----------------------------------------------------------
Failure in create operation for entity [JobSandbox]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (while inserting: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a LONG value only for insert into a LONG column
))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (while inserting: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a LONG value only for insert into a LONG column
)))
---- stack trace ---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (while inserting: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a LONG value only for insert into a LONG column
)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a LONG value only for insert into a LONG column
))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a LONG value only for insert into a LONG column
)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:764)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------------------


Exception in thread "directordelegator-invoker-Thread-248081" java.lang.RuntimeException: Exception while inserting the following entity: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (while inserting: [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service for exporting orders and Registered users(java.lang.String)][lastUpdatedStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)] (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a LONG value only for insert into a LONG column
)))
        at org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:135)
        at org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
        at org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
        at java.lang.Thread.run(Thread.java:595)
2008-04-25 00:00:19,415 (http-0.0.0.0-8080-Processor372) [TPWrapper.java:getTpTransactions:2686:INFO ] :: Entered getTransactions(..)

2008-04-25 00:00:19,416 (http-0.0.0.0-8080-Processor372) [TPWrapper.java:getTpTransactions:2722:INFO ] :: -- Prepare the data parameters

[Sumit Pandit-3]

Pratibha,

May I have service def and supporting information please.

Thanks
Sumit Pandit



----- Original Message -----
From: "pratibhaG" <[hidden email]>
To: [hidden email]
Sent: Monday, December 8, 2008 10:16:00 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: schedule service does not create a new record.


I am using ofbiz and oracle database.
I am running a schedule service where the service is supposed to run every
10 minutes.
I found an unexpected behavior sometimes. And the strange thing is that it
happens at random at anytime.
The schedule service runs. Tries to create a new record for the same service
in JOB_SANDBOX with status id SERVICE_PENDING it throws following error:

ORA-01461: can bind a LONG value only for insert into a LONG column

Why is it so? What makes the service fail for some time and run sometimes
successfully? While creating a new record most of the values for columns are
same. Foe which column this error is thrown?

Please help ................

-----Pratibha

The whole logs are as follows:

Console log error on intapp01
-----------------------------------------

2008-04-25 00:00:17,603 (directordelegator-invoker-Thread-248084)
[JobInvoker.java:run:212 :INFO ] :: Invoker:
directordelegator-invoker-Thread-248084 received job -- Purge Old Jobs from
poller - org.ofbiz.service.job.JobPoller@12f195

2008-04-25 00:00:17,604 (directordelegator-invoker-Thread-248081)
[JobInvoker.java:run:212 :INFO ] :: Invoker:
directordelegator-invoker-Thread-248081 received job -- Service for
exporting orders and Registered users from poller -
org.ofbiz.service.job.JobPoller@12f195

2008-04-25 00:00:17,661 (directordelegator-invoker-Thread-248081)
[GenericDelegator.java:create:600 :ERROR] ::
---- exception report
----------------------------------------------------------
Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(while inserting:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
LONG value only for insert into a LONG column
))). Rolling back transaction.
Exception: org.ofbiz.entity.GenericEntityException
Message: Exception while inserting the following entity:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(while inserting:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
LONG value only for insert into a LONG column
)))
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericEntityException: Exception while inserting the
following entity:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(while inserting:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
LONG value only for insert into a LONG column
)))
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
org.ofbiz.entity.GenericEntityException: while inserting:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
LONG value only for insert into a LONG column
))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME,
POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME,
LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(ORA-01461: can bind a LONG value only for insert into a LONG column
)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into
a LONG column
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:764)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436)
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------------------


Exception in thread "directordelegator-invoker-Thread-248081"
java.lang.RuntimeException: Exception while inserting the following entity:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(while inserting:
[GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
for exporting orders and Registered
users(java.lang.String)][lastUpdatedStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
LONG value only for insert into a LONG column
)))
at
org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:135)
at
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
at org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
at java.lang.Thread.run(Thread.java:595)
2008-04-25 00:00:19,415 (http-0.0.0.0-8080-Processor372)
[TPWrapper.java:getTpTransactions:2686:INFO ] :: Entered getTransactions(..)

2008-04-25 00:00:19,416 (http-0.0.0.0-8080-Processor372)
[TPWrapper.java:getTpTransactions:2722:INFO ] :: -- Prepare the data
parameters

--
View this message in context: http://www.nabble.com/schedule-service-does-not-create-a-new-record.-tp20889473p20889473.html 
Sent from the OFBiz - User mailing list archive at Nabble.com.

[hans_bakker]

i just committed the following just a few days ago, perhaps it helps?

http://svn.apache.org/viewvc/ofbiz/trunk/framework/entity/fieldtype/fieldtypeoracle.xml?rev=723336&r1=723335&r2=723336&view=diff

regards,
Hans

On Sun, 2008-12-07 at 20:46 -0800, pratibhaG wrote:

> I am using ofbiz and oracle database.
> I am running a schedule service where the service is supposed to run every
> 10 minutes.
> I found an unexpected behavior sometimes. And the strange thing is that  it
> happens at random at anytime.
> The schedule service runs. Tries to create a new record for the same service
> in JOB_SANDBOX with status id SERVICE_PENDING it throws following error:
>
> ORA-01461: can bind a LONG value only for insert into a LONG column
>
> Why is it so? What makes the service fail for some time and run sometimes
> successfully? While creating a new record most of the values for columns are
> same. Foe which column this error is thrown?
>
> Please help ................
>
> -----Pratibha
>
> The whole logs are as follows:
>
> Console log error on intapp01
> -----------------------------------------
>
> 2008-04-25 00:00:17,603 (directordelegator-invoker-Thread-248084)
> [JobInvoker.java:run:212 :INFO ] :: Invoker:
> directordelegator-invoker-Thread-248084 received job -- Purge Old Jobs from
> poller - org.ofbiz.service.job.JobPoller@12f195
>
> 2008-04-25 00:00:17,604 (directordelegator-invoker-Thread-248081)
> [JobInvoker.java:run:212 :INFO ] :: Invoker:
> directordelegator-invoker-Thread-248081 received job -- Service for
> exporting orders and Registered users from poller -
> org.ofbiz.service.job.JobPoller@12f195
>
> 2008-04-25 00:00:17,661 (directordelegator-invoker-Thread-248081)
> [GenericDelegator.java:create:600 :ERROR] ::
> ---- exception report
> ----------------------------------------------------------
> Failure in create operation for entity [JobSandbox]:
> org.ofbiz.entity.GenericEntityException: Exception while inserting the
> following entity:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (while inserting:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
> (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
> PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
> LONG value only for insert into a LONG column
> ))). Rolling back transaction.
> Exception: org.ofbiz.entity.GenericEntityException
> Message: Exception while inserting the following entity:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (while inserting:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
> (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
> PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
> LONG value only for insert into a LONG column
> )))
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.entity.GenericEntityException: Exception while inserting the
> following entity:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (while inserting:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
> (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
> PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
> LONG value only for insert into a LONG column
> )))
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
> org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
> java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericEntityException: while inserting:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
> (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
> PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
> LONG value only for insert into a LONG column
> ))
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
> org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
> java.lang.Thread.run(Thread.java:595)
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:INSERT INTO DIR.JOB_SANDBOX (JOB_ID, JOB_NAME, RUN_TIME,
> POOL_ID, STATUS_ID, PARENT_JOB_ID, PREVIOUS_JOB_ID, SERVICE_NAME,
> LOADER_NAME, MAX_RETRY, RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID,
> RUN_BY_INSTANCE_ID, START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME,
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP)
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> (ORA-01461: can bind a LONG value only for insert into a LONG column
> )
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
> org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
> java.lang.Thread.run(Thread.java:595)
> java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into
> a LONG column
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
> oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
> oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
> oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:764)
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
> org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82)
> org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436)
> org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180)
> org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127)
> org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
> org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
> org.ofbiz.service.job.PersistedServiceJob.createRecurrence(PersistedServiceJob.java:158)
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:132)
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
> org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
> java.lang.Thread.run(Thread.java:595)
> --------------------------------------------------------------------------------
>
>
> Exception in thread "directordelegator-invoker-Thread-248081"
> java.lang.RuntimeException: Exception while inserting the following entity:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (while inserting:
> [GenericEntity:JobSandbox][cancelDateTime,null()][createdStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][createdTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][finishDateTime,null()][jobId,D211882215(java.lang.String)][jobName,Service
> for exporting orders and Registered
> users(java.lang.String)][lastUpdatedStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-25
> 00:00:17.628(java.sql.Timestamp)][loaderName,JobDispatcher(java.lang.String)][maxRetry,-1(java.lang.Long)][parentJobId,runDailyExports_I1(java.lang.String)][poolId,pool_I1(java.lang.String)][previousJobId,D211881145(java.lang.String)][recurrenceInfoId,287(java.lang.String)][runAsUser,admin(java.lang.String)][runByInstanceId,null()][runTime,2008-04-26
> 00:00:00.0(java.sql.Timestamp)][runtimeDataId,null()][serviceName,runDailyExports(java.lang.String)][startDateTime,null()][statusId,SERVICE_PENDING(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO DIR.JOB_SANDBOX
> (JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
> PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, RUN_AS_USER,
> RUNTIME_DATA_ID, RECURRENCE_INFO_ID, RUN_BY_INSTANCE_ID, START_DATE_TIME,
> FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01461: can bind a
> LONG value only for insert into a LONG column
> )))
>         at
> org.ofbiz.service.job.PersistedServiceJob.init(PersistedServiceJob.java:135)
>         at
> org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:65)
>         at org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:222)
>         at java.lang.Thread.run(Thread.java:595)
> 2008-04-25 00:00:19,415 (http-0.0.0.0-8080-Processor372)
> [TPWrapper.java:getTpTransactions:2686:INFO ] :: Entered getTransactions(..)
>
> 2008-04-25 00:00:19,416 (http-0.0.0.0-8080-Processor372)
> [TPWrapper.java:getTpTransactions:2722:INFO ] :: -- Prepare the data
> parameters
>

--
Antwebsystems.com: Quality OFBiz services for competitive prices