delete/cleanup failed jobs?

[rhodebump]

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)
-------------------------------------

[Adrian Crum]

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)
> -------------------------------------
>

[rhodebump]

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)
>> -------------------------------------