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

User Directory update caused System Error when using Oracle

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22469 Editing "User Directories" configuration is not possible for ORACLE DB user due to DataIntegrityViolationException

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-22242 Impossible to empty Additional User DN or Additional Group DN once filled in

          • Medium - Medium priority issues
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-24645 Getting System Error page when trying to edit User Directory or adding "Default Group Memberships" in Confluence 3.5.9 or higher for Oracle users

          • Medium - Medium priority issues
          • Closed

          Activity

            People

              nbhawnani Niraj Bhawnani
              gcheck GuilhermeA
              Votes:
              4 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: