Copying CA PPM Database from Development to Test environment generates user is not authorized error message when users try to run reports

Products

• Clarity PPM On Premise

Issue/Introduction

Question: 

What is the method that should be used to leave the Jaspersoft reports usable after copying the clarity Database from development to Test?

Answer:

When restoring the CA PPM Database from another environment, the best practice is to run the following procedure:

For CA PPM 14.2 use the following commands:

Admin jasper keystore

To generate key and password, enter:

Admin jasper keystore [-key <key>password <password>/

These command generates the following files in <install>/config/and <install>/META-INF/reporting/store.

• <orgname>.jks(key store file)
• <orgname>.properties(information about the key)

Copy these files to <Tomcat>/webapps/<jasperwebcontext>/WEB-INF/config where Jaspersoft is installed. For example, <Tomcat>/webapps/reportservice/WEB-INF/config.

Then execute the following command:

Admin content-jaspersoft csk –userName <superuser> password <superuser> upgrade-retryCount 50 force

This will update the ppmjasperadmin user and also update the DataSource (Beans) user information to the DWH and CA PPM.

For CA PPM 14.3 and above use the following commands:

Admin jaspersoft keystore

To generate key and password, enter:

Admin Jaspersoft keystore [-key <key>password <password>/

These commands generates the following files in <install>/config/and <install>/META-INF/reporting/store.

• <orgname>.jks(key store file)
• <orgname>.properties(information about the key)

Copy these files to <Tomcat>/webapps/<jasperwebcontext>/WEB-INF/config where Jaspersoft is installed. For example, <Tomcat>/webapps/reportservice/WEB-INF/config.

Then execute the following commands:

Open a command prompt in the install directory/bin and execute the following command:

Admin content-jaspersoft csk –userName <superuser> password <superuser> upgrade-retryCount 50 force

This will update the ppmjasperadmin user and also update the DataSource (Beans) user information to the DWH and CA PPM.

Environment

Release:
Component: PPMENV

Resolution

Please Update This Required Field