All Forums General
Purushotham 87 posts Joined 04/14
12 Jun 2014
what might be the reason if a job fails in acqusition phase and application phase

Hi Everyone,

Could anyone help me,what might be the reason to fail a job in acqusition phase and application phase in multiload and fastload?

I need the reason,why a job fails in acquisition phase and application phase.

I dont need how to restart.I new to TD pls help me by giving explanation
..

Regards,
Purushotham

Purushotham.M
Purushotham 87 posts Joined 04/14
12 Jun 2014

Hi raja,

Pls help me out by reply me the above question.i.e
Why fastload or multiload fails in acqusition phase and application phase.pls tell the reason in both phases...

Hope you will give the proper explanation...

Purushotham.M

Raja_KT 1246 posts Joined 07/09
13 Jun 2014

 

For mload, you can read the this small chapter "Handling Teradata MultiLoad Errors". It  explains about Acquisition Error Table and Application Error Table. Reading the error and log tables will give a vivid explanation of the root causes.

 

Similarly, you can read fastload document on this chapter: "Handling Teradata FastLoad Errors"

where it highlights about constraint violations,conversion errors, duplicates  ...

 

Reading the document and real time experience  will give the best proper explanation.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

siddalinga.1989 1 post Joined 05/14
01 Jul 2014

Hi Raja,
Where can we find the document,could you please provide the link?
 
Regards,
Siddu
 

Regards,
Siddalinga

gregbowman 5 posts Joined 12/11
02 Jul 2014

http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=CMLOD&rdsort=Title&srtord=Asc&nm=MultiLoad

You must sign in to leave a comment.