Load DWH fails with error "Could not login to Jaspersoft"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load Data Warehouse (DWH) job fails with error: Could not login to Jaspersoft, domains could not get updated for customizations.

The Create and Update Jaspersoft Users job may also fail with the error: Failed to get an instance of ClarityJasperAdmin : Unauthorized access to: <URL>.

Cause

Jaspersoft Reporting is not able to authenticate the Clarity report user: ppmjasperadmin
The authentication between Clarity and Jaspersoft needs to be reviewed. 

Environment

Release: All Supported Releases
Component: Clarity Data Warehouse

Resolution

Table of Contents

• Step 1: Review the BG + BG DWH logs for the specific error
• Step 2: Make sure the Jaspersoft Tomcat service is started
• Step 3: Make sure that the certificate is valid and has not expired
• Step 4: Reinstall the Jaspersoft Content
• Step 5: Regenerate the Jaspersoft keystore
• Step 6: Run the job: Create and Update Jaspersoft Users

Step 1: Review the BG + BG DWH logs for the specific error

Step 2: Make sure the Jaspersoft Tomcat service is started

Step 3: Make sure that the certificate is valid and has not expired

Make sure that the certificate on the Jaspersoft Server is valid and has not expired

1. One way to check is to go to the Jaspersoft Reporting URL (the reporting URL can be found in CSA > Reporting > Web URL. 
2. If you see a warning message in the URL in the browser window, this can be an indicator that the certificate is expired.
3. View the certificate, if you see a message "This certificate is expired or not yet valid" the certificate would need to be updated. See the HTTPS Enabled Jaspersoft section of Jaspersoft Reports Server Troubleshooting Tips for details on importing certificates. 

Step 4: Reinstall the Jaspersoft Content

1. Obtain the CSA > Reporting > Web URL
2. Open the URL in a browser and log in with superuser login.
3. Delete the target Organization.
4. On the Clarity Server, run the following command to install the Jaspersoft content
5. admin content-jaspersoft csk -userName superuser -password superuser -fileName jaspersoft_csk.zip -retryCount 50

Step 5: Regenerate the Jaspersoft keystore

1. Go to the CLARITY_INSTALL/bin folder and enter command:
   admin jaspersoft keystore
2. This will generate the following files in the CLARITY_INSTALL/config folder:
   • <orgname>.jks (key store file)
   • <orgname>.properties (information about the key)
3. Copy the 2 generated files to the Tomcat for Jaspersoft folder
   TOMCAT_JASPERSOFT/webapps/reportservice/WEB-INF/config

Step 6: Run the job: Create and Update Jaspersoft Users

Additional Information

See also: Load DWH job frequently reported issues