Job status is finished however there is a fatal error in log
Posted: Wed Mar 04, 2009 6:57 am
I have a job with Teradata enterprise stage, sometimes the job status is seen finished, however there is a fatal error in the log and no data is loaded to the target table and the sequencer proceed with the next job which depends on the data loaded by this job.
The fatal error is:
TeraUtils:DB Call Failure(success check) Info = 0, Code = 2801, Message = Duplicate unique prime key error in TDB.SIM_CARD_SUBSCRIPTION_HIST.
Any help is much appreciated.
The fatal error is:
TeraUtils:DB Call Failure(success check) Info = 0, Code = 2801, Message = Duplicate unique prime key error in TDB.SIM_CARD_SUBSCRIPTION_HIST.
Any help is much appreciated.