Missing users in Users & Groups UI

[daniel-mueller]

Describe the bug
We import users from our Keycloak instance using OIDC in the Kubernetes Helm chart. Around 1/3 of our ~100 users don't show up in the users tab of the UI for Users & Groups. I have looked into the graphql file using the dev tools in my browser and see a total of only 62 users. So at that point they are already missing. I checked multiple existing and missing users and there is no difference in Keycloak. Also some new users are correctly shown, older users aren't. The Postgres table metadata-aspects-v2 does not show entries for the missing users, but I can look up some shown users. The behavior appears to be completely random.

However the users that are not shown can login and browse Datahub just fine. Our problem is that we can't make those users editors or change their role.

Expected behavior
All users should show up in Users & Groups.

Additional information
If there is no obvious way to fix this can you please provide me with some help to further debug the problem? Where can I look to find user tables or detect oddities of missing users that are different to the shown users?