ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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'.

book

Article ID: 214127

calendar_today

Updated On:

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).

 

Cause

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

Environment

Release : 10.5.1

Component : CA Service Virtualization

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.