Skip to main content
To homepage To homepage

Error ingest to prepare instance ADF merge on demand transfer fails

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

  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

​

    Did this topic help you find an answer to your question?

    0 replies

    Be the first to reply!

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings