How To Resolve TimeOut Error in Dataset.xsd

sagar Bhosale

13y9.2k.NET

Hi Friends,

I'm using Dataset.xsd with tableadapter and I'm doing a report using MS reporting service.

but the error is occurring

error: An error has occurred during report processing.
* Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

How To Resolve TimeOut Error in Dataset.xsd

Thanx

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar8y ago
Hi venkatesan,

We need to set command TimeOut more you can keep 30 or 6o. o means it will wait indefinitely, no timeout will be raised. Check you dataset and report property.
venkatesan r8y ago
Thanks @jignesh my sp tooks only 13 seconds to execute. I also tried to set command timeout as 0 but it keeps on loading, report is not generated
Jignesh Kumar8y ago
Hi,

Please check your Query or Storeprocedure taking more time than your connection time out. check on commandTimeout = 30 property. You can increase time out value.

May be you can try this as well

cleare you statitics

exec sp_updatestats

or

dbcc freeproccache
venkatesan r8y ago
Hi i too facing this issue. I don't how to proceed with this. I tried to set the commandtimeout also. But still i am facing the error.
Fidel H12y ago
Hello Sunny, I have this same problem, but when I do your suggestion and build the application all those changes disappear. Do you know what I am doing wrong? Thank you in advance.
Sunny Sharma13y ago
HI Sagar,

Open Dataset.Designer.cs file and replace the following code:
---------------------------------------------------------------
protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
----------------------------------------------------------------

with this one:

----------------------------------------------------------------
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;
}
}
----------------------------------------------------------------

Hope it helps :)