Ppmjasperadmin user not found in Jaspersoft

book

Article ID: 224795

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

“User ppmjasperadmin not available in report server. Resource ppmjasperadmin not found. code:resource.not.found  parameter:["ppmjasperadmin"]”  in the admin logs.

"Create and Update Jaspersoft Users" completes, but processes no users. An error is logged in the bg logs stating that "role_resource_designer" doesn't exist.

Cause

A new Jaspersoft application server has been set up, but the Jaspersoft content has not been imported.

Environment

Release : 15.9.2

Component : Clarity Install and Upgrade

Resolution

On the Clarity server, run this command to import the Jaspersoft content:

admin content-jaspersoft csk -userName superuser -password <password>

If this message is received:

Cannot import content on same release, use force flag to import. Skipping import.

This would mean that Jaspersoft had been previously installed for the environment, but perhaps into a different Jaspersoft install.

In order to complete the required import, the references to the previous install needs to be removed. To do this access the database server and do the following:

1. Make a backup of the table: CMN_INSTALL_HISTORY 

2. Run a command to remove the references to Jaspersoft:

Delete from CMN_INSTALL_HISTORY where install_id like '%jasper'%;

3. Try to run the previous admin command again to import the default content.

Additional Information

Please ensure a database backup is completed prior to making any change directly to the database to avoid the risk of data loss.