Violation of UNIQUE KEY constraint 'SIBLING_NAMES'. Cannot insert duplicate key in object 'dbo.KEYCLOAK_GROUP'.

Products

• Service Virtualization

Issue/Introduction

We have validated our LDA settings working properly. We have 1 user who cannot be manually created, or who cannot authenticate. We have validated the account password. 

Errors in the IAM server.log:

2021-04-27 13:01:19,613 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-45) Violation of UNIQUE KEY constraint 'SIBLING_NAMES'. Cannot insert duplicate key in object 'dbo.KEYCLOAK_GROUP'. The duplicate key value is (service_virtualization, <NULL>, BITBUCKET_AAG_AAOS-RW_PROD).

2021-04-27 13:01:26,004 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-46) Violation of UNIQUE KEY constraint 'SIBLING_NAMES'. Cannot insert duplicate key in object 'dbo.KEYCLOAK_GROUP'. The duplicate key value is (service_virtualization, <NULL>, Bitbucket_AAG_PCE-RW_Prod).

 

Environment

All supported DevTest releases.

Cause

There are two group names, one with upper case with the whole name, one the is upper and lower case.

Resolution

Delete the upper and lower case Bitbucket_AAG_PCE-RW_Prod from the Group Setting:

Go to View Groups, select this group from the dropdown and delete group Bitbucket_AAG_PCE-RW_Prod

This resolved the issue.