Sync to Target (Teradata failing)

Sync to Target (Teradata failing)

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.Thisneeds 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>