Create and Update Japsersoft Users jobs fail after DB refresh

book

Article ID: 224684

calendar_today

Updated On:

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

Cause

Organization ID mismatch in Clarity CSA

Environment

Clarity PPM 15.9.3 and Jaspersoft 7.8

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

 

 

Attachments