Clarity PPM: Unable to Access Jaspersoft Advanced Reporting

Document ID : KB000128882
Last Modified Date : 07/03/2019
Show Technical Document Details
Issue:

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 : bg@server (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

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.