Process went in hang state while transfer huge volume of data

One Star

Process went in hang state while transfer huge volume of data

we are using Talend version 5.6. Current setup is running on SQL Server 2012 standard edition, we have single table with 300 k records and each record is of 5 mb size (PDF image is stored under blob data type). Task is to move this records from this table to another identical table in separate schema residing on separate database server within same network. We wrote simple select * and insert into in ETL. Commit size is defined as 10000 and max heap setting as 4 GB. Process went in hang state without any error. Please suggest what should be done here?

Moderator

Re: Process went in hang state while transfer huge volume of data

Hello,

What's your target DB?

For debugging, could you please check the 'die on error' option on t<DB>Output component and upload the full error messages?

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.