search cancel

Authentication is failing from Devtest workstation


Article ID: 242882


Updated On:


CA Application Test


Workstation is not able to authenticate with admin credentials. All components Registry, ED and IAM components are running state.

Verified ED console login. From ED console also unable to login.

In IAM log file, we see below error message. 

2022-05-17 00:00:07,240 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) SQL Error: 90098, SQLState: 90098
2022-05-17 00:00:07,256 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-12) The database has been closed [90098-193]
2022-05-17 00:00:07,256 INFO  [org.hibernate.event.internal.DefaultLoadEventListener] (default task-12) HHH000327: Error performing load command : org.hibernate.exception.GenericJDBCException: could not extract ResultSet
 at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(
 ... 67 more
Caused by: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(


Release : 10.6

Component :


 The error is due to database connection failure during startup. Since you are using Embeded database and the size of the database is large, IAM is not able to establish the connection.

    You can re-created the database by taking backup of "data" folder and restarting the IAM service. With this change, IAM will re-create the database and you can connect all components to IAM.