CODEWITHSUNDEEP
sqlsql-serverreporting-services
Erez
Erez

Reputation: 6446

Reportins services Timeout expired

I'm developing a Report Service and while excecuting the query getting :

An error has occurred during report processing. Exception has been thrown by the target of an invocation. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I know that on the SQL server the query running for a minute ot two.

I setted the Connection string in the web.config like that:

"Data Source=servA;Initial Catalog=myPortal;Integrated Security=True;connection timeout=1000"

It didn't work for me.

Upvotes: 1

Views: 5637

Answers (3)

mamati
mamati

Reputation: 1

See this Link.

After you finished the design of Dataset.xsd, find in Dataset.Designer.cs the following code: 

protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
        get {
            if ((this._commandCollection == null)) {
                this.InitCommandCollection();
            }
            return this._commandCollection;
        }
    }

and change it to :

protected global::System.Data.SqlClient.SqlCommand[] CommandCollection
    {
        get
        {
            if ((this._commandCollection == null))
            {
                this.InitCommandCollection();
                _commandCollection[0].CommandTimeout = 0;
            }
            _commandCollection[0].CommandTimeout = 0;
            return this._commandCollection;
        }
    }

Build your program and enjoy.

Upvotes: 0

mvonlintel
mvonlintel

Reputation: 314

How I got this to work in using BIDS 2008:

  1. In the "Report Data" pane, right click on the Dataset and select "Dataset Properties".
  2. At the bottom of the "Query" tab inside the "Dataset Properties" modal window, set the value of the "Timeout (in seconds

Upvotes: 1

Andomar
Andomar

Reputation: 238296

You can specify the connection timeout in the connection string, but that only says how long it should wait for a connection to succeed,

What you're looking for is the command timeout. That specifies how long SSRS will wait on a particular query to succeed. If I remember right, you can change this in each report in the command timeout setting? Or maybe it was called execution timeout?

Upvotes: 3

Related Questions