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.

 

Environment

Release: All Supported Releases
Component: Clarity Data Warehouse

Cause

The possible causes:

1. Jaspersoft server is not running.
2. Generic domain issue.
3. Out of box user with username ppmjasperadmin has been modified and hence Jaspersoft is not able to authenticate the Clarity report user ppmjasperadmin

 

Resolution

• Make sure Jaspersoft server is up and running.
  
  Run the 'Restore Domains' job
  
  If this job fails also, please refer to Clarity PPM Restore Domains Job Failed
  
  
• Check for the username ppmjasperadmin by running the below query and it should return one record  
  • SELECT * FROM cmn_sec_users
    WHERE user_name = 'ppmjasperadmin'
• If the above query doesn't return a row which means username has been modified, then run another query to find out 
  • SELECT * FROM cmn_sec_users
    WHERE user_uid = 'ppmjasperadmin'
• Update the username for resourceid - ppmjasperadmin via Clarity --> Administration --> Resources --> search for resourceid = ppmjasperadmin and update the username to ppmjasperadmin

Note: Please do not make any changes to any out of box seeded users 

Additional Information

See also: Load DWH job frequently reported issues