Execution Timeout Expired

Unknown

Execution Timeout Expired

Unknown

We have a query that have the time out in seconds set to 360 (I believe that is the limit), when we debug the flow it takes 1 minute and 5 seconds, but the query is throwing an exception error of "Execution Timeout Expired". If the query is only taking 1 minute 5 seconds why am I getting an error or is there any way to fix it

DROP TABLE #tmpKMES;] ---> DecisionsFramework.LoggedException: Error message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at DecisionsFramework.Data.ORMapper.DatabaseDrivers.MsSqlCommandWithDecimalReader.ExecuteReader() at DecisionsFramework.Data.ORMapper.DatabaseDrivers.DBCommandLoggin.ExecuteReader() --- End of inner exception stack trace --- at DecisionsFramework.Data.ORMapper.DatabaseDrivers.DBCommandLoggin.ExecuteReader() at DecisionsFramework.Data.ORMapper.SqlQueryWithParams.FillResult(IDbConnection conn, IORMDatabaseInterface driver) at DecisionsFramework.Data.ORMapper.ExternalDatabaseServer.RunQuery(ReturnSetSQLStatement statement) --- End of inner exception stack trace --- at DecisionsFramework.Data.ORMapper.ExternalDatabaseServer.RunQuery(ReturnSetSQLStatement statement) at DecisionsFramework.ServiceLayer.Services.DatabaseIntegration.FlowSteps.BaseDatabaseStep.RunQuery(StepStartData data, ReturnSetSQLStatement statement) at DecisionsFramework.ServiceLayer.Services.DatabaseIntegration.FlowSteps.BaseReturnOptionStep.Run(StepStartData data)","3/22/2023 3:50:28 PM