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:
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