This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
11-11-2019 07:56 AM
Amazon Redshift: Check 'stl_load_errors' system table for error details
When writing to Amazon Redshift, the following error appears:
Data Stream In (x): The COPY failed with error: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState XX000] ERROR: Load into table 'ayx1XXX' failed. Check 'stl_load_errors' system table for details.
Environment
Cause
Amazon Redshift uses the stl_load_errors table to track errors that happen when loading data to a Redshift table. This table contains error messages that will provide necessary detail to determine the cause for an error.
For more information on the stl_load_errors table, see Amazon's STL LOAD_ERROR documentation.
Solution
Users with appropriate permissions can access the table themselves to investigate errors:
Select * From stl_load_errors
Solution B
If the user doesn't have access to the table themselves, their DBA should be able to provide the same information.
Error Message examples
String length exceeds DDL length
Multibyte character not supported for CHAR (Hint: try using VARCHAR)
Additional Resources