Timeout Exception

Question

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.

Vivek Kumar · Answer

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

Need to change at app.config also

sreeram amulya · Answer

Connect Timeout=600;Max Pool Size=500 before i have given like this then also it is coming

Rajkiran Swain · Answer

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

//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 Swain · Answer

Could you please post your all code .

sreeram amulya · Answer

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

Rajkiran Swain · Answer

c . CommandTimeout = 0 ;