How to view Jaspersoft Report logs (jasperserver.log) for Clarity SaaS customers

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Unlike Clarity On-Premise customers, there is no direct access by a Clarity SaaS customer to get the Jaspersoft log folder.

It is sometimes necessary to see the Clarity "Advanced Reporting (Jaspersoft) logs to:

1) Troubleshoot why a report is failing
2) Test if the Jaspersoft Scheduler Server email functionality is working properly.

How can Clarity SaaS customers do this?

Environment

Advice is relevant for both Clarity SaaS and Clarity On-Premise customers, on all versions.

On-Premise customers have server level/direct access to the jasperserver.log if needed. There is no direct access by a Clarity SaaS customer to get the Jaspersoft log folder

Resolution

If you Schedule a Report, you can send the Stack Trace to an email address.

This will contain any error messages generated while the report was attempting to run.

From CA PPM Advanced Reporting (Jaspersoft), Schedule a Report.

At the bottom right, there are options to enable a "Stack trace."

Enable these, and re-run the report.

When you receive the report, it will contain output similar to the following:

2018-07-04 16:19:55,536 ERROR AsyncJasperPrintAccessor,pool-6-thread-21335:321 [cppm99999_dev|MY_CA_PPM_SERVER] - Error during report execution
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: repo:/ca_ppm/resources/images/circleGreen.
    at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:116)
    at net.sf.jasperreports.repo.InputStreamPersistenceService.load(InputStreamPersistenceService.java:45)
    at net.sf.jasperreports.repo.DefaultRepositoryService.getResource(DefaultRepositoryService.java:149)
    at net.sf.jasperreports.repo.RepositoryUtil.findInputStream(RepositoryUtil.java:190)
    at net.sf.jasperreports.repo.RepositoryUtil.getBytesFromLocation(RepositoryUtil.java:206)
    at net.sf.jasperreports.renderers.util.RendererUtil.getNonLazyRenderable(RendererUtil.java:163)
    at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:538)
    at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:482)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381)
    at net.sf.jasperreports.engine.fill.JRFillFrame.evaluate(JRFillFrame.java:159)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381)
    at net.sf.jasperreports.engine.fill.JRFillFrame.evaluate(JRFillFrame.java:159)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381)
    at net.sf.jasperreports.engine.fill.JRFillFrame.evaluate(JRFillFrame.java:159)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381)
    at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:500)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2028)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:749)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:256)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:586)
    at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:398)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:732)
    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)
    at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: net.sf.jasperreports.engine.JRException: Error opening input stream from URL: repo:/ca_ppm/resources/images/circleGreen.
    at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:343)
    at net.sf.jasperreports.repo.DefaultRepositoryService.getInputStream(DefaultRepositoryService.java:99)
    ... 27 more
Caused by: java.io.IOException: Repository file resource /ca_ppm/resources/images/circleGreen could not be loaded
    at com.jaspersoft.jasperserver.api.engine.jasperreports.util.repo.RepositoryConnection.getInputStream(RepositoryConnection.java:103)
    at java.net.URL.openStream(URL.java:1045)
    at net.sf.jasperreports.engine.util.JRLoader.getInputStream(JRLoader.java:339)
    ... 28 more