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

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2902404 ] New: CONFSERVER Bug Workflow v4 [ 3002477 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2799719 ] New: JAC Bug Workflow v3 [ 2902404 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2730172 ] New: JAC Bug Workflow v2 [ 2799719 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2395340 ] New: JAC Bug Workflow [ 2730172 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2291423 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2395340 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2229061 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2291423 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2185881 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2229061 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1924387 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2185881 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1733415 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1924387 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1690318 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1733415 ]

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

                Created:
                Updated:
                Resolved: