I need to insert or update an MS SQL Server table with a lookup (the same table) of 2M rows (see screenshots), after 10,000 rows the job is "locked" and no more rows are read/inserted or updated. The only solution is to kill the job
There are more than 2M rows to read from table "X_PROFIL"
SQL Server activity monitor shows the transaction is in ASYNC_NETWORK_IO Wait Type
I'm aware of this post
https://community.talend.com/t5/Design-and-Development/Talend-SQL-queries-got-suspended-by-SQL-Serve... but I wanted to know if somebody else got this issue and how to resolve it on the Talend side.
I mean it works great from Microsoft SQL Server Management Studio with no change on database settings but it doesn't from Talend ... I will send you my job, maybe it can helps ?
Hi Didier Since all solutions above I used can't solve this issue... I hope I can point out the root reason. But I can't. In fact, if you consider talend job as a Java application, you will find various topics online and various solutions. To fix it, you'd better trace the entire environment, SQL Server, Talend, network... Regards, Pedro
