Error ingest to prepare instance ADF merge on demand transfer fails¶
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.
Reference Ticket¶
31710
Reference Links¶
Table does not load from ODX to DSA
Data Clensing results in time out
Discussed in the community
Looking for related questions…
Didn't find your answer? Ask the community about this page — questions are answered by Timextender experts, partners and other users.