Unable to add user to web project: NonUniqueObjectException

[tvaughan77]

Hi,

I have an Alfresco labs 3d/stable installation running on CentOS 5.2 w/ MySQL 5.0.5.  I have Alfresco configured to authenticate against an OpenLDAP instance running on another server.

I can create new users in OpenLDAP and they can log in to Alfresco successfully.  When I try to "invite them to web project", I get this error:

11:24:51,792 User:admin ERROR [ui.common.Utils] A system error happened during the operation: a different object with the same identifier value was already associated with the session: [org.alfresco.repo.avm.PlainDirectoryNodeImpl#59074]

org.hibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: [org.alfresco.repo.avm.PlainDirectoryNodeImpl#59074]‍‍‍

They are not already members of that web project.

I can create a new "dummy" web project and invite them to that new project without any issues.

Does anyone have any ideas?

[kabes]

We have the same issue running Labs 3d on Debian with Postgres 8.3.

Adding a user to a web project runs for approx 1.5 hours before aborting with a NonUniqueObjectException.

It appears data related as it only affects one of our instances and they're all configured identically. We can replicate it elsewhere by restoring the affected DB and alf_data to another environment.

Unfortunately we haven't identified what is causing the issue, but I can tell you what hasn't worked.

So far we have tried:
1. Full Lucene re-index.
2. Cleanup of all workflow avm nodes
3. Cleanup of deployment reports
4. Removal of old snapshots

We plan to try deleting and rebuilding the webproject from scratch if all else fails, but would really prefer not to have to do this.