I have a strange case already made a support call a few weeks ago, but there is no progress on it so far...
So this proces ends up in a frozen state I think the issue stared since upgrading from 9.2 to 9.2.1: VI_Attestation_AttestationCase_AutoRemoveMemberships
(Automatically removes memberships and assignments after negative attestation case decision)
The error:
[81*****222] Error running script 'VI_AttestationCase_RemoveMembership'. [81*****457] Error saving PersonWantsOrg TECH - OCM - Contractmanager - Doe, John - 1/24/2*****23 1:25:51 PM [81*****3*****6] Error running 'OnSaving' in logic module 'QER.Customizer.PersonWantsOrg'. [81**********29] Object of type PwOState does not exist in database or you do not have the relevant viewing permissions.
From the logs I can see that there is rollback:
select * from (select UID_PwOState from PwOState where ((PwOState.Ident_PwOState = N'Denied because I am not the owner.') or (PwOState.UID_PwOState = 'Denied because I am not the owner.'))) as x ORDER BY (select null) 2024-09-30 17:20:47.0042 DEBUG (ObjectLog 9137fddc-1eff-495f-a9bf-1fab68ba17a8 Job 3ea1b065-f8b2-41f1-86b9-97688a6b3d94) : Collection: Run statement and fetch data done in 3ms. 2024-09-30 17:20:47.0042 DEBUG (ObjectLog 9137fddc-1eff-495f-a9bf-1fab68ba17a8 Job 3ea1b065-f8b2-41f1-86b9-97688a6b3d94) : Collection.Count: 0 2024-09-30 17:20:47.0042 DEBUG (ObjectLog 9137fddc-1eff-495f-a9bf-1fab68ba17a8 Job 3ea1b065-f8b2-41f1-86b9-97688a6b3d94) : Getting collection done in 6ms. 2024-09-30 17:20:47.0042 DEBUG (ObjectLog 9137fddc-1eff-495f-a9bf-1fab68ba17a8 Job 3ea1b065-f8b2-41f1-86b9-97688a6b3d94) : Rollback transaction in read/write entity 2024-09-30 17:20:47.0192 DEBUG (ObjectLog 9137fddc-1eff-495f-a9bf-1fab68ba17a8 Job 3ea1b065-f8b2-41f1-86b9-97688a6b3d94) : Session: Rollback Transaction
Now it looks like the QER.Customizer.PersonWantsOrg rolls back because it cannot find an entry in the table PWOState with the Ident_PwOState = 'Denied because I am not the owner.'
My question is should this entry be in the PWOState table, because I only see one entry in this table: Ident_PwOState = 'Assigned by self-service'?
Regards,
Niels
