Bad Records for Teradata Targets - Teradata Listener

Teradata® Listener™ User Guide

Product
Teradata Listener
Release Number
2.04
Published
November 2018
Language
English (United States)
Last Update
2018-12-20
dita:mapPath
qin1538418638881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2910
lifecycle
previous
Product Category
Analytical Ecosystem

A bad record, or dead letter, is a message the target destination rejects. A bad record can occur for different reasons, including an invalid payload format or a data type that is incompatible with the destination. Listener supports bad records for Teradata systems that are not using QueryGrid.

Listener provides the following bad record behavior options in Target Options:
Option Description
Stop writer Stops the writer and generates an alert event and error message.
Retain bad records and continue processing Retains a queue of bad records and continues streaming data to the target without pausing.

When a bad record occurs, Listener displays a button in the Listener Overview, Source Overview, and Manage Targets that indicates the number of bad records for the target and that opens the Bad Records list.

For example:

From the Listener UI, you can view a sample of bad records for the target and download a JSON-encoded text file of sample bad records for the target. Through the Retrieve Dead-Letter Records REST API you can get all bad records. From both the UI and API, you can delete all bad records.