search cancel

Authentication is failing from Devtest workstation

book

Article ID: 242882

calendar_today

Updated On:

Products

CA Application Test

Issue/Introduction

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
(Method.java:498)
 at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:49)
 ... 67 more
Caused by: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)

Environment

Release : 10.6

Component :

Resolution

 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.