Forums

Greetings Team,

Every once in a while (just started weeks ago, seems to occur every week or so now), when updating or creating a "Lead" (perhaps other objects as well). The following detailed error is reported in my logs, to assist:

The following was attempted at 2026-02-25 11:55:40.280 CST-US

--

Access: Sql was unable to perform the requested operation [Maximizer.Model.Access.Sql]. Sql Message: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Maximizer.Model.Access.Sql.UdfDataContext2.Save(ISqlContext db, UdfDataContext2 org) in C:\AzDevOps\_work\2\s\Maximizer.Model\Access\Udf.Sql\UdfDataContext.cs:line 241 at Maximizer.Model.Access.Sql.LeadDataContext2.Save(ISqlContext db, LeadDataContext2 org) in C:\AzDevOps\_work\2\s\Maximizer.Model\Access\Lead.Sql\LeadDataContext.cs:line 361 at Maximizer.Model.Access.Sql.LeadAccess.Create(ILeadObject o, IScope scope, AccessOptions option, Func3 serializer) in C:\AzDevOps_work\2\s\Maximizer.Model\Access\Lead.Sql\LeadAccess.cs:line 79 at Maximizer.Web.Data.Context.LeadModifyDataContext.Save() in C:\AzDevOps_work\2\s\WebPortals\Maximizer.Web.Data\Context\LeadDataContext.cs:line 197 at Maximizer.Web.Data.Context.IoContext.Create(String request) in C:\AzDevOps_work\2\s\WebPortals\Maximizer.Web.Data\Context\IoContext.cs:line 165 ClientConnectionId:46593209-648c-4a8a-9f2f-8f821b29f819 Error Number:-2,State:0,Class:11.

--

API URL:

https://api.maximizer.com/octopus/Update

REQUEST (sensitive information removed or changed):

{
"Lead": {
"Data": {
"Key": {
"ID": "260225000000381478415LE",
"Number": 0
},
"Email": {
"Address": "[email protected]",
"Description": "",
"Default": true
},
"Address": {
"AddressLine1": "9999 any circle",
"AddressLine2": "",
"City": "Anycity",
"StateProvince": "CO"
},
"Phone1": {
"Default": true,
"Number": "(720) 555-9870",
"Description": "",
"Extension": ""
},
"Udf/$TYPEID(814)": "174945",
"Udf/$TYPEID(574)": "Ed",
"Udf/$TYPEID(518)": "test",
"Udf/$TYPEID(727)": "[email protected]",
"Udf/$TYPEID(519)": "(720) 555-9620",
"Udf/$TYPEID(728)": "1",
"Udf/$TYPEID(729)": "2",
"Udf/$TYPEID(123)": "4",
"Udf/$TYPEID(526)": "2",
"Udf/$TYPEID(872)": "1",
"Udf/$TYPEID(873)": "1",
"Udf/$TYPEID(757)": "1",
"Udf/$TYPEID(874)": null,
"Udf/$TYPEID(880)": "2",
"Udf/$TYPEID(820)": "1",
"Udf/$TYPEID(856)": "1",
"Udf/$TYPEID(704)": "8",
"Udf/$NAME(SUBMITTED DATA\Updated Process ID)": "200028818",
"Udf/$NAME(SUBMITTED DATA\Updated Form ID)": "21",
"Udf/$NAME(SUBMITTED DATA\Updated Entry ID)": "174945"
}
},
"Compatibility": { "LeadObject": "1.3" }
}

RESPONSE:

{ "Code": -5, "Msg": [ { "Message": "Access: Sql was unable to perform the requested operation [Maximizer.Model.Access.Sql]. Sql Message: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nOperation cancelled by user. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at Maximizer.Model.Access.Sql.UdfDataContext2.Save(ISqlContext db, UdfDataContext2 org) in C:\\AzDevOps\\_work\\2\\s\\Maximizer.Model\\Access\\Udf.Sql\\UdfDataContext.cs:line 241\r\n at Maximizer.Model.Access.Sql.LeadDataContext2.Save(ISqlContext db, LeadDataContext2 org) in C:\\AzDevOps\\_work\\2\\s\\Maximizer.Model\\Access\\Lead.Sql\\LeadDataContext.cs:line 361\r\n at Maximizer.Model.Access.Sql.LeadAccess.Create(ILeadObject o, IScope scope, AccessOptions option, Func3 serializer) in C:\AzDevOps\_work\2\s\Maximizer.Model\Access\Lead.Sql\LeadAccess.cs:line 79\r\n at Maximizer.Web.Data.Context.LeadModifyDataContext.Save() in C:\AzDevOps\_work\2\s\WebPortals\Maximizer.Web.Data\Context\LeadDataContext.cs:line 197\r\n at Maximizer.Web.Data.Context.IoContext.Create(String request) in C:\AzDevOps\_work\2\s\WebPortals\Maximizer.Web.Data\Context\IoContext.cs:line 165\r\nClientConnectionId:46593209-648c-4a8a-9f2f-8f821b29f819\r\nError Number:-2,State:0,Class:11.", "ErrorCode": 0 } ] }

When I try later, all is good. Thought best to submit details to the team, as these appear to be occurring more often. Usually started about once every 4 weeks apart; now, seems to happen once every week

Please advise, thanks, Joe