Timeout Exception

sreeram amulya

Hi All,

I am getting time out exception while deleting the record please any body help me. i set the command also like this comm.CommandTimeout = 7200 but still i am getting time out exception.

Error is:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

please any body help me it is urgent.

8 Replies

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

Vivek Kumar9y ago
Have a look into the below links.

https://blog.sqlauthority.com/2016/01/26/sql-server-timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding/

https://stackoverflow.com/questions/8602395/timeout-expired-the-timeout-period-elapsed-prior-to-completion-of-the-operation
sreeram amulya9y ago
Need to change at app.config also
sreeram amulya9y ago
Connect Timeout=600;Max Pool Size=500" before i have given like this then also it is coming
Rajkiran Swain9y ago
set your sql time out in your connection string to a timeout of 200.
add key="DBConnection" value="server=LocalHost;uid=sa;pwd=;database=DataBaseName;Connect Timeout=200; pooling='true'; Max Pool Size=200"/>
sreeram amulya9y ago
//string query = "DELETE FROM TBL_MAIN_IMFO WHERE FILECODE='" + fileCode + "'";
SqlCommand comm = new SqlCommand("spDeleteIMFO", new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["DBConnection"]));
SqlParameter parFileCode = new SqlParameter("@FileCode", SqlDbType.NVarChar, 4);
parFileCode.Value = fileCode;
// SqlParameter parTableName = new SqlParameter("@TableName", SqlDbType.NVarChar, 50);
//parTableName.Value = "TBL_MAIN_IMFO";
comm.Parameters.Add(parFileCode);
// comm.Parameters.Add(parTableName);
comm.CommandType = CommandType.StoredProcedure;
comm.CommandTimeout = 0; //changed 600 to 0 at 2017
try
{
// int result = SQL.SqlHelper.ExecuteNonQuery(Connection, CommandType.Text, query); ;
comm.Connection.Open();
int result = comm.ExecuteNonQuery();
//Params[0].Value = fileCode;
//Params[1].Value = "TBL_MAIN_IMFO";
//int result = SQL.SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, "DeleteInDB", Params);
}
catch (Exception exp)
{
throw new InitFileFormatException(string.Format("Error while Deletion of records '{0}'", fileCode), exp);
}
finally
{
if (comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
}
Rajkiran Swain9y ago
Could you please post your all code .

sreeram amulya9y ago

c.CommandTimeout = 0; i used this one also but still getting same exception

Rajkiran Swain9y ago
```
c.CommandTimeout = 0;
```