Jobs keeps running even though the Mload has failed

Sakthi_Sst · Post by **Sakthi_Sst** » Thu Mar 08, 2007 12:44 am

Hi All,

Issue : The Jobs keeps running even though the Mload has failed.

1.I am loading a table through a Mulitload stage in datastage

2.Due to some reasons if the Multiload fails and the Mulitload log shows an error code, the job doesnt abort it keeps on running.

3.After seeing the Mload log i have to abort the job manually.

4.The data volume does not matter.

Any Workarounds?

Regards,

kumar_s · Post by **kumar_s** » Thu Mar 08, 2007 3:32 am

One work around would be, call the job, through a JobSequence. You can have the trigger condition to pass only if has Ok (not Warning nor FatalError).
But straight forward method is to find the reason why its giving out error and why the job is not aborting,

ray.wurlod · Post by **ray.wurlod** » Thu Mar 08, 2007 7:50 am

Is the job REALLY still running, or has it aborted but not been able to reset its status file (from which Director obtains the status)?

Sakthi_Sst · Post by **Sakthi_Sst** » Fri Mar 09, 2007 12:48 am

Sorry for posting it in the wrong forum.

Kumar,

I cannot go for a sequence for every job since i have almost 60 - 70 jobs.

Ray,

The job keeps on running it doesnt get aborted,even in the designer.

From my perspective,some communication gap between the Teradata Mload and Datastage.

Is that anything i need to do, to fill it up?

Regards,

kumar_s · Post by **kumar_s** » Fri Mar 09, 2007 1:53 am

I ment to say JobActivity for each job and set of jobs in a JobSequence.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 09, 2007 8:00 am

What you see in Director is not the actual status but the last reported status. If the job has failed without being able to update its status to DataStage, it will appear to be running forever. Clear the status file in this case.

Sakthi_Sst · Post by **Sakthi_Sst** » Tue Mar 13, 2007 5:04 am

Ray,

I have cleaned up the resources in director,then also it runs fine for once or twice then again it just keeps on saying it is running where as Mulitload has failed.

Kumar,

This job is already called in an Sequencer even the sequencer keeps on runnnig waiting for the status from the job.

Regards,

kumar_s · Post by **kumar_s** » Tue Mar 13, 2007 5:30 am

What you see in log? Do you see the error message from Mload and will it hang just after that?
It may be due to some lock held in database or a response waiting from database.
Do check the background process in database when the job hangs. Also do post the logs that you feel will be useful to analysis.

nishadkapadia · Post by **nishadkapadia** » Sat Mar 24, 2007 11:18 pm

Has this problem at one of the clients,Alternatvely, one can get the o/p into a sequential file and call multiload via a separate script