Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-22703

User Directory update caused System Error when using Oracle

XMLWordPrintable

      Problem.

      This appear to only affects Oracle - When editing the User or Group DN, Confluence will return a System Error instead.

      The following is logged:

      2011-07-31 11:02:22,704 ERROR [http-8080-4] [atlassian.plugin.servlet.ServletModuleContainerServlet] service Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert collection rows: [com.atlassian.crowd.model.directory.DirectoryImpl.attributes#1146881]; SQL []; ORA-00001: unique constraint (CONFLUENCE.SYS_C0021643) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.SYS_C0021643) violated

 -- referer: http://paulaner.sydney.atlassian.com:8080/plugins/servlet/embedded-crowd/configure/ldap/ | url: /plugins/servlet/embedded-crowd/configure/ldap/ | userName: confluence-admin
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert collection rows: [com.atlassian.crowd.model.directory.DirectoryImpl.attributes#1146881]; SQL []; ORA-00001: unique constraint (CONFLUENCE.SYS_C0021643) violated
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.SYS_C0021643) violated

      Workaround

      1. Login with internal admin account
      2. Go to Confluence Admin > User Directories, and edit the LDAP directory
      3. Take screenshots of all the settings
      4. Disable the LDAP User Directory
      5. Recreate the directory from scratch with the same settings
      6. If this is successful, Remove the old LDAP directory

      Alternatively, you can modify settings manually in the database. The settings are all stored in the cwd_directory_attribute. This is NOT recommended.

            [CONFSERVER-22703] User Directory update caused System Error when using Oracle

            Peter Macdonald added a comment -

            I have tried this approach and successfully created a new User Directory with the updated "Additional User DN". However, under the new User Directory (when I disable the original), none of the users have maintained their Group membership.

            Peter Macdonald added a comment - I have tried this approach and successfully created a new User Directory with the updated "Additional User DN". However, under the new User Directory (when I disable the original), none of the users have maintained their Group membership.

            Jose Maria Salinas added a comment -

            In 3.5.5 the workaround not solve the issue.

            Jose Maria Salinas added a comment - In 3.5.5 the workaround not solve the issue.

            Chris Andrews added a comment -

            This really needs a fix.

            Chris Andrews added a comment - This really needs a fix.

              nbhawnani Niraj Bhawnani
              gcheck GuilhermeA
              Affected customers:
              4 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: