How To Clear Stuck Urchin Tasks

Check the status of the task
Open the Urchin Configuration GUI and select the following window: Configuration -> Scheduler -> Task History. From this view you will see a Status column. Each item in the “Status” column is a clickable link. The link will open a window that displays the process status when Urchin attempted to process the log file for that profile. Stuck tasks will normally appear as running with a date in the past.
SSH to server.
Stop Urchin daemons with one of the following:
/etc/init.d/urchin stop
/usr/local/urchin/bin/urchinctl stop
Change directory to the urchin utils directory:
cd /usr/local/urchin/utils
Run the following commands, replacing profilename with the selected profile name:

uconf-driver action=set_parameter table=task name=“profilename” cr_runnow=0
uconf-driver action=set_parameter table=task name=“profilename” ct_runstatus=2
uconf-driver action=set_parameter table=task name=“profilename” ct_completed=0
uconf-driver action=set_parameter table=task name=“profilename” ct_status=1
uconf-driver action=set_parameter table=task name=“profilename” ct_lockid=0
Restart the Urchin daemons with one of the following:
/etc/init.d/urchin start
/usr/local/urchin/bin/urchinctl start