search cancel

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


Article ID: 38606


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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>.


Release: All Supported Releases
Component: Clarity Data Warehouse


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


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 -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

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

Additional Information

See also: Load DWH job frequently reported issues


1558686654172000038606_sktwi1f5rjvs16f0y.jpeg get_app
1558686651067000038606_sktwi1f5rjvs16f0x.jpeg get_app