[keycloak-user] Problem: ORA-00001: Unique Constraint Error by Ldap group in group

[Pühringer Stefan]

Hallo!

We are currently evaluate the keycloak version 6.0.1 , but we ran in an error while sync ldap groups in groups.

My teststructure in ldap is:
Testgroup (Top Level Group)
     -> Subgroup (Part of Testgroup)
             User 1 (Part of Subgroup)

At the sync process we get following error:

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: Unique Constraint (KEYCLOAK.SIBLING_NAMES) verletzt

            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
            at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
            at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
            at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
            at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
            at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
            at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865)
            at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845)
            at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
            at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)
            at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
            ... 97 more
Caused by: Error : 1, Position : 0, Sql = insert into KEYCLOAK_GROUP (NAME, PARENT_GROUP, REALM_ID, ID) values (:1 , :2 , :3 , :4 ), OriginalSql = insert into KEYCLOAK_GROUP (NAME, PARENT_GROUP, REALM_ID, ID) values (?, ?, ?, ?), Error Msg = ORA-00001: Unique Constraint (KEYCLOAK.SIBLING_NAMES) verletzt

            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
            ... 113 more



Does someone have the same problem or a solution (i found this related and closed issue: https://issues.jboss.org/browse/KEYCLOAK-5405 )?


Thanks!
Stefan