How To Resolve TimeOut Error in Dataset.xsd

Question

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

Jignesh Kumar · Answer

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

Jignesh Kumar · Answer

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 r · Answer

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

venkatesan r · Answer

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 H · Answer

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 Sharma · Answer

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 :)

How To Resolve TimeOut Error in Dataset.xsd

Answers (6)