Concurrency exception error when deleting in a workflow

A workflow has a transformation step that deletes matches in a data set. The records are then stored in three different steps with defined data structure in the parameters. The second store step ends with a concurrency exception error about the data being already deleted.

Changes of a record 'd1ef9e13-d0b6-4ce6-bc46-5dbaa495f1ca' in 'RentalTransactionOffer' 
cannot be saved because the record has been deleted by another user.
-------------------------------- 
Concurrency violation: the DeleteCommand affected 0 of the expected 1 records.
   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 563
   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 2698
   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 569
1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.