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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.