Update removed entity. Message: During a save action an entity's update action failed. The entity which failed is enclosed.

Posts   
 
    
politadek
User
Posts: 1
Joined: 29-Jul-2019
# Posted on: 29-Jul-2019 13:45:46   

Hello,

I have master table Rep and several details tables related by foreign keys to Rep (1 : N). The detail table RepStr has column Lp (ordinal number). The events EntityAdded() and EntityRemoved() of entity collection RepertStr execute renumerate Lp procedure.

Exists one instance RemoveTracker (EntityCollection<EntityBase2>) for all details entity collections.

Example:

Step 1 (after fetch RepEntity and RepStr entity collecion (by PrefetchPath): RepId = 15979, RepStrId = 25234, Lp = 1 RepId = 15979, RepStrId = 25235, Lp = 2

RepId = 15979, RepStrId = 25236, Lp = 3

RemoveTracker.Count() = 0

Step 2: After removing first row RepertStrId = 25234 RepId = 15979, RepStrId = 25235, Lp = 1 (changed 2 -> 1)

ReptId = 15979, RepStrId = 25236, Lp = 2 (changed 3 -> 2)

RepStr entity collection RemoveTracker.Count() = 1

Step 3: After removing second row RepStrId = 25235

ReptId = 15979, ReptStrId = 25236, Lp = 1 (changed 2 -> 1)

RemoveTracker.Count() = 2

Step 4: Save RepEntity:

if(RemoveTracker.Count > ) { adapter.DeleteEntityCollection(RemoveTracker); }

adapter.SaveEntity(RepEntity, true, true) throw exception: Date: 29.07.2019 13:28:54 Type: SD.LLBLGen.Pro.ORMSupportClasses.ORMConcurrencyException Source: SD.LLBLGen.Pro.ORMSupportClasses Message: During a save action an entity's update action failed. The entity which failed is enclosed. StackTrace: w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.PerformPostEntitySaveActions(Boolean insertActions, ActionQueueElement1 element, EntityBase2 entityToSave, Boolean saveSucceeded) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterCore.cs:wiersz 7580 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.<PersistQueue>b__74_2(Boolean a, ActionQueueElement1 b, EntityBase2 c, Boolean d) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterCore.cs:wiersz 1273 w SD.LLBLGen.Pro.ORMSupportClasses.ActionQueryController.PerformPostPersistenceQueryExecuted(PackedActionQuery packedQuery, Int32 amountSaved) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\ActionQueryController.cs:wiersz 348 w SD.LLBLGen.Pro.ORMSupportClasses.ActionQueryController.PerformPostActionQueryWork(Int32 resultActionQuery, PackedActionQuery packedQuery) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\ActionQueryController.cs:wiersz 229 w SD.LLBLGen.Pro.ORMSupportClasses.ActionQueryController.ExecuteElements(List1 elementsToRun) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\ActionQueryController.cs:wiersz 175 w SD.LLBLGen.Pro.ORMSupportClasses.ActionQueryController.Execute(ActionQueueElement1 actionQueueElement, IActionQuery query, Type typeOfNextElement) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\ActionQueryController.cs:wiersz 104 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.PersistQueue(List1 queueToPersist, Boolean insertActions) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterCore.cs:wiersz 1309 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, IPredicateExpression updateRestriction, Boolean recurse) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterCore.cs:wiersz 1235 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.<>c__DisplayClass19_0.<SaveEntity>b__0() w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:wiersz 413 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteWithActiveRecoveryStrategy[T](Func1 toExecute) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:wiersz 919 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, IPredicateExpression updateRestriction, Boolean recurse) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:wiersz 413 w SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.SaveEntity(IEntity2 entityToSave, Boolean refetchAfterSave, Boolean recurse) w C:\Myprojects\VS.NET Projects\LLBLGen Pro v5.5\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterCore.cs:wiersz 1150 w Notarius.BLL.RepertWpisProvider.Save(DataAccessAdapter adapter) w D:\projects_svn\Notarius\source\Notarius.BLL\RepertWpisProvider.cs:wiersz 322 w Notarius.Repert.EditForm.SaveEntity(DataAccessAdapter adapter, IEntity2 entityToSave) w D:\projects_svn\Notarius\source\Notarius\Repert\EditForm.cs:wiersz 158 w Notarius.BaseForms.BaseEditDataForm.SaveData() w D:\projects_svn\Notarius\source\Notarius.BaseForms\BaseEditDataForm.cs:wiersz 152

SQL Commands: .... Query: DELETE FROM [Not].[dbo].[RepStr] WHERE ( [Not].[dbo].[RepStr].[RepStrId] = @p1) Parameter: @p1 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 25235.

..... Query: UPDATE [Not].[dbo].[RepStr] SET [Lp]=@p1 WHERE ( [Not].[dbo].[RepStr].[RepStrId] = @p2) Parameter: @p1 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 1. Parameter: @p2 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 25235.

Last command try update removed entity...

What Can I do this problem?

Best regards politadek

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 29-Jul-2019 19:05:04   

Which runtime library version are you using (please check the forum guidelines for this number)?

Could you please post the minimum code snippet to reproduce the issue?

Thanks