reporting services - SSRS Report Timeout inside Business Intelligence Studio -
Currently, I am trying to "refresh the field" within the Business Intelligence studio and I am getting the following error:
"The timeout has expired. The timeout period has expired before the operation is completed or the server is not responding."
Background information:
-
Microsoft Visual Studio 2008
-
The report is very complex, usually it It takes 30-60 seconds to complete (filtered on the basis of criteria)
-
-
query type: text
Whatever I have tried: >
-
"Connect timeout" on connection string for data source to 6 minutes Setting up
-
Tools - & gt; Database tool - & gt; Question & Visual Designer, Cancel cancellation after 10 minutes.
-
This will not return data (speed of execution time) to ensure setting parameters
-
Top 0 in the query Select.
"update timeout (in seconds):" Dataset's The field for which is taking a long time. If your query starts running a minute under dataset properties, then increase it to 120.
-
Comments
Post a Comment