Error: FJD2313 DBMS Error

Issue

The following error occurs during Integrate after adding the /ColumnProperties=Nullable to the channel and initializing with Script and Jobs:

F_JD2313: DBMS error [NULL result in a non-nullable column File '@<staging file\>.csv.gz', line 1, character 1 Row 1, column "GP_PBASIS__B"["PRICING_TYPE":9] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON\_ERROR option. For more information on loading options, please run 'info loading_data' in a SQL client]. Last query [copy into "<burst table\>

Environment

• Oracle Source
• Snowflake Target
• HVR 5.7.5/22

Resolution

Re-initialize the following:

• Change Tables
• Table Enrollment/Replace Enrollment
• Scripts
• Jobs

Cause

This error occurs when action ColumnProperties is added after the channel creates the table and option Table Enrollment/Replace Enrollment during HVR Initialize is not selected. HVR does not know that the column is now nullable.

The workaround to get past this error is to re-initialize with options Change Tables, Table Enrollment/Replace Enrollment, and Scripts and Jobs.