Create and Update Japsersoft Users job fails due to Organization ID mismatch

Products

• Clarity PPM On Premise

Issue/Introduction

Following a DB refresh on a lower clarity instance (PROD to NON-PROD) the "create and update jaspersoft users job" in clarity fails with the following error

Failed to get an instance of ClarityJasperAdmin :: Exception getting ClarityJasperAdmin : Could not login to https://clarityserver.com:8080/reportservice with username ppmjasperadmin

The admin command to synchronise clarity server with jaspersoft also fails -  admin jaspersoft syncPPMContext -userName superuser -password superuser

-bash-4.2$ ./admin_ssl jaspersoft syncPPMContext -userName superuser -password superuserSyncing PPM context to jaspersoft..User ppmjasperadmin not available in report server. Resource ppmjasperadmin not found. code:resource.not.found  parameter:["ppmjasperadmin"]Creating the missing ppm jasper admin user..User ppmjasperadmin not available in report server. Resource ppmjasperadmin not found. code:resource.not.found  parameter:["ppmjasperadmin"]Creation/updation process is started for PPM user ppmjasperadmin as ppmjasperadmin user in jasper serverUser ppmjasperadmin not available in report server. Resource ppmjasperadmin not found. code:resource.not.found  parameter:["ppmjasperadmin"]Creating the user ppmjasperadmin in report serverThe value "CSK_ROLE_ALL_REPORTS_DOMAINS" for parameter "ROLE_ADHOC_DESIGNER" is invalid. code:illegal.parameter.value.error  parameter:["ROLE_ADHOC_DESIGNER","CSK_ROLE_ALL_REPORTS_DOMAINS","CSK_ROLE_PROGRAM_MANAGEMENT","CSK_ROLE_FINANCIAL_MANAGEMENT","CSK_ROLE_APPLICATION_MANAGEMENT","ROLE_DATASOURCE_DESIGNER","CSK_ROLE_RESOURCE_MANAGEMENT","ROLE_REPORT_DESIGNER","ROLE_DOMAIN_DESIGNER","CSK_ROLE_INVESTMENT_MANAGEMENT","CSK_ROLE_PROJECT_MANAGEMENT","CSK_ROLE_ADMINISTRATION","ROLE_DASHBOARD_DESIGNER","CSK_ROLE_CUSTOM_MASTER_OBJECTS","CSK_ROLE_TIME_MANAGEMENT","CSK_ROLE_IDEA_MANAGEMENT"]Updating user profile attributes..Data Warehouse Bean DS URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=clarityserver.com)(PORT=1526))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=bbppmd)))PPM Bean DS URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=clarityserver.com)(PORT=1526))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=bbppmd)))Updating domain schema name..No Domains are available to update

Environment

Clarity PPM 15.9.3 and Jaspersoft 7.8

Cause

Organization ID mismatch in Clarity CSA

Resolution

If the organisation ID is different on non-production then the same needs to be updated in CSA post DB refresh. 

To update Organisation ID open CSA >  Reporting > Organization ID