Forum Discussion

scabral's avatar
scabral
Helper IV
4 years ago

Dataflow timeouts

Hi,

 

we are currently using Gen2 premium capacity (P3) and our dataflow that is sourcing from on-prem SQL server fails once it hits the 20 minute mark.  Before 20 minutes it will finish, but at the 20 minute mark it fails consistently.

 

With Gen2 we no longer have the ability to configure Dataflow memory and container size, so not sure where else to check any settings that can be configured to make it stop timing out.

 

thanks

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi scabral  ,

    Could you please provide a screenshot with the refresh error? what is your data source? Was there any error reported before the refresh? 

    “Your(…) dataflow couldn’t be refreshed because there was a problem with one or more entities, or because dataflow capabilities were unavailable.” Is this the error that was reported? 

    Symptoms

    Refreshing a dataflow will have either one of the following symptoms:

    • Dataflow refresh stuck in canceling
    • Long running dataflow refresh
    • Failed dataflow refresh

    Solutions and workarounds

    • As a last resource, you can try swapping the workspace out of Premium to Pro and wait a few minutes. Then switch the workspace back to Premium. This solution may help to provide relief, but the issue could reoccur.

    More details: Known issue - Long running, failed or stuck dataflow in Premium Gen2 

     

    If I have misunderstood your meaning, please provide more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.