Anytime I try to cancel one of them, it fails with the following log
entry, restarting tomcat does not fix this.
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly;
this stack trace shows where this is happening:
Exception: java.lang.Exception
Message: Failure in store operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Exception while updating the
following entity: [GenericEntity:JobSandbox][authUserLoginId,null()]
[cancelDateTime,2008-10-02 00:17:55.265(java.sql.Timestamp)]
[createdStamp,2008-10-02 00:11:47.0(java.sql.Timestamp)]
[createdTxStamp,2008-10-02 00:11:47.0(java.sql.Timestamp)]
[finishDateTime,null()][jobId,34705(java.lang.String)][jobName,
1222803782411(java.lang.String)][lastUpdatedStamp,2008-10-02
00:17:55.265(java.sql.Timestamp)][lastUpdatedTxStamp,2008-10-02
00:17:55.264(java.sql.Timestamp)]
[loaderName,ecommerce(java.lang.String)][maxRetry,-1(java.lang.Long)]
[parentJobId,28034(java.lang.String)][poolId,pool(java.lang.String)]
[previousJobId,34695(java.lang.String)][recurrenceInfoId,null()]
[runAsUser,null()][runByInstanceId,null()][runTime,2008-10-02
00:14:47.0(java.sql.Timestamp)][runtimeDataId,10800(java.lang.String)]
[serviceName,addSuggestionsToShoppingList(java.lang.String)]
[startDateTime,null()][statusId,SERVICE_CANCELLED(java.lang.String)]
(while updating: [GenericEntity:JobSandbox][authUserLoginId,null()]
[cancelDateTime,2008-10-02 00:17:55.265(java.sql.Timestamp)]
[createdStamp,2008-10-02 00:11:47.0(java.sql.Timestamp)]
[createdTxStamp,2008-10-02 00:11:47.0(java.sql.Timestamp)]
[finishDateTime,null()][jobId,34705(java.lang.String)][jobName,
1222803782411(java.lang.String)][lastUpdatedStamp,2008-10-02
00:17:55.265(java.sql.Timestamp)][lastUpdatedTxStamp,2008-10-02
00:17:55.264(java.sql.Timestamp)]
[loaderName,ecommerce(java.lang.String)][maxRetry,-1(java.lang.Long)]
[parentJobId,28034(java.lang.String)][poolId,pool(java.lang.String)]
[previousJobId,34695(java.lang.String)][recurrenceInfoId,null()]
[runAsUser,null()][runByInstanceId,null()][runTime,2008-10-02
00:14:47.0(java.sql.Timestamp)][runtimeDataId,10800(java.lang.String)]
[serviceName,addSuggestionsToShoppingList(java.lang.String)]
[startDateTime,null()][statusId,SERVICE_CANCELLED(java.lang.String)]
(SQL Exception while executing the following:UPDATE JOB_SANDBOX SET
JOB_NAME=?, RUN_TIME=?, POOL_ID=?, STATUS_ID=?, PARENT_JOB_ID=?,
PREVIOUS_JOB_ID=?, SERVICE_NAME=?, LOADER_NAME=?, MAX_RETRY=?,
AUTH_USER_LOGIN_ID=?, 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=? WHERE
JOB_ID=? (Lock wait timeout exceeded; try restarting transaction))).
Rolling back transaction
On Oct 1, 2008, at 6:59 PM, Adrian Crum wrote:
Did you try canceling the job?
-Adrian
Phillip Rhodes wrote:
Hi,
In the webtools, I see hundreds(maybe more) of instances of
addSuggestionsToShoppingList in the job list. I see that it is
failing (log excerpt below). How can I delete/clean the slate so
that ofbiz runs smoothly?
Thank you.
Phillip
I see in the log files:
Service [addSuggestionsToShoppingList] threw an unexpected
exception/error
Exception: org.ofbiz.service.ServiceAuthException
Message: User authorization is required for this service:
addSuggestionsToShoppingList
---- stack trace
---------------------------------------------------------------
org.ofbiz.service.ServiceAuthException: User authorization is
required for this service: addSuggestionsToShoppingList
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
315)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:
211)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:
136)
org.ofbiz.service.job.GenericServiceJob.exec(GenericServiceJob.java:
70)
org.ofbiz.service.job.JobInvoker.run(JobInvoker.java:221)
java.lang.Thread.run(Thread.java:619)
-------------------------------------
