Diagnostics
Symptom
Invoke PSQL Utility from Location: C:\ibi\srv82\home\bin
Version: psql (PostgreSQL) 9.2.2
Commit forced at: 2 for 2 row(s)
BULKLOAD: Error found in the bulkload log file for the command "C:\ibi\srv82\home
psql:C:/ibi/srv82/dm/edatemp/ts016143/etlblk_20524_1.ctl:4: ERROR: extra data a
CONTEXT: COPY kris_escapecharactertest, line 1: "Jane|Jone|Jean|Doe"
EXECUTE ERROR
BULK LOAD PROCESS ENDED AT 22.22.30, ELAPSED TIME = 00:00:00.109
TARGET FILE kris_testing/escape_character_issue/kris_escapecharactertes
Problem
The user receives the error message above when a DataMigrator Flow is using a bulk load.
Solution
The escape and delimiter characters specified for the data were the same. They should be different. Also, the Column Enclosure value for the Target Load Options was a factor.
To address these issues:
- Verify the escape and record delimiter values are different.
- Use a double quote (") in the Column Enclosure setting under the Target Load Option.