topic Unable to delete users using web service in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74841#M49089 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use the web service to create and delete users. I've noticed that if I try to recreate a user that has already been deleted (using the web service) I get a duplicate user exception. I also noticed that the following entry in the node_properties table is still available for users that I've deleted using the web service:</SPAN><BR /><BR /><SPAN>node_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; actual_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string_value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;qname</SPAN><BR /><SPAN><SPAN>614&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;STRING&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN><A class="jive-link-email-small" href="mailto:alfrescotestuser3@test.com" rel="nofollow noopener noreferrer">alfrescotestuser3@test.com</A><SPAN>&nbsp;&nbsp;&nbsp;{</SPAN></SPAN><A href="http://www.alfresco.org/model/user/1.0}username" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/user/1.0}username</A><BR /><BR /><SPAN>After looking at the code for AdministrationWebService.createUsers() and AdministrationWebService.deleteUsers(), I found that AdministrationWebService.createUsers() contains a call to authenticationService.createAuthentication() and a call to personService.createPerson(). However, AdministrationWebService.deleteUsers() only calls personService.deletePerson() - it does not delete the authentication for that user. This, I believe, is the source of the duplicate user exception that is thrown if I try to create another user with the same username. I've also included an example below of how I am using the web service. Am I using it incorrectly? Is this a known problem with the web service?</SPAN><BR /><BR /><SPAN>I'm using alfresco v1.3</SPAN><BR /><BR /><SPAN>Any advice would be greatly appreciated!</SPAN><BR /><BR /><SPAN>my code:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />createAlfrescoUser() {<BR />&nbsp;&nbsp;&nbsp;…<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;AuthenticationUtils.startSession(USER,PASSWORD);<BR />&nbsp;&nbsp;&nbsp;NewUserDetails[] newUsers = new NewUserDetails[] {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new NewUserDetails(<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; username,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new NamedValue[] {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new NamedValue(Constants.PROP_USER_EMAIL, false,email,null), <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new NamedValue(Constants.PROP_USER_FIRSTNAME, false,"bogus",null), <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new NamedValue(Constants.PROP_USER_LASTNAME, false,"bogus",null)}<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )};<BR />&nbsp;&nbsp;&nbsp;WebServiceFactory.getAdministrationService().createUsers(newUsers);<BR />&nbsp;&nbsp;&nbsp;AuthenticationUtils.endSession();<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;…<BR />}<BR /><BR />deleteAlfrescoUser() {<BR />&nbsp;&nbsp;&nbsp;…<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;AuthenticationUtils.startSession(USER,PASSWORD);<BR />&nbsp;&nbsp;&nbsp;WebServiceFactory.getAdministrationService().deleteUsers(new String[] {usernameToDelete});<BR />&nbsp;&nbsp;&nbsp;AuthenticationUtils.endSession();<BR />&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;…<BR />&nbsp;&nbsp;&nbsp;<BR />}<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 02 Nov 2006 20:07:43 GMT adamss 2006-11-02T20:07:43Z Unable to delete users using web service https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74841#M49089 I am trying to use the web service to create and delete users. I've noticed that if I try to recreate a user that has already been deleted (using the web service) I get a duplicate user exception. I also noticed that the following entry in the node_properties table is still available for users that Thu, 02 Nov 2006 20:07:43 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74841#M49089 adamss 2006-11-02T20:07:43Z Re: Unable to delete users using web service https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74842#M49090 <HTML><HEAD></HEAD><BODY><SPAN>I've responded in this article </SPAN><A href="http://forums.alfresco.com/viewtopic.php?t=1600" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=1600</A></BODY></HTML> Fri, 03 Nov 2006 10:28:14 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74842#M49090 rwetherall 2006-11-03T10:28:14Z Re: Unable to delete users using web service https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74843#M49091 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the update rwetheral. In the meantime, do you know how I can remove these orphan authentication records? I have some users who were deleted using the web service and now need to be recreated (using their original usernames). Some of these users have also created content. Is there a way I can remove the authentication records from the database so that alfresco will not throw a duplicate user exception when I try to recreate the user?</SPAN><BR /><BR /><SPAN>Thanks in advance for your help!</SPAN></BODY></HTML> Fri, 17 Nov 2006 19:58:44 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74843#M49091 adamss 2006-11-17T19:58:44Z Re: Unable to delete users using web service https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74844#M49092 <HTML><HEAD></HEAD><BODY><SPAN>If you login in alfresco with the user's login and password, you'll could find it in alfresco admin panel.</SPAN><BR /><BR /><SPAN>Sorry for my english&nbsp; :lol:</SPAN></BODY></HTML> Mon, 20 Nov 2006 14:15:47 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74844#M49092 lorel 2006-11-20T14:15:47Z Re: Unable to delete users using web service https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74845#M49093 <HTML><HEAD></HEAD><BODY><SPAN>Hi all.</SPAN><BR /><BR /><SPAN>Lorel, I think adamss would like to completely remove the user from the repository via web services and, more in general, programatically and not using the control panel for the administrator.</SPAN><BR /><BR /><SPAN>I have the same problem, it could be great if someone tell us the best way to remove the orphan authentication records.</SPAN><BR /><BR /><SPAN>Would it be enough to delete the orphan record from the alf_nodes database table? Are there any other references to the user inside different tables?</SPAN><BR /><BR /><SPAN>Many thanks to all.</SPAN><BR /><BR /><SPAN>All the best,</SPAN><BR /><BR /><SPAN>Sergio</SPAN></BODY></HTML> Thu, 21 Dec 2006 14:37:18 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74845#M49093 sergio 2006-12-21T14:37:18Z Re: Unable to delete users using web service https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74846#M49094 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Duplicate users are handled in 2.0. (Duplicates will be split, deleted, or one picked …)</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Wed, 10 Jan 2007 16:13:13 GMT https://connect.hyland.com/t5/alfresco-archive/unable-to-delete-users-using-web-service/m-p/74846#M49094 andy 2007-01-10T16:13:13Z