search cancel

Jaspersoft Content import fails with error "Error in getting permission..." with Oracle in Clarity

book

Article ID: 188751

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Post upgrade of Clarity, trying to upgrade Jaspersoft by running the command below fails with the below errors:

admin content-jaspersoft csk -userName superuser -password xxx upgrade

6/4/20 15:57 (admin) Content File Name  jaspersoft_csk.zip
6/4/20 15:57 (admin) Logging into server ... http://Jaspersoftserver:8080/reportservice
6/4/20 15:57 (admin) Getting tenant information... clarity
6/4/20 15:57 (admin) Initiating importing on clarity with file name jaspersoft_csk.zip
6/4/20 15:57 (admin) Preparing content to be deployed on  clarity using file D:\niku\clarity\reporting\content\csk\jaspersoft\package\jaspersoft_csk.zip
6/4/20 15:58 (admin) Importing prepared content...C:\Users\AppData\Local\Temp\7\jaasreports_18402068423393020898\export_8064332808795779695.zip
6/4/20 15:58 (admin) Getting effective permissions using extracted zip: C:\Users\AppData\Local\Temp\7\export-16877894034287361787
6/4/20 15:58 (admin) Importing....
6/4/20 15:58 (admin) Importing....
6/4/20 15:58 (admin) Importing....
6/4/20 15:58 (admin) Importing....
6/4/20 15:58 (admin) Importing....
6/4/20 15:59 (admin) Importing....
6/4/20 15:59 (admin) Importing....
6/4/20 15:59 (admin) Content imported
6/4/20 15:59 (admin) Restoring effective permissions
6/4/20 15:59 (admin) Updating Domains to have correct schema name... 
6/4/20 15:59 (admin) Processing domain...Application Management
6/4/20 15:59 (admin) Processing domain...Custom Master Objects
6/4/20 15:59 (admin) Processing domain...Financial Management
6/4/20 15:59 (admin) Processing domain...Idea Management
6/4/20 15:59 (admin) Processing domain...Investment Management
6/4/20 15:59 (admin) Processing domain...Project Management
6/4/20 15:59 (admin) Processing domain...Resource Management
6/4/20 15:59 (admin) Processing domain...Time Management
6/4/20 15:59 (admin) Updating Domains to have customizations... 
6/4/20 15:59 (admin) Updating Dynamic attributes..
6/4/20 16:00 (admin) Importing themes..
6/4/20 16:00 (admin) Preparing content to be deployed on  clarity using file D:\niku\clarity\reporting\content\csk\jaspersoft\package\jaspersoft_themes.zip
6/4/20 16:00 (admin) Importing prepared content...C:\Users\AppData\Local\Temp\7\jaasreports_9265956597779503157\export_9486623694872177117.zip
6/4/20 16:00 (admin) Importing....
6/4/20 16:00 (admin) Content imported
6/4/20 16:00 (admin) Error in getting permission
Error in getting permission: Resource /public/adhoc;role:/ROLE_REPORT_DESIGNER not found.
Error in getting permission: Resource /public/adhoc;role:/ROLE_ADMINISTRATOR not found.
Error in getting permission: Resource /public/audit;role:/ROLE_REPORT_DESIGNER not found.
Error in getting permission: Resource /public/audit;role:/ROLE_ADMINISTRATOR not found.
Error in getting permission: Resource /public/diagnostic;role:/ROLE_REPORT_DESIGNER not found.
Error in getting permission: Resource /public/monitoring;role:/ROLE_REPORT_DESIGNER not found.
Error in getting permission: Resource /public/templates;role:/ROLE_REPORT_DESIGNER not found.
Error in getting permission: Resource /public;role:/ROLE_REPORT_DESIGNER not found.

Cause

This error comes when your JDBC URL in CSA is not set up correctly as needed. 

Environment

Release : All Supported

Database: Oracle

Resolution

  1. Stop all the Clarity services
  2. Login to CSA and update the JDBC url using the below syntax as an example for Oracle database

    Oracle Standard/Enterprise Database -

    jdbc:clarity:oracle://xxx.broadcom.net:1521;SID=clarity;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;ConnectionRetryCount=400;ConnectionRetryDelay=3



    Oracle RAC/Exadata/PDB  Database Edition

    jdbc:clarity:oracle://server:1521;ServiceName=serviceTNS;BatchPerformanceWorkaround=true; InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true;

  3. Re-import the Jaspersoft content again using the below command

    admin content-jaspersoft csk -userName superuser -password superuser upgrade -retryCount 50 force