[CWD-3984] Rename user in external directory create new user with same external_id - Create and track feature requests for Atlassian products.

XML

Word

Printable

Details

Type: Bug
Status: Resolved
Priority: Medium
Resolution: Duplicate
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
- pse-request

Last commented by user?:
true

Description

Sometimes, when renaming users in a external directory, a new user is created, instead of updating the current one. This causes a duplicity in the pair external_id and directory_id which cause an exception when calling the method com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByExternalId which is used during authentication and synchronization of the external directory.

The error resulting from that operation is:

org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
        at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:590)
        at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375)
        at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindUserByExternalId(HibernateUserDao.java:501)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindByExternalId(HibernateUserDao.java:473)
        at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.findByExternalId(HibernateUserDao.java:449)
        at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByExternalId(CachedCrowdUserDao.java:164)
...

This affects embedded Crowd so other Atlassian applications (Confluence, JIRA,...) may also have this problem.

Attachments

Issue Links

causes

CONFSERVER-33455 After renaming a user in Active Directory, Confluence syncs that user in as a new user (if and only if Confluence is connected to JIRA or Crowd, which is in turn connected to LDAP)

Resolved

CONFSERVER-35047 Confluence user synchronisation create duplicated user account after user rename in the remote repository

Resolved

CONFSERVER-37254 User rename from Crowd create new user in Confluence

Resolved

is caused by

CWD-3513 Publish UserRenamedEvent when user is renamed in LDAP

Resolved

is related to

CONFSERVER-35047 Confluence user synchronisation create duplicated user account after user rename in the remote repository

Resolved

relates to

CONFSERVER-22515 After change an username in Active Directory and resynchronize, there are two accounts showing in Confluence (the old and the new username).

Resolved

CWD-3882 Add unique constraint on columns external_id and directory_id

Open

duplicates: EMBCWD-993 Loading...

links to

CSP-126414

(2 relates to, 1 duplicates, 1 links to)

Activity

People

Assignee:

Unassigned

Reporter:

Alejandro Conde Carrillo (Inactive)

Participants:

Alejandro Conde Carrillo, Avi Knoll, Citrix Devops, Jeffrey H, Jelle Mulckhuijse, Patrik Thunström, Tim Cambra

Votes:

15 Vote for this issue

Watchers:

26 Start watching this issue

Dates

Created:

11/Jul/2014 8:22 AM

Updated:

30/Aug/2017 2:27 PM

Resolved:

16/Sep/2015 5:49 AM

Last commented:

2 years, 48 weeks, 4 days ago