Troubleshooting Template Configuration Execution Errors

S3 Related Issues	• Incorrect macro values • Missing file from S3 bucket • Bucket not present • Incorrect bucket permissions • Incorrect region
Avalanche Related Issues	• Incorrect DSN • Incorrect login credentials • Incorrect table name (new and existing) • Schema does not match • Configuration issues
Other Issues	• Incorrect field delimiter (tab, comma, or pipe is allowed) • Incorrect record separator (CR-LF or LF is allowed) • Source file must not have null values and multi-byte characters • Source file must not be a Binary file

You can check the log file for the error details. Go to the Dashboard and click the Log file icon for the configuration job that failed.

While inserting data into Avalanche DB using Zen template, the date in the format 'dd-mm-yyyy' is not inserted by VWLOAD. To resolve this, use the DATEFORMAT option, add a macro VW_DATEFORMAT and add value <columnname>=<appropriate dateformat>. For example, VW_DATEFORMAT = date_of_birth=DMY.