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 - [EMAIL PROTECTED]
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 -
[EMAIL PROTECTED]
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.
