topic Re: Can not delete a user in Alfresco Archive

Can not delete a user

konsultex — Sun, 20 Jul 2008 01:01:06 GMT

I am running Alfresco 2.9.0 (B 683) schema 116 on Windows 2003 R2 X64 with MySql 5.0.51b on the same server. Java is 1.6.0 for 64 bits. After another person added about 60 users I was told that there was a problem with two of them. Since the users were defined over a period of several days I am not

Re: Can not delete a user

konsultex — Wed, 30 Jul 2008 19:53:59 GMT

Does anybody have ideas for deleting these users?

Re: Can not delete a user

samuel_penn — Tue, 12 Aug 2008 10:22:51 GMT

No idea if this helps at all, but I was recently having a similar issue (on an Alfresco 2.2 system where NTLM has never been used). Trying to delete a user gave the following error:


Unable to delete the User object associated with the Person. 
This is not an error if an external authentication mechanism such as NTLM was previously active.
Failed to delete User due to error: 
could not delete: [org.alfresco.repo.domain.hibernate.DbAuthorityImpl#9]; nested exception is 
org.hibernate.exception.ConstraintViolationException: 
could not delete: [org.alfresco.repo.domain.hibernate.DbAuthorityImpl#9]
‍‍‍‍‍‍‍‍

In the alfresco.log, there were database (MySQL) constraint errors listed. No duplicate users as far as I could tell, but deleting the user always failed with the same errors. Since the user had a user home of "/Company Home", I tried creating another space, giving the user permission to that and updating the user to use this new space as their home. Attempting to delete the user after doing this still gave an error:


Unable to delete the User object associated with the Person. 
This is not an error if an external authentication mechanism such as NTLM was previously active.
‍‍‍‍

However, the user was actually deleted this time. Not sure whether this helps or not, but there does seem to be some issues in this area.

Sam.

Re: Can not delete a user

konsultex — Thu, 21 Aug 2008 18:38:21 GMT

Gentlemen,

Unfortunately I had to go into production with this database and so far nothing helped. Even though the repository is working fine (so far…. knock on wood) I have occasional errors when creating or accessing users, not just these examples. This does not really worry me but I am concerned that this situation could cause a repository corruption problem. I read posts about people having great problems in recovering their repositories.

I wonder if anybody at Alfresco has an idea of what's going on and how to get rid of the bad users. Or if anybody was successful in doing this.

Re: Can not delete a user

regainfo — Tue, 02 Dec 2008 16:12:35 GMT

I also got trying to delete a user with no Home Space on Alfresco Labs3 :
Unable to delete the User object associated with the Person. This is not an error if an external authentication mechanism such as NTLM was previously active.
I think that the create of user did not work properly so the user cannot be deleted

Re: Can not delete a user

umass89 — Tue, 03 Mar 2009 22:10:13 GMT

I had similar issues as in this thread and deleting unwanted users. I resolved the issue by running the following javascript snippet:

var badUser = people.getPerson("testID") ;
badUser.remove();

Re: Can not delete a user

chicks — Wed, 13 May 2009 18:08:59 GMT

I don't recommend using the script above, as it will leave null users in any groups to which the user was a member, and none of the group's users will be visible.

This is still an issue in labs 3.0Final. There are several open issues in jira, and several posts in these forums, to which Alfresco engineers have given vague responses, but have obviously never actually tested or encountered the issue.

It's a real issue, which results in a user list with long-gone users who cannot be removed. Some real attention to the issue would be appreciated!

Re: Can not delete a user

josw — Fri, 15 May 2009 07:50:28 GMT

As i used NTLM for Testing without getting die Admin users working, i have the same orphaned users in my system.
There must be a way to delete certain user info or even reset all of them.
That's a real Issue here and a short info would be lovely.

Re: Can not delete a user

dbr9449 — Fri, 22 May 2009 21:41:01 GMT

We had a problem with duplicates on two userids. Now when we try to delete the userid, we get an error message that the user cannot be deleted because it does not exist.

We looked but were unable to find where Alfresco stores the userids. Does anyone know where that would be?

At this point, using the show all button on the manage system users screen results in an error message ending with:
java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0

Does anyone know how to delete the non-existing users or bring back the show all users button?

Thanks.

Re: Can not delete a user

stevewickii — Fri, 05 Jun 2009 14:40:54 GMT

The users are in a different store: user://alfrescoUserStore

Log into the Alfresco web client as "admin", and open the Node Browser in the Administration Console.

The users are located under /sys:system/syseople.

Re: Can not delete a user

stevewickii — Fri, 05 Jun 2009 14:42:14 GMT

I recommend incremental database backups, and plenty of them. Restore is the easiest way to undo these issues.

Re: Can not delete a user

jarrett — Fri, 31 Jul 2009 14:16:37 GMT

Has there been any resolution this issue? I am now dealing with this same problem. I did set re-index to FULL and restarted hoping that would resolve the issue but it didn't seem to have any effect. Thanks

Re: Can not delete a user

dward — Fri, 31 Jul 2009 14:33:07 GMT

I think this is a bug in org.alfresco.web.bean.users.UsersDialog.deleteOK(). If, for one reason or another, the call to AuthenticationService.deleteAuthentication() fails, then it doesn't delete the person.

I have logged https://issues.alfresco.com/jira/browse/ETHREEOH-2601

You could work around it by temporarily configuring defaultmutableauthenticationdao as your authentication DAO.

Re: Can not delete a user

jbaldo — Fri, 31 Jul 2009 18:11:38 GMT

You could work around it by temporarily configuring defaultmutableauthenticationdao as your authentication DAO.

Could you elaborate on how to do this in 3.2? Is it documented on the wiki somewhere?

Re: Can not delete a user

dward — Mon, 10 Aug 2009 11:11:39 GMT

FYI this has now been fixed in HEAD. See https://issues.alfresco.com/jira/browse/ALFCOM-3278.

Re: Can not delete a user

dward — Thu, 20 Aug 2009 11:04:39 GMT

Apologies. There were problems with the original fix to the user deletion problem that were found during testing. These have now been resolved in HEAD. See

https://issues.alfresco.com/jira/browse/ETHREEOH-2601