ERROR: invalid byte sequence for encoding "UTF8": 0x00 'When: ImportUseres Enabled'

1

Hi,
we are trying to sync ldap users into our keycloak instance.

If set Userfederation -> LDAP -> ImportUseres Enabled

If we disable ImportUsers Login works.
We looked after the encoding and utf-8 is set in keycloak and in the postgres database korrektly.

When we try to sync the users, or try to login following Error occurs.
Error Message form the Logs:

Mär 05 13:55:57 sererv2 kc.sh[836]: 2025-03-05 13:55:57,675 INFO  [org.keycloak.storage.ldap.LDAPStorageProviderFactory] (executor-thread-12541) Sync all users from LDAP to local store: realm: kommonitor, federation provider: ldap
Mär 05 13:55:58 sererv2 kc.sh[836]: 2025-03-05 13:55:58,903 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (executor-thread-12541) SQL Error: 0, SQLState: 22021
Mär 05 13:55:58 sererv2 kc.sh[836]: 2025-03-05 13:55:58,903 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (executor-thread-12541) ERROR: invalid byte sequence for encoding "UTF8": 0x00
Mär 05 13:55:58 sererv2 kc.sh[836]:   Where: portal "C_44010" parameter $3

Thankyou in advance

2

It ist working.
We updated to the latest key cloak Version 26.1.4.
We had to change the GUID ind the LDAP user federation. To another unique attribute than GUID after that it worked, and wie can now edit the imported users.