Bad Records for Teradata Targets - Teradata Listener

Teradata® Listener™ User Guide

Product
Teradata Listener
Release Number
2.06
Published
August 2019
Language
English (United States)
Last Update
2019-08-30
dita:mapPath
yng1555531055816.ditamap
dita:ditavalPath
boe1555608925945.ditaval
dita:id
B035-2910
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.

If an associated target contains dead-letter records, only an administrator can view the source details in the UI. Use the Source Information API to retrieve the source details.

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 (up to 50) 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.