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.