Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. 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

XMLWordPrintable

      This seems to be a cause or regression of CONF-22469.

      Scenario #1

      1. Create a new LDAP User Directory.
      2. Leave "Default Group Memberships" field empty
      3. Test and save.
      4. Edit the User Directory, add any group in "Default Group Memberships". For example, confluence-users
      5. Test and save and bam! You'll get System Error page instead. This error is thrown in the log:
        2012-02-03 16:44:15,489 INFO [http-8414-2] [crowd.embedded.admin.ConfigurationController] doInTransaction User directory updated: [ Active Directory server ], type: [ CONNECTOR ]
        2012-02-03 16:44:15,608 ERROR [http-8414-2] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        
         -- referer: http://localhost:8414/plugins/servlet/embedded-crowd/configure/ldap/ | url: /plugins/servlet/embedded-crowd/configure/ldap/ | userName: adminconf
        2012-02-03 16:44:15,610 ERROR [http-8414-2] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
         -- referer: http://localhost:8414/plugins/servlet/embedded-crowd/configure/ldap/ | url: /plugins/servlet/embedded-crowd/configure/ldap/ | userName: adminconf
        2012-02-03 16:44:15,616 ERROR [http-8414-2] [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#360450]; SQL []; ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        
         -- referer: http://localhost:8414/plugins/servlet/embedded-crowd/configure/ldap/ | url: /plugins/servlet/embedded-crowd/configure/ldap/ | userName: adminconf
        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#360450]; SQL []; ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        
        	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:583)
        	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        	at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:42)
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        	at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:52)
        	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
        	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
        	at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
        	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.security.websudo.MessagesDecoratorFilter.doFilter(MessagesDecoratorFilter.java:59)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
        	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:40)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
        	at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:30)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
        	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
        	at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71)
        	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:37)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
        	at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
        	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.util.ConfluenceErrorFilter.doFilter(ConfluenceErrorFilter.java:22)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:35)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:80)
        	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
        	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
        	at com.atlassian.confluence.extra.webdav.servlet.filter.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:427)
        	at com.atlassian.confluence.extra.webdav.servlet.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:34)
        	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
        	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
        	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter.doFilter(RequestParamValidationFilter.java:58)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.web.filter.TranslationModeFilter.doFilter(TranslationModeFilter.java:43)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.plugin.servlet.filter.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:71)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.web.filter.LanguageExtractionFilter.doFilter(LanguageExtractionFilter.java:54)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
        	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at com.atlassian.confluence.servlet.FourOhFourErrorLoggingFilter.doFilter(FourOhFourErrorLoggingFilter.java:65)
        	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
        	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        	at java.lang.Thread.run(Thread.java:662)
        Caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert collection rows: [com.atlassian.crowd.model.directory.DirectoryImpl.attributes#360450]; SQL []; ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        
        	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
        	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        	at org.springframework.orm.hibernate.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:619)
        	at org.springframework.orm.hibernate.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:605)
        	at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:518)
        	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
        	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
        	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
        	at com.atlassian.sal.spring.component.SpringHostContextAccessor.doInTransaction(SpringHostContextAccessor.java:82)
        	at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        	at java.lang.reflect.Method.invoke(Method.java:597)
        	at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
        	at $Proxy254.doInTransaction(Unknown Source)
        	at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        	at java.lang.reflect.Method.invoke(Method.java:597)
        	at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)
        	at $Proxy254.doInTransaction(Unknown Source)
        	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21)
        	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        	at java.lang.reflect.Method.invoke(Method.java:597)
        	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
        	at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
        	at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
        	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
        	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
        	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        	at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
        	at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
        	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        	at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
        	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
        	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
        	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        	at $Proxy403.execute(Unknown Source)
        	at com.atlassian.crowd.embedded.admin.ConfigurationController.saveDirectory(ConfigurationController.java:165)
        	at com.atlassian.crowd.embedded.admin.ConfigurationController.onSubmit(ConfigurationController.java:75)
        	at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)
        	at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)
        	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
        	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
        	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
        	... 131 more
        Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated
        
        	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
        	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
        	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
        	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
        	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
        	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
        	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
        	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
        	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
        	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657)
        	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
        	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        	at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
        	at net.sf.hibernate.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:610)
        	at net.sf.hibernate.impl.ScheduledCollectionUpdate.execute(ScheduledCollectionUpdate.java:49)
        	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
        	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
        	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2393)
        	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
        	at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
        	at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:510)
        	... 176 more
        2012-02-03 16:44:15,889 INFO [http-8414-2] [atlassian.confluence.status.SystemErrorInformationLogger] writeToLog 
        Request Unique ID : 829488b3-5d78-42a2-8359-6ac171f7fa94
        --------------------------
        JVM Stats
        --------------------------
        allocatedHeap = 380895232
        availablePermGen = 110690232
        usedMemory = 255053560
        totalMemory = 380895232
        freeMemory = 125841672
        maxPermGen = 268435456
        usedPermGen = 157745224
        freeMemoryInMegabytes = 120
        freeAllocatedHeap = 125841672
        availableHeap = 222179592
        usedMemoryInMegabytes = 243
        maxHeap = 477233152
        usedHeap = 255053560
        totalMemoryInMegabytes = 363
        --------------------------
        Request Information
        --------------------------
        URL: http://localhost:8414/500page.jsp
        Scheme: http
        Server: localhost
        Port: 8414
        URI: /500page.jsp
        Context Path: 
        Servlet Path: /500page.jsp
        Path Info: null
        Query String: null
        --------------------------
        Attributes
        --------------------------
        javax.servlet.forward.request_uri: /plugins/servlet/embedded-crowd/configure/ldap/
        javax.servlet.forward.context_path: 
        javax.servlet.forward.servlet_path: /plugins/servlet
        javax.servlet.forward.path_info: /500page.jsp
        os_securityfilter_already_filtered: true
        com.atlassian.seraph.auth.LoginReason: OK
        com.atlassian.confluence.security.websudo.MessagesDecoratorFilter__already_filtered__: true
        org.springframework.web.servlet.DispatcherServlet.THEME_SOURCE: ECWebApplicationContext: display name [Root WebApplicationContext]; startup date [Fri Feb 03 16:05:08 MYT 2012]; parent: org.springframework.osgi.atlassian.NonValidatingOsgiBundleXmlApplicationContext@7bfa88e6
        atlassian.core.seraph.original.url: /plugins/servlet/embedded-crowd/configure/ldap/
        org.springframework.web.servlet.DispatcherServlet.THEME_RESOLVER: org.springframework.web.servlet.theme.FixedThemeResolver@300073e4
        org.springframework.web.servlet.DispatcherServlet.CONTEXT: ECWebApplicationContext: display name [Root WebApplicationContext]; startup date [Fri Feb 03 16:05:08 MYT 2012]; parent: org.springframework.osgi.atlassian.NonValidatingOsgiBundleXmlApplicationContext@7bfa88e6
        javax.servlet.error.status_code: 500
        javax.servlet.error.servlet_name: servlet-module-container-servlet
        com.opensymphony.sitemesh.USINGSTREAM: false
        org.springframework.web.servlet.HandlerMapping.pathWithinHandlerMapping: 
        com.atlassian.gzipfilter.GzipFilter_already_filtered: true
        loginfilter.already.filtered: true
        com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered: true
        Confluence-Request-Time: 1328258655473
        javax.servlet.error.message: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert collection rows: [com.atlassian.crowd.model.directory.DirectoryImpl.attributes#360450]; SQL []; ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONF414HALATASLOCAL.SYS_C0016900) violated 
        com.opensymphony.sitemesh.APPLIED_ONCE: true
        confluence.websudo.request: true
        com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered: true
        confluence.messages: {websudo-message=com.atlassian.confluence.security.websudo.WebSudoMessage@6db8965a}
        __cleanup_recursion_counter: 0
        com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter_already_filtered: true
        javax.servlet.error.request_uri: /plugins/servlet/embedded-crowd/configure/ldap/
        org.springframework.web.servlet.DispatcherServlet.LOCALE_RESOLVER: org.springframework.web.servlet.i18n.AcceptHeaderLocaleResolver@719726fc
        --------------------------
        Parameters
        --------------------------
        port : 389
        ldapUserPassword : unicodePwd
        ldapUserdn : CN=admin admin,CN=Users,dc=customware,dc=internal
        ldapUserFilter : (&(objectCategory=Person)(sAMAccountName=*))
        save : Save
        _nestedGroupsEnabled : visible
        ldapSearchTimelimitInSec : 60
        _ldapUsermembershipUse : visible
        _ldapReferral : visible
        ldapConnectionTimeoutInSec : 10
        ldapGroupUsernames : member
        ldapUserObjectclass : user
        directoryId : 360450
        ldapUserUsername : sAMAccountName
        ldapGroupName : cn
        type : com.atlassian.crowd.directory.MicrosoftActiveDirectory
        ldapUserFirstname : givenName
        _useSSL : visible
        crowdSyncIncrementalEnabled : true
        _ldapRelaxedDnStandardisation : visible
        name : Active Directory server
        ldapUserDn : 
        ldapCacheSynchroniseIntervalInMin : 60
        ldapAutoAddGroups : confluence-users
        ldapPagedresultsSize : 1000
        atl_token : 7397e6bfaeafe4daf995d640c66d91028504f9a0
        ldapPagedresults : true
        hostname : 10.60.1.186
        _crowdSyncIncrementalEnabled : visible
        ldapPassword : admin
        ldapBasedn : dc=customware,dc=internal
        ldapUserUsernameRdn : cn
        ldapUserDisplayname : displayName
        ldapGroupDn : 
        ldapUserEncryption : sha
        ldapReadTimeoutInSec : 120
        ldapUserLastname : sn
        ldapPermissionOption : READ_ONLY_LOCAL_GROUPS
        _ldapUsermembershipUseForGroups : visible
        ldapGroupObjectclass : group
        ldapRelaxedDnStandardisation : true
        ldapGroupDescription : description
        ldapUserEmail : mail
        newForm : true
        ldapGroupFilter : (objectCategory=Group)
        ldapReferral : true
        ldapUserGroup : memberOf
        _ldapPagedresults : visible
        

      Scenario #2

      1. Create a new LDAP User Directory.
      2. Ensure to fill something in "Default Group Memberships"
      3. Test and Save. User Directory will be created successfully.
      4. One won't be able to edit the User Directory at all once there is a value in "Default Group Memberships" which is very similar to CONF-22469.
      5. The error thrown is the same as scenario #1

      Workaround:

      Please backup your Confluence database first.

      For scenario #1:
      1. Login with internal admin account
      2. Remove the LDAP User Directory
      3. Recreate from scratch with the same settings and ensure that you've filled the "Default Group Memberships" with the desired local groups accordingly.
      For scenario #2

      You will need to modify any changes manually in the database. The settings are all stored in the cwd_directory_attribute.conne

            Unassigned Unassigned
            halatas HuseinA
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: