Violation of UNIQUE KEY constraint "SIBLING_NAMES" in RH-SSO 7

Solution Unverified - Updated -


  • See following error:

    Caused by: Violation of UNIQUE KEY constraint 'SIBLING_NAMES'. Cannot insert duplicate key in object 'xxxx.KEYCLOAK_GROUP'. The duplicate key value is (xxxx, <NULL>, xxxx).


  • Red Hat Single Sign-On (RH-SSO)
    • 7.2
    • 7.3
  • Microsoft SQL Server Database (MSSQL)
  • Lightweight Directory Access Protocol (LDAP) or Microsoft Active Directory Lightweight Directory Service (AD)
  • LDAP configuration has a group-ldap-mapper with "Preserve Group Inheritance" turned off.

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In