Hi, we were having the same problem in the tRedshiftOutput component, and found that when we unticked the 'extend insert' option under its advanced setting, and added a row -> main after the tRedshiftOutput to a tRedshiftCommit (untick the auto close connection), then the job ran without any issues.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables