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

CA PPM 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 : 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

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

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