Problem Statement:

Whenever Sync to target to Teradata fails with the below error because of TERADATA FASTLOAD. This is the Fastload issue.


Caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC] [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"., executor 1): java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC] [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.


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: