[MembershipDAOImpl]ORA-00001: unique constraint (IDM.SYS_C0015551) violated --------------------------------------------------------------------------- Key: GTNPORTAL-3489 URL: https://issues.jboss.org/browse/GTNPORTAL-3489 Project: GateIn Portal Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: 3.5.9.Final Reporter: Ahmed Zaoui Assignee: Trong Tran Priority: Minor Fix For: 3.5.11.Final, 3.7.2.Final, 3.9.0.Final Attachments: testDiffgatein-portal.patch When synchronizing new user from ldap with an already created relationship we got this exception: {noformat} 2014-04-29 16:01:05,248 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ajp-arecasapps02/10.100.8.17:14011-2) ORA-00001: unique constraint (IDM.SYS_C0015551) violated 2014-04-29 16:01:05,257 WARN Failed to call postSave for gerap User with listener : class org.exoplatform.services.organization.impl.NewUserEventListener: org.picketlink.idm.common.exception.IdentityException: Cannot create relationship: at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.createRelationship(HibernateIdentityStoreImpl.java:1212) [picketlink-idm-hibernate.jar:1.4.4.Final] at org.picketlink.idm.impl.repository.FallbackIdentityStoreRepository.createRelationship(FallbackIdentityStoreRepository.java:1042) [picketlink-idm-core.jar:1.4.4.Final] at org.picketlink.idm.impl.api.session.managers.RelationshipManagerImpl.associateUserByKeys(RelationshipManagerImpl.java:375) [picketlink-idm-core.jar:1.4.4.Final] at org.exoplatform.services.organization.idm.MembershipDAOImpl.linkMembership(MembershipDAOImpl.java:132) [exo.portal.component.identity-3.5.9.Final_patched.jar:3.5.9.Final] at org.exoplatform.services.organization.impl.NewUserEventListener.createDefaultUserMemberships(NewUserEventListener.java:101) [exo.core.component.organization.api.jar:2.5.8-GA] at org.exoplatform.services.organization.impl.NewUserEventListener.postSave(NewUserEventListener.java:72) [exo.core.component.organization.api.jar:2.5.8-GA] {noformat} We should add test checking the existence of the association before creating new one