Symptoms
The execution fails with the following error message:
Error: Exception Type: System.Exception
Message: OnDemand execution failed for data source table

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

Resolution
-
Increase Timeout Settings:
Increase the connection and command timeout settings on the data source connection (if available) -
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. - 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.
- As a workaround, edit the execution package and drag the "data factory merge" step into exclude steps.
Reference Ticket
31710
Reference Links
Table does not load from ODX to DSA
Data Clensing results in time out