Concept: Table Error File
When you load data into a table, Workday validates the data against the defined schema.
If the value for a field doesn’t match the field type or other field attributes (such as date format), then Workday marks the entire row as invalid and doesn’t include the row in the table. Instead, Workday sends the row to an error file that you can download.
Use the error file to get a list of all rows that failed to load into the table. You can fix the errors in the data, remove the extra fields that Workday adds, and load the fixed data into the table.
The error file:
- Is a CSV file.
- Includes all fields defined in the table schema plus fields for troubleshooting:
- Error Code
- Error Message
- Includes all failed rows up to a maximum of 10,000 rows. If there are more than 10,000 error rows, then Workday rejects the load with a status of Failed.
To download the error file, access either:
- TheActivitiestab on theView Table Detailsreport.
- TheActivitiestab on thePrism Management Consolereport.