PowerExchange for Amazon Redshift User Guide for PowerCenter

Back Next

Error Files

The error file contains an entry for each data error. Each entry in the file contains the values for all fields of the record and the error message. Use the error file to understand why the PowerCenter Integration Service does not write data to the Amazon Redshift target.

If you want the PowerCenter Integration Service to generate an error file, specify a directory for the error file in the session properties. You must not specify a network path or shared path.

Consider the following guidelines when you configure the session properties for error files:

If you do not specify a directory for the error file as a session property, the PowerCenter Integration Service writes a blank file to the following directory:

$PMBadFileDir

The PowerCenter Integration Service generates errors file with the following naming convention:

<sessionName>_<timestamp>_error.csv

Sample Error File

If a target table has the fields f_integer, f_char, and f_varchar, and if a row is rejected, the PowerCenter Integration Service generates an error file in the following format:

Errors Details	f_integer	f_char	f_varchar
"Query Start Time: 2014-03-24 11:41:30.629 Offending File: INSERT_bdt_with_composite_key.batch_0.csv.0.gz Line Number: 4 Column Name: f_char Column Type: char Offending Value: .......Furniture Values Intl LLC_upd_upd ERROR Reason: Multibyte character not supported for CHAR (Hint: try using VARCHAR). Invalid char: c3 a6"	"3"	""æˆ‘Furniture Values Intl LLC_upd_upd""	""001E000000SI3jIIAT""
"Query Start Time: 2014-03-24 11:42:00.763 Offending File: INSERT_bdt_with_composite_key.batch_8.csv.0.gz Line Number: 80 Column Name: f_char Column Type: char Offending Value: .......Heitkamp Inc_upd_upd ERROR Reason: Multibyte character not supported for CHAR (Hint: try using VARCHAR). Invalid char: c3 a6"	"9999"	""æˆ‘Heitkamp Inc_upd_upd""	""001E000000SHd7ZIAT""

Rename Saved Search

Table of Contents

PowerExchange for Amazon Redshift User Guide for PowerCenter

PowerExchange for Amazon Redshift User Guide for PowerCenter

Error Files

Error Files

Sample Error File