16.20 - Data Acquisition Errors - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Data acquisition errors occur while the consumer is receiving data from the producer. They include the following common error types:

  • Unexpected extra column
  • Delimited data error
  • Data type error
  • Data size error

Error Case 16: Unexpected Extra Column

Cause:

The schema in the DEFINE SCHEMA statement does not match the schema of the data source/target.

Corrective Action:

  1. Compare the schema definition, the schema called by each operator, and the schema of the data source/target schema to determine the cause of the mismatch.
  2. Correct the schema definition and/or the schemas specified by the operators, as required to correct the problem.
  3. Re-launch the job.

Error Case 17: Delimited Data Errors

When using the DataConnector operator to extract delimited data, errors may occur if the escape character is not defined. Since there is no default escape character, use the DataConnector operator EscapeTextDelimiter optional attribute to define the escape character. If not provided, the TextDelimiter attribute defaults to the pipe character ( | ).