Job in Hung state

makreddy · Post by **makreddy** » Mon Jun 21, 2010 7:08 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 21, 2010 8:15 pm

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.

chulett · Post by **chulett** » Mon Jun 21, 2010 9:57 pm

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.

franco · Post by **franco** » Tue Jun 22, 2010 12:18 am

do you hav more than 1 row for the primary key combination in the dataset and the job execution mode is parallel ?

DSXchange

Job in Hung state

Job in Hung state

Re: Job in Hung state