MLoadTask is not running

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
elias.shaik
Participant
Posts: 51
Joined: Sat Dec 09, 2006 3:32 am

MLoadTask is not running

Post by elias.shaik »

Hi All,

I am facing "MLoadTask is not running" error while loading into a table of teradata. But if will finish fine if I restart the job after sometime. In some cases i had to wait more than 12 hours for the job to finish successfully.


TeradataConnectorPX stage is used to Insert and another stage to update the same table.

Error occurs only for insert stage.

1.bulk method ,append is used.
2.2000 record count for transaction.
3.Sleep time and tenacity are used in bulk access properties.

Please let me know if you need more info.

Appreciate you help!!

Thanks ,
Elias.
------------
Elias
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

multi instance job?

both running at the same time?
elias.shaik
Participant
Posts: 51
Joined: Sat Dec 09, 2006 3:32 am

Post by elias.shaik »

In the same job we have both stages one to insert and one to update. And it is not a multi instance job.,
------------
Elias
Post Reply