15.10 - Acquisition Error Table - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.10
category
Programming Reference
featnum
B035-2409-035K

Acquisition Error Table

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
  • Table 29 shows the format of the acquisition error table.

     

    Table 29: 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