CA PPM Load Data warehouse Job Fails with error "ppmjasperadmin" not found

Document ID : KB000004883
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

CA PPM Load Data warehouse Job Fails with error "ppmjasperadmin" not found 

Environment:
CA PPM 14.2 and above
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 : bg@lxcapsclarprd01.lowes.com (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 : bg@lxcapsclarprd01.lowes.com (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 : bg@lxcapsclarprd01.lowes.com (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

Resolution:
  1. Login to PPM 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 List of Jaspersoft Commands in accordance with CA PPM Version

 

 

Additional Information:

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