Problem with Users when Importing Alfresco Repository

[lnagra]

Hi,

We're using Alfresco 1.1

We 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 no documents or added users. I then reversed the export process for the import.

Copied across the backed up alf_data
and loaded the mysql dump into the target database

Searching and retrieving documents appears to work without a problem.
Users do not seem to be transferred across to the target database however.

e.g.
using http://localhost:8080/alfresco/faces/jsp/users/users.jsp to view the list of users only displays the default Admin user and we get error occuring on create user or delete user.

If you then log out and try to login again with the admin user, the following error is recieved:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.alfresco.repo.security.authentication.AuthenticationException: Could not find user by userName: admin
   org.alfresco.repo.security.authentication.AbstractAuthenticationComponent.setCurrentUser(AbstractAuthenticationComponent.java:84)
   org.alfresco.repo.security.authentication.AuthenticationServiceImpl.validate(AuthenticationServiceImpl.java:111)
   sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source)
   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   java.lang.reflect.Method.invoke(Method.java:585)
   org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
   org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
   org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
   org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
   org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
   $Proxy19.validate(Unknown Source)
   org.alfresco.web.app.servlet.AuthenticationHelper.authenticate(AuthenticationHelper.java:66)
   org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:67)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It would appear this is because the user information becomes out of sync when transferring data.

Is it possible to either:

Cleanly transfer users? OR
Isolate users from being affected by the import process?

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.

Kind Regards,

Lakhdip

[davidc]

If you performed a full database export/import then users will be transferred.  Ensure your repository.properties on your destination alfresco point to your new imported database and copied alf_data directory.