Error: F_JD2313 Load Into Table Failed / Missing Data for Not-Null Field

Issue

While performing a Refresh into Redshift, the following error appears:

F_JD2313: DBMS error [[Redshift][ODBC Driver][Server]XX000: ERROR: Load into table failed. Check 'stl_load_errors' system table for details].

The STL_LOAD_ERRORS system table shows the following message:

Missing data for not-null field

Environment

• HVR 6
• Target: Redshift

Resolution

To resolve this issue, do the following:

1. In HVR, define the action ColumnProperties with the parameter Nullable.
2. Re-create and run the relevant Refresh job.

Cause

This issue occurs when the source data contains null values for a column that isn't configured to accept null values in Redshift.