OrchardCore: Workflow script function executeQuery() throws "The connection does not support MultipleActiveResultSets."
Using a workflow script task, i’m trying to update a content item by creating a simple javascript object. Probably related #4963
2019-12-23 04:55:19.8850|Default|80000148-0001-f900-b63f-84710c7967bb||OrchardCore.Workflows.Services.WorkflowStore|ERROR|IWorkflowHandler thrown from OrchardCore.Workflows.Http.Handlers.WorkflowRoutesHandler by InvalidOperationException System.InvalidOperationException: The connection does not support MultipleActiveResultSets. at Microsoft.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at Microsoft.Data.SqlClient.SqlInternalTransaction.Rollback() at Microsoft.Data.SqlClient.SqlInternalTransaction.Dispose(Boolean disposing) at Microsoft.Data.SqlClient.SqlInternalTransaction.Dispose() at Microsoft.Data.SqlClient.SqlTransaction.Dispose(Boolean disposing) at System.Data.Common.DbTransaction.Dispose() at YesSql.Session.ReleaseTransaction() at YesSql.Session.Cancel() at YesSql.Session.FlushAsync() at YesSql.Services.DefaultQuery.Query1.FirstOrDefaultImpl() at OrchardCore.Workflows.Http.Handlers.WorkflowRoutesHandler.UpdateRouteEntriesAsync(WorkflowContext context) in C:\projects\orchardcore\src\OrchardCore.Modules\OrchardCore.Workflows\Http\Handlers\WorkflowInstanceRoutesHandler.cs:line 44 at OrchardCore.Workflows.Http.Handlers.WorkflowRoutesHandler.CreatedAsync(WorkflowCreatedContext context) in C:\projects\orchardcore\src\OrchardCore.Modules\OrchardCore.Workflows\Http\Handlers\WorkflowInstanceRoutesHandler.cs:line 27 at OrchardCore.Modules.InvokeExtensions.InvokeAsync[TEvents,T1](IEnumerable1 events, Func3 dispatch, T1 arg1, ILogger logger) in C:\projects\orchardcore\src\OrchardCore\OrchardCore.Abstractions\Modules\Extensions\InvokeExtensions.cs:line 134 at Microsoft.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at Microsoft.Data.SqlClient.SqlInternalTransaction.Rollback() at Microsoft.Data.SqlClient.SqlInternalTransaction.Dispose(Boolean disposing) at Microsoft.Data.SqlClient.SqlInternalTransaction.Dispose() at Microsoft.Data.SqlClient.SqlTransaction.Dispose(Boolean disposing) at System.Data.Common.DbTransaction.Dispose() at YesSql.Session.ReleaseTransaction() at YesSql.Session.Cancel() at YesSql.Session.FlushAsync() at YesSql.Services.DefaultQuery.Query1.FirstOrDefaultImpl() at OrchardCore.Workflows.Http.Handlers.WorkflowRoutesHandler.UpdateRouteEntriesAsync(WorkflowContext context) in C:\projects\orchardcore\src\OrchardCore.Modules\OrchardCore.Workflows\Http\Handlers\WorkflowInstanceRoutesHandler.cs:line 44 at OrchardCore.Workflows.Http.Handlers.WorkflowRoutesHandler.CreatedAsync(WorkflowCreatedContext context) in C:\projects\orchardcore\src\OrchardCore.Modules\OrchardCore.Workflows\Http\Handlers\WorkflowInstanceRoutesHandler.cs:line 27 at OrchardCore.Modules.InvokeExtensions.InvokeAsync[TEvents,T1](IEnumerable1 events, Func3 dispatch, T1 arg1, ILogger logger) in C:\projects\orchardcore\src\OrchardCore\OrchardCore.Abstractions\Modules\Extensions\InvokeExtensions.cs:line 134
About this issue
- Original URL
- State: closed
- Created 5 years ago
- Comments: 15 (12 by maintainers)
Repro: