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

Solution Unverified - Updated -

Issue

  • See following error:

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

Environment

  • 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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In