ED not showing Data after 10.7.2 Upgrade

Products

• Service Virtualization

Issue/Introduction

ED not showing Data after 10.7.2 Upgrade

 

2023-01-06T15:18:27,210Z (10:18) [qtp877483600-58] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Invalid usage of the option first in the FETCH statement.
2023-01-06T15:18:27,216Z (10:18) [qtp877483600-58] ERROR com.ca.dradis.util.AuditDataUtil - No concurrent VSE Performance usage data was found for the specified time period
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    at org.hibernate.exception.internal.SQLStateConversionDelegate.conve

 

 

Environment

Release : 10.7.2

Cause

Problem occurred due to the absence of following property in the upgraded env dradis.properties file:

dradis.db.driverClass=com.microsoft.sqlserver.jdbc.SQLServerDriver

Resolution

 

Apparently this property was commented out. After uncommenting this property, the problem resolved.