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.

Environment

Release : All Supported

Database: Oracle

Cause

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

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