Insert or update option getting hang in tmmssqloutput

One Star

Insert or update option getting hang in tmmssqloutput

Hello experts,
I am facing bizzare issue as my talend 6.2.0 can insert into mssql tables on first run. If I try to reload same data the job hangs for hours without any error. I am using insert or update option in my tmssqloutput with commit 10000 rows. If I try just update mode ,it works fine. I am clueless as I am getting this issue in just 11 rows.
tmssqlinput--->tmap---> 6 tables with insert or update option.
Please help.
Moderator

Re: Insert or update option getting hang in tmmssqloutput

Hello,

Could you please check out "Die on error" option on t<DB>Output component to see if there is any error message printed on console?

Does this issue repro on other build version(V 6.3)?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read