Skip to content
Ask the community about this page

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

Error ingest to prepare instance ADF merge on demand transfer fails — screenshot 1

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

Error ingest to prepare instance ADF merge on demand transfer fails — screenshot 2

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.

    Error ingest to prepare instance ADF merge on demand transfer fails — screenshot 3 - Right-click the instance and under advanced, select "save instance as deployed version" for the execution package change to take effect.

    Error ingest to prepare instance ADF merge on demand transfer fails — screenshot 4

Reference Ticket

31710

Table does not load from ODX to DSA

Data Clensing results in time out

404 Path can't be found

​

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.