Pratibha, May I have service def and supporting information please.
Thanks Sumit Pandit ----- Original Message ----- From: "pratibhaG" <[EMAIL PROTECTED]> To: user@ofbiz.apache.org 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 - [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.