Load DWH Job Fails - error "ppmjasperadmin" not found

book

Article ID: 4883

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Clarity Load Data warehouse Job Fails with error "ppmjasperadmin" not found 

Cause

When you get this error, please take a look at BG-DWH log and if you see below

 

ERROR 2016-12-08 15:36:05,993 [Dispatch pool-5-thread-7 : [email protected] (tenant=clarity)] jaspersoft.ClarityJasperAdmin (clarity:tnunes:9044398363__8A0F835E-99D7-49B1-8026-2023CAADA97B:Load Data Warehouse (Incremental)) Could not login to http://Jasper:8080/reportservice with username ppmjasperadmin

ERROR 2016-12-08 15:36:05,993 [Dispatch pool-5-thread-7 : [email protected] (tenant=clarity)] kettle.DataWareHouseKettleJob (clarity:tnunes:9044398363__8A0F835E-99D7-49B1-8026-2023CAADA97B:Load Data Warehouse (Incremental)) Could not login to Jaspersoft, domains could not get updated for customizations

ERROR 2016-12-08 15:36:06,002 [Dispatch pool-5-thread-7 : [email protected] (tenant=clarity)] niku.njs (clarity:tnunes:9044398363__8A0F835E-99D7-49B1-8026-2023CAADA97B:Load Data Warehouse (Incremental)) Error executing job: 5462005

com.ca.jasper.restAdapter.JasperException: User Id not found

at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.createJasperHeaders(ClarityJasperAdmin.java:282)

at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.login(ClarityJasperAdmin.java:208)

at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.createInstance(ClarityJasperAdmin.java:139)

at com.ca.clarity.etl.kettle.DataWareHouseKettleJob.executeETLJob(DataWareHouseKettleJob.java:80)

at com.ca.clarity.njs.listeners.ETLJobListener.scheduledEventFired(ETLJobListener.java:31)

at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

 

There is a error "User Id not found" which says ppmjasperadmin is not there in Jaspersoft server. This can happen when the user in CA PPM "ppmjasperadmin" is either changed to something else and when the Jaspersoft content was imported it failed and did not create "ppmjasperadmin" in Jaspersoft

Environment

Clarity 14.2 and above

Resolution

  1. Login to Clarity and check inactive resources.
  2. Look for "ppmjasperadmin" and ensure userName and ResourceId is "ppmjasperadmin"
  3. Run the command admin jaspersoft syncPPMContext -userName superuser -password superuser as this will create the user. Detailed information can be found in Jaspersoft Commands in accordance with Clarity Version

Note: If you are 14.2 then the command will not work, you need to delete the repository in Jaspersoft and reimport the content.