I’m not able to delete items from Worqueue HTML5, which are not locked - see attached image.
I was trying to unlock it using the UnlockQueue workflow, but it didn’t help.
How is the delete action configured?
We cannot reproduce this issue. Can you please try on the latest version + post the part of the server log which includes this message?
Tested o current Master 2021.2.0.2082 and problem persist. Server log attached.
2021-06-02 11:23:30,697 [27] ERROR Origam.DA.Service.AbstractSqlDataService - Update failed
System.Data.SqlClient.SqlException (0x80131904): The column name 'i1' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
at Origam.DA.Service.AbstractSqlDataService.ExecuteUpdate(DataStructureQuery query, String transactionId, UserProfile profile, DataStructure ds, IDbTransaction transaction, IDbConnection connection, ArrayList deletedRowIds, DataTable changedTable, DataRowState rowState, DataStructureEntity entity, Int32 rowCount, Boolean forceBulkInsert) in D:\a\1\s\origam-source\Origam.DA.Service\AbstractSqlDataService.cs:line 851
at Origam.DA.Service.AbstractSqlDataService.<>c__DisplayClass23_2.<UpdateData>b__0() in D:\a\1\s\origam-source\Origam.DA.Service\AbstractSqlDataService.cs:line 557
at Origam.DA.Service.Profiler.ExecuteAndTakeLoggingAction(DataStructureEntity entity, Action`2 loggingAction, Action actionToExecute) in D:\a\1\s\origam-source\Origam.DA.Service\AbstractSqlDataService.cs:line 2682
at Origam.DA.Service.AbstractSqlDataService.UpdateData(DataStructureQuery query, IPrincipal userProfile, DataSet dataset, String transactionId, Boolean forceBulkInsert) in D:\a\1\s\origam-source\Origam.DA.Service\AbstractSqlDataService.cs:line 553
ClientConnectionId:447f7b01-5e86-428e-af8d-529f007ed712
Error Number:264,State:1,Class:16
2021-06-02 11:23:30,699 [27] ERROR Origam.ServerCore.Controller.AbstractController - Položky jsou uzamčeny jiným procesem. Nelze zpracovat položky fronty zpráv.
Origam.Workflow.WorkQueue.WorkQueueItemLockedException: Položky jsou uzamčeny jiným procesem. Nelze zpracovat položky fronty zpráv.
at Origam.Workflow.WorkQueue.WorkQueueService.LockQueueItems(WorkQueueClass wqc, DataTable selectedRows) in D:\a\1\s\origam-source\Origam.Workflow\WorkQueue\WorkQueueService.cs:line 1015
at Origam.Workflow.WorkQueue.WorkQueueService.HandleAction(Guid queueId, String queueClass, DataTable selectedRows, Guid commandType, String command, String param1, String param2, Boolean lockItems, Object errorQueueId, String transactionId) in D:\a\1\s\origam-source\Origam.Workflow\WorkQueue\WorkQueueService.cs:line 827
at Origam.Workflow.WorkQueue.WorkQueueService.HandleAction(Guid queueId, String queueClass, DataTable selectedRows, Guid commandType, String command, String param1, String param2, Object errorQueueId) in D:\a\1\s\origam-source\Origam.Workflow\WorkQueue\WorkQueueService.cs:line 795
at Origam.Server.ServerEntityUIActionRunner.ExecuteQueueAction(ExecuteActionProcessData processData) in D:\a\1\s\origam-source\Origam.ServerCommon\ServerEntityUIActionRunner.cs:line 166
at Origam.Server.ServerEntityUIActionRunner.PerformAppropriateAction(ExecuteActionProcessData processData) in D:\a\1\s\origam-source\Origam.ServerCommon\ServerEntityUIActionRunner.cs:line 60
at Origam.Gui.EntityUIActionRunner.ExecuteAction(String sessionFormIdentifier, String requestingGrid, String entity, String actionType, String actionId, Hashtable parameterMappings, IList selectedItems, Hashtable inputParameters) in D:\a\1\s\origam-source\Origam.Gui\EntityUIActionRunner.cs:line 59
at Origam.ServerCore.ServerCoreUIService.ExecuteAction(ExecuteActionInput input) in D:\a\1\s\origam-source\Origam.ServerCore\ServerCoreUIService.cs:line 493
at Origam.ServerCore.Controller.UIServiceController.<>c__DisplayClass25_0.<ExecuteAction>b__0() in D:\a\1\s\origam-source\Origam.ServerCore\Controller\UIServiceController.cs:line 237
at Origam.ServerCore.Controller.AbstractController.RunWithErrorHandler(Func`1 func) in D:\a\1\s\origam-source\Origam.ServerCore\Controller\AbstractController.cs:line 87I think this is the problem. Your work queue data structure seems to contain the field twice?