I was trying to change the SQL server compatibility level from 2012(110) to 2019(150).
I was expecting everything will work well.
Instead I’ve got error on loading data to WF context. Loading screens works well. Changing the compatibility level back to 2012 currently solved the issue. The error message is Timeout expired, but the SQL server works well and I can create parallel queries.
.
WF log:
2022-09-07 21:55:53,503 [26] ERROR Origam.Workflow.WorkflowEngine - Nastala chyba při načítání dat z tabulky 'BusinessPartner' do entity 'BusinessPartner'
Chyba: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Nastala chyba při ukládání dat. Pro více informací viz Podrobnosti.
Origam.OrigamException: Nastala chyba při načítání dat z tabulky 'BusinessPartner' do entity 'BusinessPartner'
Chyba: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Nastala chyba při ukládání dat. Pro více informací viz Podrobnosti.
---> Origam.UserOrigamException: Nastala chyba při načítání dat z tabulky 'BusinessPartner' do entity 'BusinessPartner'
Chyba: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Nastala chyba při ukládání dat. Pro více informací viz Podrobnosti.
---> System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): The wait operation timed out.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Origam.DA.Service.DataLoader.Fill() in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 150
ClientConnectionId:c97c13d4-65c9-446b-9cce-1dda2a31963c
Error Number:-2,State:0,Class:11
--- End of inner exception stack trace ---
--------------------------------------------
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
--------------------------------------------
at Origam.DA.Service.MsSqlDataService.HandleException(Exception ex, String recordErrorMessage, DataRow row) in D:\a\1\s\backend\Origam.DA.Service\MsSqlDataService.cs:line 180
at Origam.DA.Service.DataLoader.HandleException(Exception ex, String commandText, Boolean logAsDebug) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 173
at Origam.DA.Service.DataLoader.Fill() in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 150
at Origam.DA.Service.Profiler.ExecuteAndTakeLoggingAction(DataStructureEntity entity, Action`2 loggingAction, Action actionToExecute) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 2682
at Origam.DA.Service.AbstractSqlDataService.LoadDataSet(DataStructureQuery query, IPrincipal principal, DataSet dataset, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 378
at Origam.DA.Service.AbstractSqlDataService.LoadDataSet(DataStructureQuery dataStructureQuery, IPrincipal principal, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 284
at Origam.Workflow.DataServiceAgent.LoadData(DataStructureQuery query, DataSet data) in D:\a\1\s\backend\Origam.Workflow\Service Agents\DataServiceAgent.cs:line 141
at Origam.Workflow.DataServiceAgent.LoadData(Guid dataStructureId, Hashtable parameters, Guid methodId, Guid sortSetId) in D:\a\1\s\backend\Origam.Workflow\Service Agents\DataServiceAgent.cs:line 81
at Origam.Workflow.DataServiceAgent.Run() in D:\a\1\s\backend\Origam.Workflow\Service Agents\DataServiceAgent.cs:line 609
at Origam.Workflow.Tasks.ServiceMethodCallEngineTask.OnExecute() in D:\a\1\s\backend\Origam.Workflow\Tasks\ServiceMethodCallEngineTask.cs:line 214
at Origam.Workflow.ProfilingTools.<>c__DisplayClass4_0.<ExecuteAndLogDuration>g__FuncToExecute|0() in D:\a\1\s\backend\Origam.Workflow\ProfilingTools.cs:line 69
at Origam.Workflow.Tasks.AbstractWorkflowEngineTask.MeasuredExecution() in D:\a\1\s\backend\Origam.Workflow\Tasks\AbstractWorkflowEngineTask.cs:line 100
at Origam.Workflow.Tasks.ServiceMethodCallEngineTask.Execute() in D:\a\1\s\backend\Origam.Workflow\Tasks\ServiceMethodCallEngineTask.cs:line 91
--- End of inner exception stack trace ---