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.
  • ESB
1 REPLY
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.