PowerExchange for Vertica User Guide for PowerCenter

PowerExchange for Vertica User Guide for PowerCenter

Exception File

Exception File

When you run a session in bulk mode, you can configure the PowerCenter Integration Service to log the copy command exceptions in an exception file. Use the exception file to understand why the exceptions occurred and take corrective action.
The exception file contains the following details:
  • The record number that was rejected, along with the reason for the exception
  • The file path and name of the rejected file that contains the rejected record
  • The pipe location from where the copy command read the record
If you use partitions, the PowerCenter Integration Service creates an exception file for each partition.
By default, the PowerCenter Integration Service creates the exception file in the following path:
$PMRootDir/Temp/
If you want to change the default path, you can define the path in the session properties.
The PowerCenter Integration Service uses the following naming convention for the exception file:
Exceptions_PartNum_[Partition_Number]_[Table Name]_[Schema Name]_[Counter]_<milliseconds*1000>.dat

Sample Exception File

COPY: Input record 8 has been rejected (int8 out of range '-9223372036854775808' for column 1 (COL1_INTEGER)). See /export/qa_adp/PMATT_96/work_dir/Vertica/Linux.64_RH6.1/exec_dir/Temp/RejectedData_PartNum_0_V0001_INTEGER_TGT_adpqa_schema_0_805000.dat, record 1 for the rejected record. This record was read from V0001_INTEGER_TGT_adpqa_schema_0_pipe_0
COPY: Input record 9 has been rejected (int8 out of range '-9223372036854775808' for column 1 (COL1_INTEGER)). See /export/qa_adp/PMATT_96/work_dir/Vertica/Linux.64_RH6.1/exec_dir/Temp/RejectedData_PartNum_0_V0001_INTEGER_TGT_adpqa_schema_0_805000.dat, record 2 for the rejected record. This record was read from V0001_INTEGER_TGT_adpqa_schema_0_pipe_0
COPY: Input record 10 has been rejected (int8 out of range '-9223372036854775808' for column 1 (COL1_INTEGER)). See /export/qa_adp/PMATT_96/work_dir/Vertica/Linux.64_RH6.1/exec_dir/Temp/RejectedData_PartNum_0_V0001_INTEGER_TGT_adpqa_schema_0_805000.dat, record 3 for the rejected record. This record was read from V0001_INTEGER_TGT_adpqa_schema_0_pipe_0

0 COMMENTS

We’d like to hear from you!