8.2 Migration Toolkit Migration Errors

Table of Contents Previous Next


8 Migration Issues : 8.2 Migration Toolkit Migration Errors

Where: COPY table_name, line 5: "50|HR|LOS|ANGELES"
This error occurs when the data in a column in table_name includes the delimiter character. To correct this error, change the delimiter character to a character not found in the table contents.
Note: In this example, the pipe character (|) occurs in the text, LOS|ANGELES, intended for insertion into the last column, and the Migration Toolkit is run using the -copyDelimiter '|' option, which results in the error.
Trying to reload table: TABLE_NAME through bulk inserts with a batch size of 100
You must create a table to receive the data in the target database before you can migrate the data. Verify that a table (with a name of TABLE_NAME ) exists in the target database; create the table if necessary and re-try the data migration.
8.2.3 Error Creating Constraint CONS_NAME_FK
You can avoid generating the error message by including the -skipFKConst option in the Migration Toolkit command.
To correct the problem, specify -fetchSize 1 as a command line argument when you re-try the migration.

8 Migration Issues : 8.2 Migration Toolkit Migration Errors

Table of Contents Previous Next