Notification

Urchin WebAnalytics Software is discontinued and is no longer supported. All Urchin documentation applies only to the Urchin product as it was at the time of discontinuation, and does not apply to any Google Analytics products or services.

How do I clear a stuck 'Pending', 'Queued' or 'Running' Task?

Introduction

Under certain rare circumstances such as a system crash, abnormal termination of the Urchin Scheduler, or killing a running task, it is possible that an Urchin task will be left with a status of Pending, Queued or Running when it is not actually in any of those states. This prevents the associated Profile from being run either with the Run Now button or by the Urchin Scheduler.

Procedure

In this situation, the uconf-driver utility can be used to clear the status of the Task and allow it to be run again. This utility can only be run from a command line shell so you will need to bring up a terminal window on a UNIX-type system or invoke a DOS shell on a Windows system. Once you have done so, change directory to the util directory in the Urchin distribution and invoke the following commands, replacing "MyProfile" (without quotes) with the actual Profile name. Note that on most UNIX-type systems you will need to put a leading "./" before the uconf-driver command.

uconf-driver action=set_parameter table=task name="MyProfile" cr_runnow=0
uconf-driver action=set_parameter table=task name="MyProfile" ct_runstatus=2
uconf-driver action=set_parameter table=task name="MyProfile" ct_completed=0
uconf-driver action=set_parameter table=task name="MyProfile" ct_status=1
uconf-driver action=set_parameter table=task name="MyProfile" ct_lockid=0

Considerations

Be certain that Profile which you are resetting is indeed not running. Clearing the status on a Profile which is still running will confuse the Urchin Scheduler and potentially cause processing of the Profile to be re-invoked while it is still being run. This could cause corruption of the Urchin databases for that profile.

Search
Clear search
Close search
Main menu
9547775324016286128
true
Search Help Center
true
true
true
false
false