java.sql.SQLSyntaxErrorException When trying to access a user's group panel on the RHSSO 7.6.1 admin console

Issue

• When trying to access a user's group panel on the RHSSO admin console, we a red popup appears and displays an error (see attached picture). We cannot see the groups list.

• When checking the logs we have the following error:

  14:52:35,483 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-1) SQL Error: 1064, SQLState: 42000
  14:52:35,484 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-1) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) order by groupentit0_.NAME ASC limit 20' at line 1
  14:52:35,485 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-1) Uncaught server error: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  at org.hibernate@5.3.27.Final-redhat-00001//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
  [...]
  Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) order by groupentit0_.NAME ASC limit 20' at line 1