cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pkadel Frequent Visitor
Frequent Visitor

Dataflow refresh keeps running and running

I see hopes for the ability to kill refreshes that run for an unusual length...I up voted that idea.

 

But any ideas on what causes this to happen? Lucky for us we have premium capacity which ups the timeout to 5 hours?? Hard to use in production with little or no control when who knows what is happening. The 5 hour timeout is not awesome either. Would be nice to have a timeout override per secheduled job...with a retry.

 

Nothing has changed on the Query and nothing substantial has changed with the data.

image.png

3 REPLIES 3
pkadel Frequent Visitor
Frequent Visitor

Re: Dataflow refresh keeps running and running

I guess the 5 hour timeout was optimistic. Currently 5:42:33 and still running

pkadel Frequent Visitor
Frequent Visitor

Re: Dataflow refresh keeps running and running

Tried turning off the gateway for a bit...then rebooted it for no good reason. The refreash keeps on truckin'. Now I am curious how long it will go...will it roll over after 100 hours?

 

image.png

pkadel Frequent Visitor
Frequent Visitor

Re: Dataflow refresh keeps running and running

So it does timeout after 24-hours. Support asked to capture gateway logs when it happens again...it is happening and there is nothing hitting the data. Nothing on the SQL server, nothing in the gateway. I saw someone asking about multi-factor...could that be an issue?

image.png