Page 1 of 1
Job in Hung state
Posted: Mon Jun 21, 2010 7:08 pm
by makreddy
Hi,
I Have a simple job which reads from dataset and updates a table. The dataset has 5000 Rows. The jobs keep on running for ever. I am able to insert and update the records manually into the table.
Any idea what could be the issue.
Thanks
Aravind
Posted: Mon Jun 21, 2010 8:15 pm
by ray.wurlod
Probably that the job HAS finished but for whatever reason has not updated the status table that is read by Director. Or maybe you have a really long-running after-job subroutine, or your after-job subroutine set its ErrorCode argument to a non-zero value.
This is an occasion for the Clear Status File option in Director to be used.
Posted: Mon Jun 21, 2010 9:57 pm
by chulett
So... is the job actually still running? Can you find processes for it when you grep? Either you have a locking issue (if yes) or (if no) a need to clear the status file from the Director, it seems to me.
Re: Job in Hung state
Posted: Tue Jun 22, 2010 12:18 am
by franco
do you hav more than 1 row for the primary key combination in the dataset and the job execution mode is parallel ?