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?
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?