Issue: During a partitioned Refresh Identity task, RefreshWorker 1 throws a StaleStateException when attempting to delete a record from spt_identity_archive. The error occurs at commitTransaction() inside Identitizer.processEvents(), triggered after an Identity Trigger fires during finishRefresh().
Error:
Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from spt_identity_archive where id=?
@Pmanasa Quite possible your identityArchive objects are corrupted.
Could you please try deleting the identityArchive object of a sample identity and try running the process events? (if you are using previousIdentity, you might want to modify your logic for this testing to not use previousIdentity).
can you login to the sailpoint database, and if you know the id, just use the sql queries to delete the user from the table identity_archive.
What is the workflow launched by the trigger doing?
Possibly it is doing something that it shouldn’t.