CA PPM: Issue when previewing a report in Jaspersoft Studio 'Error executing SQL statement

book

Article ID: 128016

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

When we try to preview an existing report or query in Jaspersoft Studio, an error message is displayed indicating an error like below

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for:

This problem in previewing occurs regardless of the report or query we choose, though testing our connection to the database reveals a successful connection is made. Advanced Reporting itself works fine and we can use/edit reports as normal, but the problem is in previewing reports via Jaspersoft Studio.

This issue typically can occur if you haven't upgraded your Jaspersoft Studio client to use the new CA JDBC Adapters and/or version of the client corresponding to your Jaspersoft server version. 

Environment

Release:
Component: ODJSP

Resolution

1) Download the Jaspersoft Studio 7.1 with the CA JDBC Adapter ISO according to your CA PPM version from here CA PPM Advanced Reporting and Database Schema Index

2) Uninstall Jaspersoft Studio 6.4 client if present on the machine

3) Unpackage and install the Jaspersoft Studio 7.1 client