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:

  1. Microsoft Visual Studio 2008

  2. The report is very complex, usually it It takes 30-60 seconds to complete (filtered on the basis of criteria)

  3. query type: text

    Whatever I have tried: >

    1. "Connect timeout" on connection string for data source to 6 minutes Setting up

    2. Tools - & gt; Database tool - & gt; Question & Visual Designer, Cancel cancellation after 10 minutes.

    3. This will not return data (speed of execution time) to ensure setting parameters

    4. 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

Popular posts from this blog

Verilog Error: output or inout port "Q" must be connected to a structural net expression -

jasper reports - How to center align barcode using jasperreports and barcode4j -

c# - ASP.NET MVC - Attaching an entity of type 'MODELNAME' failed because another entity of the same type already has the same primary key value -