Issue with VSE Reporting Feature in Portal after DB upgrade: JasperReports encountered an error on context creation!

Products

• CA Cloud Test Mobile
• CA Application Test
• Service Virtualization

Issue/Introduction

We had recently upgraded DevTest Database from 12c to 19c. 

VSE Reporting feature is not working after the upgrade. Attached the error message received in Portal.


Error from Portal:

JasperReports encountered an error on context creation!

Environment

All supported DevTest releases and platforms.

Cause

The below property for database connection was commented out in the site.properties file:

## lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver  

Due to which it was throwing error in registry.log:

2020-05-14 14:52:57,230Z (09:52) [qtp1117319688-86] ERROR net.sf.jasperreports.web.servlets.ReportContextCreatorServlet - Error on report execution
net.sf.jasperreports.engine.JRException: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//ABCBUILD.CORP.COM:1521/LISADEV
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:130)
    at net.sf.jasperreports.engine.fill.JRFillDataset.contributeParameters(JRFillDataset.java:1034)
 

Resolution

Uncommented property lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver in the site.properties file and re-started Registry.