DevTest Enterprise dashboard shows inaccurate data in 10.6 - GenericJDBCException: could not prepare statement

book

Article ID: 212058

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

Hi Team, 

Enterprise dashboard data shows inaccurate data and haven't changed in several days and weeks. Please help fix this ED data and to fetch accurate results.

2021-03-09 19:00:09,158Z (11:00) [Thread-21] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null
2021-03-09 19:00:09,158Z (11:00) [Thread-21] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Connection is closed.
2021-03-09 19:00:09,158Z (11:00) [Thread-21] ERROR com.ca.dradis.BeanProcessor    - Exception
org.hibernate.exception.GenericJDBCException: could not prepare statement
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)

Environment

Release : 10.6

Component : CA Service Virtualization

Resolution

 

Please open a ticket with Broadcom support.  And  request for  'dradis-10.6.0_DE498205.jar' .  

Additional Information

Steps to apply:

 

1. Stop ED

2. Backup the file LISA_HOME/lib/dradis/dradis-10.6.0.jar

3. Copy the solution file "dradis-10.6.0_DE498205.jar" to LISA_HOME/lib/dradis folder

4. Start ED and verify if the reported problems are addressed.