SQL Selector Operator Errors - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
vyv1488824663502.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

If Teradata Database encounters any errors while the SQL Selector operator is retrieving LOB, JSON, or XML data, the job will be terminated with error messages.

If any errors occur on the client side (for example, if there is an I/O error while writing LOB, JSON or XML data to a file), the SQL Selector operator will issue an explanatory error message and terminate the job.

When a client-side failure causes the SQL Selector operator to terminate the job, the temporary work files that it creates to transport LOB, JSON, or XML data from the source table to the target may not get deleted.

  • If the target is another Teradata table, which means the consumer operator is the SQL Inserter operator, then that operator deletes these temporary work files upon error termination.
  • If the target is a flat file, which means the consumer operator is the DataConnector operator, the files are not deleted; they remain after the job terminates. Users need to delete these files manually.