DataFlow Failed with no usable explanation

joshnoyes

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.

david_cunningham

@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.

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

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

david_cunningham

@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.

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

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

joshnoyes

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

david_cunningham

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