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 - [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 > -- Antwebsystems.com: Quality OFBiz services for competitive prices
