java.sql.SQLIntegrityConstraintViolationException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Error in Mirroring site to target sytem in WCS
    via by Sremugaan,
  • GitHub comment 2440#254041246
    via GitHub by gpproton
    ,
  • Cannot insert NULL into column
    via Stack Overflow by Scott
    ,
  • This error can occur when the group is set as lowercase in Crowd when actually the original group in LDAP is uppercase. {code} caused by: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.crowd.embedded.hibernate2.HibernateMembership#188383471]; SQL []; ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110) caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) 2012-12-18 15:07:49,153 INFO [TP-Processor14] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] updateGroups Deleted user "user1"'s imported membership of remote group "group1" to directory "Delegated Authentication Directory". 2012-12-18 15:07:49,158 INFO [TP-Processor14] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importMembership Imported user "user1"'s membership of remote group "group1" to directory "Delegated Authentication Directory". 2012-12-18 15:07:49,162 ERROR [TP-Processor14] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-00001: unique constraint (CONFLUENCE.CWD_UNIQUE_MEMBERSHIP) violated {code} Workaround: 1) Compare the groups in your Crowd with the groups in your LDAP to find out which are different (lowercase instead of uppercase). 2) Remove the users from all these groups. 3) Use GUI or SQL to remove the lowercase groups from the DB. 4) Perform a Flush - Administration->Cache Statistics->Flush All 5) Try to login with using a user that was inside on of this groups. 6) RESTART Confluence Application
    via by Bruna Griebeler [Atlassian],
  • Erro ao finalizar documento
    via GitHub by Chrystinne
    ,
    • java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (SITESUSER.I1435333282413) violated at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4680) at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4825) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1913) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871) at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318) at weblogic.jdbc.wrapper.Statement.execute(Statement.java:485) at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:995) at COM.FutureTense.Servlet.JDBCConn$1.execute(JDBCConn.java:606) at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189) at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:611) at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2199) at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2186) at COM.FutureTense.CatalogManager.MirrorEngine.commitTables_trans_logic(MirrorEngine.java:3960) at COM.FutureTense.CatalogManager.MirrorEngine$1.execute(MirrorEngine.java:3634) at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:189) at COM.FutureTense.CatalogManager.MirrorEngine.commitTables_trans(MirrorEngine.java:3639) at COM.FutureTense.CatalogManager.MirrorEngine.commitTables(MirrorEngine.java:3118) at COM.FutureTense.Common.CatalogManager.execute(CatalogManager.java:2024) at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129) at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.fatwire.cs.core.logging.context.filter.ContextHeaderFilter.doFilterWork(ContextHeaderFilter.java:37) at com.fatwire.cs.core.logging.context.filter.RunOncePerRequestFilter.doFilter(RunOncePerRequestFilter.java:54) at com.fatwire.cs.core.logging.context.filter.HttpFilter.doFilter(HttpFilter.java:46) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:193) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at COM.FutureTense.Servlet.URLRewriteFilter.doFilter(URLRewriteFilter.java:81) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:701) at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    18 more bugmates