cancel
Showing results for 
Search instead for 
Did you mean: 

Can not delete a user

konsultex
Confirmed Champ
Confirmed Champ
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 sure exactly what happened. The person created another user for the ones with the problem. I suspect either some problem with MySql at some point during work with that user or the possibility of the person having used the "back" button in the browser to navigate to a previous page and do things over again.

One of the problem users has a strange user name. The other one does not have a home space.

When I search for the user (navarro) I get two of them. One with a strange name like this "navarro0bb1f5d7-55d5-11dd-9e5d-fd03a0685fe4" and the other one normal. I can not delete any of those 2 users. What I get in the web client is:

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.

Since I am not using NTLM or other external mechanism this message shows a problem. In this case the log does not show anything (I may need to enable something in log4j.properties but I'm not sure what).

I noticed this problem when trying to invite users to spaces. When I try to find all the candidates I get this:

A system error happened during the operation: Node does not exist: workspace://SpacesStore/21f6438e-51e9-11dd-8aca-e505e54c21ae

I would really like to get rid of these users because I am afraid of going into production with a corrupt database. I saw just a few references to the error message in the forum so this must not be a common problem but I did not see any solution there. Does anybody know how I can get rid of these users through Alfresco, MySql, Web Script, etc?

Thanks.
15 REPLIES 15

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

jarrett
Champ in-the-making
Champ in-the-making
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

dward
Champ on-the-rise
Champ on-the-rise
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.

jbaldo
Champ in-the-making
Champ in-the-making
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?

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

dward
Champ on-the-rise
Champ on-the-rise
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