SCIM Provisioning with SAML SSO

[gbt]

Hi,

I have a Zabbix 7.0.11 and configured SAML SSO with Keycloak 26.
SSO is OK when zabbix user is already created.
But,
My user "gilles" has multiple groups : G1, G2, G3, G4, G5 ......
When I want to use SCIM Procisioning, I got an SQL error :
SQL statement execution has failed "INSERT INTO scim_group (scim_groupid,name) VALUES ('55','G1'),('56','G2'),('57','G3'),('58','G4'),(' 59','G5'),......".

At the end, the user is created into Zabbix as SAML provisioned, but i cant connect with it :-(

Any idea ?

Regards,
Gilles.

[gbt]

By checking my list of groups, it seems there is at least a group twice ....
It should be the root cause of this issue.

[gbt]

By checking the database content, this table is present and is empty

MariaDB [zabbix]> desc scim_group
-> ;
+--------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| scim_groupid | bigint(20) unsigned | NO | PRI | NULL | |
| name | varchar(64) | NO | UNI | | |
+--------------+---------------------+------+-----+---------+-------+
2 rows in set (0.009 sec)

MariaDB [zabbix]> select * from scim_group;
Empty set (0.008 sec)

[gbt]

By checking my list of groups, it seems there is at least a group twice ....
It should be the root cause of this issue.