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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog