Uploaded image for project: 'Crowd'
  1. Crowd
  2. CWD-3984

Rename user in external directory create new user with same external_id

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Medium
    • None
    • None
    • None

    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

          Bug - A problem which impairs or prevents the functions of the product. 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)

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-35047 Confluence user synchronisation create duplicated user account after user rename in the remote repository

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-37254 User rename from Crowd create new user in Confluence

          • Medium - Medium priority issues
          • Closed
          is caused by

          Suggestion - CWD-3513 Publish UserRenamedEvent when user is renamed in LDAP

          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-35047 Confluence user synchronisation create duplicated user account after user rename in the remote repository

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22515 After change an username in Active Directory and resynchronize, there are two accounts showing in Confluence (the old and the new username).

          • Medium - Medium priority issues
          • Closed

          Suggestion - CWD-3882 Add unique constraint on columns external_id and directory_id

          • Gathering Interest
          duplicates

          EMBCWD-993 Loading...

          links to

          Web Link CSP-126414

          Activity

            People

              Unassigned Unassigned
              aconde Alejandro Conde Carrillo (Inactive)
              Votes:
              15 Vote for this issue
              Watchers:
              26 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: