Loading

Timeout error in Execute SQL action in Nintex Workflow in

Kiran Kumar Talikoti

7y1.7kSQL

Hi Team,

I am getting below error during execute SQL action while performing database items delete operation in Ninext Site Workflow in SharePoint Site.Can anyone know is thera any way to update the timeout value to fix the below issue? Your help would be much appreciated.

Error : "Error performing database operation. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. "

2 Replies

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

Jefferson S. Motta7y ago
Set connection timeout to 0 (infinite):
using (var cmd = oCnn.CreateCommand())
                {
                    cmd.CommandText = cSql.Replace(@"\r\n", "");
                    var oTrans = oCnn.BeginTransaction();
                    cmd.Transaction = oTrans;
                    cmd.CommandTimeout = 0;
                    cmd.ExecuteNonQuery();
                    oTrans.Commit();
                 }
0
Amit Gupta7y ago
This error occurred when your query takes too much time than the default one. This can be overcome when you optimize your query or increase the timout in connection string.
+1