how to make TPT script ignore bad record

Tools & Utilities
Enthusiast

Re: how to make TPT script ignore bad record

thanks feinholz!

your comment really helped!

 

 

Another error happened:

 

Delimited Data Parsing error: Invalid multi-byte character

I can see the error file already has the error row.

The data is emoji.

 

Can you please help check if any other varibles can be added to let the TPT not terminate?

 

Teradata Employee

Re: how to make TPT script ignore bad record

A data parsing error is not something that we can guarantee we can recover from.

Therefore, this is a terminating error.

Otherwise, while parsing what we believe to be an invliad character, we might end up parsing across field or record boundaries, and end up loading incorrect data.

 

Data integrity is more important to us over trying to recover from a parsing error.

 

 

-- SteveF