Occasionally Urchin 5.x.x will stop processing data. If one looks in the scheduler section the parse will be labeled as running and typically only at 0%. In this situation, one needs to use the Urchin utils command line to reset some flags in the database so Urchin can run the report again. Typically the utils folder is located at C:\Program Files\Urchin5\utils>

Type all the commands in order substituting MyProfile for the name of the profile that is stuck.

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