Cannot work with 'Advanced Reporting' after environment refresh

Products

• Clarity PPM On Premise

Issue/Introduction

• PPM, DWH and Jaspersoft DBs are refreshed from Production to a non-production system
• It is noticed that after this, the 'Create and Update Jaspersoft Users' job fails
• All the 'admin' commands related to Jaspersoft also fail
• The keystore is generated newly and placed in the Jaspersoft Tomcat. But this does not resolve the issue
• The following error is visible in the jasperserver.log:
  2025-01-29T06:07:30,067 ERROR SqlExceptionHelper,main:131 [] - The SELECT permission was denied on the object 'JIResourceFolder', database 'ppm_jaspersoft', schema 'dbo'.

Cause

Permissions not properly provided in the Jaspersoft DB after the refresh.

Resolution

Apply permissions as before. The documentation can be consulted to, to determine the recommended privileges.