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 |
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. |
In reply to this post by pratibhaG
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 |
Free forum by Nabble | Edit this page |