Skip to Content
Jun 04, 2008 at 02:27 PM

Database error when deleting from Identity Store


I have two tasks to deleted entries from the identity store. One deletes business roles (entry type = MX_ROLE). The other deletes users (entry type = MX_PERSON). I have users in the identity store that are not in my back end systems nor do I want them in those systems.

The task that deletes the MX_ROLE works perfectly.

The task the deletes MX_PERSON fails with the following error:

!ERROR: Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0.

The tasks are very similar - the only difference is the entry type.

The task has worked in the past...

What is causing this error?