Error ingest to prepare instance ADF merge on demand transfer fails

Symptoms

The execution fails with the following error message:

However, the execution works if you manually disable the ADF merge task

Resolution

1. Increase Timeout Settings:
   Increase the connection and command timeout settings on the data source connection (if available)

2. Reduce Concurrent Execution Threads:
   Try to lower the concurrent execution threads for the data source (e.g., to 2) by editing the data source and navigating to advanced settings in TDI.

3. Exclude ADF Merge Task:
   • As a workaround, edit the execution package and drag the "data factory merge" step into exclude steps.

     

   • Right-click the instance and under advanced, select "save instance as deployed version" for the execution package change to take effect.

     

Reference Ticket

31710

Reference Links

Table does not load from ODX to DSA

Data Clensing results in time out

404 Path can't be found

​