Cannot execute reports via Jaspersoft Studio

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• A data adapter is defined in Jaspersoft Studio
• It has JDBC Driver set to 'tibcosoftware.jdbc.oracle.OracleDriver'
• Intermittently when this adapter is used to execute a report, it throws the following error message:
  net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: java.sql.SQLException: [TibcoSoftware][Oracle JDBC Driver]null
 at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:551)
• However, if executions are attempted many times, it is noted that at some point it becomes successful.

Resolution

NOT VALIDATED: The customer did not confirm that the following resolved their issue.

• Recreate the Data Adapter