Forum Discussion

ahowell's avatar
ahowell
Regular Visitor
3 years ago

Scheduled Refresh Stopped Working

Hi All,

 

I have two dashboards that both have datasets less than 100mb, that have stopped refreshing on their schedule since sunday night. 

 

The Error message is:

 

Underlying error code -2147467259
Underlying error messageMicrosoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
DM_ErrorDetailNameCode_UnderlyingHResult -2147467259
Microsoft.Data.Mashup.ValueError.Class11
Microsoft.Data.Mashup.ValueError.DataSourceKind SQL
Microsoft.Data.Mashup.ValueError.DataSourcePath (removed)
Microsoft.Data.Mashup.ValueError.ErrorCode -2146232060
Microsoft.Data.Mashup.ValueError.MessageExecution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Microsoft.Data.Mashup.ValueError.Number -2
Microsoft.Data.Mashup.ValueError.ReasonDataSource.Error

 

The error message led me to belive the SQL server was timing out, but Strangely I have other dashboards that conect to the same server and refresh no issues. Any advice Would be greatly appreicated.

 

Thanks