Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

Load Error Reference

If any errors occur while loading data from a file, query the STL_LOAD_ERRORS table to identify the error and determine the possible explanation. The following table lists all error codes that might occur during data loads:

Load Error Codes

Error code Description
1200 Unknown parse error. Contact support.
1201 Field delimiter was not found in the input file.
1202 Input data had more columns than were defined in the DDL.
1203 Input data had fewer columns than were defined in the DDL.
1204 Input data exceeded the acceptable range for the data type.
1205 Date format is invalid. See DATEFORMAT and TIMEFORMAT Strings for valid formats.
1206 Timestamp format is invalid. See DATEFORMAT and TIMEFORMAT Strings for valid formats.
1207 Data contained a value outside of the expected range of 0-9.
1208 FLOAT data type format error.
1209 DECIMAL data type format error.
1210 BOOLEAN data type format error.
1211 Input line contained no data.
1212 Load file was not found.
1213 A field specified as NOT NULL contained no data.
1214 Delimiter not found.
1215 CHAR field error.
1216 Invalid input line.
1217 Invalid identity column value.
1218 When using NULL AS '\0', a field containing a null terminator (NUL, or UTF-8 0000) contained more than one byte.
1219 UTF-8 hexadecimal contains an invalid digit.
1220 String contains invalid or unsupported UTF-8 codepoints.
1221 Encoding of the file is not the same as that specified in the COPY command.

On this page: