Report update keeps failing due to timeout

[Anonymous]

this is an ongoing problem.  First I noticed this was that scheduled updates would not complete.  This only happens with the biggest reports (900meg+).  i had some luck running the update on the desktop but recently I have a report that has failed after over 10 tries.  message is always the same:

Sometimes it happens when I change the sql for the report and most of the time it happens after its already processed over 12 million records and should be finishing up so I can save and post it.

Any help in resolving this would be great

error message follows:

DataSource.Error: Microsoft SQL: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Details:
    DataSourceKind=SQL
    DataSourcePath=afsqlvm1.eastus.cloudapp.azure.com;AFDW
    Message=Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    Number=-2
    Class=11

[Anonymous · Accepted solution]

Found an index that was dropped that matched the where clause of the sql.  It did complete after that.  So the solution was to check for missing or inefficient indexes.