DataFlow Failed with no usable explanation

joshnoyes
joshnoyes Member
in Magic ETL

I have a dataflow that i was able to run successfully on a small sample dataset. I attempted to run this same dataflow on a dataset with around 429K rows of data but after 10 hours, the dataflow with an error message of "Failed while executing There was a problem running this DataFlow". I am curious if there is a timeout window with Magic ETL dataflows since it ran succesfully with a small sample size? My dataflow consists of an Input Dataset, Python Script, and an Output Dataset tiles. The python script tile is running a forecast on 37K zip codes with 24 months of historical data on each. Any help would be appreciated.

Best Answer

  • david_cunningham
    david_cunningham Coach
    Answer ✓

    @joshnoyes - you may have already tried this, but wanted to share in case you aren't aware.

    If you got to the history tab of a dataflow, you can access a more detailed view of the ETL execution.

    image.png

    From there, you should be able to access more details about what caused the failure.

    image.png

    If using a python tile, I highly recommend making use of the console tab to troubleshoot/narrow down the issue.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    david_cunningham Coach
    Answer ✓

    @joshnoyes - you may have already tried this, but wanted to share in case you aren't aware.

    If you got to the history tab of a dataflow, you can access a more detailed view of the ETL execution.

    image.png

    From there, you should be able to access more details about what caused the failure.

    image.png

    If using a python tile, I highly recommend making use of the console tab to troubleshoot/narrow down the issue.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • joshnoyes
    joshnoyes Member

    👍️thanks David. I was not aware of this option and it is most helpful. thanks again for the quick response.

  • david_cunningham
    david_cunningham Coach

    Happy to help @joshnoyes , let me know if you would like any assistance with troubleshooting the error and getting the ETL to run 😁

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Categories