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

book

Article ID: 193574

calendar_today

Updated On:

Products

CLOUDTEST CA Application Test CA Cloud Test Mobile MOBILECLOUD 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!



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:@//LVBUILD.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)

 

Environment

Release : 10.5

Component : CA Service Virtualization

Resolution

Uncommented property lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver in the site.properties file and re-started Registry. The issue gets resolved and reports are opening fine now.