Somebody has removed (by mistake) a user's login id from CTM:People while changing the user to non-support staff. Now I'm trying to update Login ID on CTM:People but it gives me the error below:

AR Error(382) The value(s) for this entry violate a unique index that has been defined for this form

The user does not exist in User and CTM:People Permission Groups form. I've checked the user_cache table, an entry with same login id was available there. Then I've deleted this entry as well. I've also checked H15 table, there is no orphan entry there. If I go to User form and create a user with this login id, I get the same error.

Please see the attached api+filter+sql log. In the log file, you will see the error below which occurs when creating entry in User form.

I've seen a similar problem which was resolved by stopping the server, deleting the ARSystem\bundle-cache directory and restarting. It appears that some of the user/group information may be cached between runs and stored in this directory. There shouldn't be a problem with clearing the contents of this directory as the server will recreate it as required. If you want to play it safe move/rename rather than deleting.

I've updated user with a differerent login id (mark.miller2) and the changed the loginid from mark.miller2 to mark.miller using Data Wizard. It worked successfully. I was expecting it to fail when updating user form but it did not.