Problem Statement:
Whenever Sync to target to Teradata fails with the below error because of TERADATA FASTLOAD. This is the Fastload issue.
Error:
Caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1206] [SQLState HY000] The next failure(s) in the exception chain occurred while closing FastLoad resources for database table "SB_FINANCE_RULES"."tmp2_t_spclt_srxfee_dev_temp".
dataproc-batch-fxhoo-f21565dc534e7d55bfac4621-w-0.us-east4-c.c.pbm-gms-prod-de.internal, executor 1): java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1161] [SQLState HY000] A failure occurred while rolling back statements on a connection. Details of the failure can be found in the exception chain that is accessible with getNextException.
Solution:
We need to add the configuration TYPE=DEFAULT. This needs to be configured in Additional Params under Connection Parameters while configuring Sync to Target.
Documentation link:
https://docs.infoworks.io/onboard-data/synchronizing-data-to-target#configuring-teradata-target