Recovering from Cross Loader Column Length Errors

When running the Unicode Migration Cross Loader jobs, you might receive the following error message:

SUM OF INPUT COLUMN LENGTHS FOR CURSOR C1 IS TOO LARGE

This error message is generated when the row length of the table being unloaded has exceeded the maximum allowed by Cross Loader. If you receive this message, perform the steps in the following procedure.

To recover from Cross Loader column length error messages

1. Do one of the following:

   • If the definitions for the column are the same in the source and target tables, define the LONG column as a VARCHAR column of a specified length, for example:

     CAST (LOG_DATA_LONG AS VARCHAR (16350))
     

   • If the definitions for the column in the source and target tables are different, change the definition of the LONG column in the source table to have the same format as the corresponding column in the target table, for example, the column might be defined as a CLOB data type in the target table.

2. Rerun the job that generated the error.