Acquisition Error Table - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
cgb1488824663145.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

The first error table, called the acquisition error table, is the one specified as tname3 (default ET_tname1) in the BEGIN MLOAD command. It provides information about:

  • All errors that occur during the acquisition phase of the Teradata MultiLoad job
  • Some errors that occur during the application phase if Teradata Database cannot build a valid primary index

The following table shows the format of the acquisition error table.

Acquisition Error Table Format  
Column Contains
ApplySeq Sequence number of the APPLY clause that was executing when the error occurred
DMLSeq Sequence number assigned to the DML statement in which the error occurred
ErrorCode Code for the error
ErrorField Field name of the target table in which the error occurred

This field may be blank if the system cannot determine which field caused the problem. Error 2677 (stack overflow) is an example of such a condition.

HostData Client data that was being processed when the error occurred
ImportSeq Sequence number assigned to the IMPORT command in which the error occurred
SMTSeq Sequence number of the statement that was being executed when the error occurred
SourceSeq Data row number in the client file that Teradata Database was building when the error occurred