Load DWH Job Fails - error "ppmjasperadmin" not found


Article ID: 4883


Updated On:


Clarity PPM On Premise


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


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


Clarity 14.2 and above


  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.