Forum Discussion
Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the oper
Yes - thanks for suggestion. Not done yet as we have many reports and ideally woudl have global timeout setting. Looking at the documenattion it suggests timeout of 10 minutes and we have other models which run for over 20 minutes successfully.
My understanidng is there is a default 30 second connection timeout and a 10 minute sql execution timeout as we have not changed any defaults and the model itself has no timeout specified in the M query thus not sure where the 80 minutes timeout coming from?
Any thoughts?
Also the report in service attempted to run 4 times - is this the defalut for on demand reports - attempts 4 times if fails first time?
Details |
|
yes, the four attempts are the new standard and we are not happy about it. It greatly messes with capacity management.