topic Problem with Users when Importing Alfresco Repository in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-with-users-when-importing-alfresco-repository/m-p/14318#M6175 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>We're using Alfresco 1.1</SPAN><BR /><BR /><SPAN>We wish to reuse a standard set of test data (documents + metadata) for every developer and between versions.</SPAN><BR /><BR /><SPAN>To export the data, I attempted to back up the source alf_data and performed a mysql dump of the alfresco database.</SPAN><BR /><BR /><SPAN>The target is a clean deployment of Alfresco with no documents or added users. I then reversed the export process for the import.</SPAN><BR /><BR /><SPAN>Copied across the backed up alf_data</SPAN><BR /><SPAN>and loaded the mysql dump into the target database</SPAN><BR /><BR /><SPAN>Searching and retrieving documents appears to work without a problem.</SPAN><BR /><SPAN>Users do not seem to be transferred across to the target database however.</SPAN><BR /><BR /><SPAN>e.g.</SPAN><BR /><SPAN>using </SPAN><A href="http://localhost:8080/alfresco/faces/jsp/users/users.jsp" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco/faces/jsp/users/users.jsp</A><SPAN> to view the list of users only displays the default Admin user and we get error occuring on create user or delete user.</SPAN><BR /><BR /><SPAN>If you then log out and try to login again with the admin user, the following error is recieved:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>HTTP Status 500 -<BR /><BR />type Exception report<BR /><BR />message<BR /><BR />description The server encountered an internal error () that prevented it from fulfilling this request.<BR /><BR />exception<BR /><BR />org.alfresco.repo.security.authentication.AuthenticationException: Could not find user by userName: admin<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.security.authentication.AbstractAuthenticationComponent.setCurrentUser(AbstractAuthenticationComponent.java:84)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.repo.security.authentication.AuthenticationServiceImpl.validate(AuthenticationServiceImpl.java:111)<BR />&nbsp;&nbsp;&nbsp;sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)<BR />&nbsp;&nbsp;&nbsp;org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)<BR />&nbsp;&nbsp;&nbsp;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)<BR />&nbsp;&nbsp;&nbsp;org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)<BR />&nbsp;&nbsp;&nbsp;org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<BR />&nbsp;&nbsp;&nbsp;org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)<BR />&nbsp;&nbsp;&nbsp;$Proxy19.validate(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:66)<BR />&nbsp;&nbsp;&nbsp;org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:67)<BR /><BR />note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.<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></CODE></PRE><BR /><SPAN>It would appear this is because the user information becomes out of sync when transferring data.</SPAN><BR /><BR /><SPAN>Is it possible to either:</SPAN><BR /><BR /><UL><STRONG>Cleanly transfer users? OR<BR />Isolate users from being affected by the import process?</STRONG></UL><BR /><SPAN>I appreciate that this will be something that is looked at in Alfresco 1.3, but our development effectiveness is currently hindered by not being able to quickly establish a test set of data to work with.</SPAN><BR /><BR /><SPAN>Kind Regards,</SPAN><BR /><BR /><SPAN>Lakhdip</SPAN></BODY></HTML> Wed, 15 Mar 2006 17:54:13 GMT lnagra 2006-03-15T17:54:13Z Problem with Users when Importing Alfresco Repository https://connect.hyland.com/t5/alfresco-archive/problem-with-users-when-importing-alfresco-repository/m-p/14318#M6175 Hi,We're using Alfresco 1.1We wish to reuse a standard set of test data (documents + metadata) for every developer and between versions.To export the data, I attempted to back up the source alf_data and performed a mysql dump of the alfresco database.The target is a clean deployment of Alfresco with Wed, 15 Mar 2006 17:54:13 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-users-when-importing-alfresco-repository/m-p/14318#M6175 lnagra 2006-03-15T17:54:13Z Re: Problem with Users when Importing Alfresco Repository https://connect.hyland.com/t5/alfresco-archive/problem-with-users-when-importing-alfresco-repository/m-p/14319#M6176 <HTML><HEAD></HEAD><BODY><SPAN>If you performed a full database export/import then users will be transferred.&nbsp; Ensure your repository.properties on your destination alfresco point to your new imported database and copied alf_data directory.</SPAN></BODY></HTML> Fri, 17 Mar 2006 18:16:11 GMT https://connect.hyland.com/t5/alfresco-archive/problem-with-users-when-importing-alfresco-repository/m-p/14319#M6176 davidc 2006-03-17T18:16:11Z