Clarity PPM: Unable to Access Jaspersoft Advanced Reporting

Article Id: 128882

Status: Published

Updated On: 07-03-2019 07:39

Products:

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

Issue/Introduction:

The Jaspersoft has been down.
The Load DWH and Create and Update Jaspersoft Users job fails if the service is not up and running.

The Jaspersoft URL can be accessed and login is possible.

When accessing Home > Advanced Reporting, the following is displayed:

Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator. In the BG log, the following error will appear:

Cause:

The errors occur in the BG logs:

Create and Update Jaspersoft Users job fails with error:
Failed to get an instance of ClarityJasperAdmin :: Exception getting ClarityJasperAdmin : Connection refused: connect

ERROR 2017-10-17 15:32:07,139 [Dispatch Create and Update Jaspersoft Users : [email protected] (tenant=clarity)] jasper.ClarityJasperAdmin (clarity:admin:5158052__EA95BA45-172D-4069-8004-6BF7050E0A88:Create and Update Jaspersoft Users) Could not login to http://server:8081/reportservice with username ppmjasperadmin
com.ca.jasper.restAdapter.JasperException: Connection refused: connect

Environment:

Release:
Component: PPMPRD

Resolution:

Find out if any changes have been made in the CSA and/or properties.xml files recently to the following fields:

HTTP
HTTPS
HTTP URL
HTTPS URL

If so, perform a clean restart of app, bg, nsa sevices.

Check if Home > Advanced Reporting is accessible.

If the problem persists, please contact the Support team for further assistance.