The Load Data warehouse (DWH) Job Fails indicating the "ppmjasperadmin" user is not found
When you get this error, checking in the BG-DWH log you see the below:
ERROR 2016-12-08 15:36:05,993 [Dispatch pool-5-thread-7 : bg (tenant=clarity)] jaspersoft.ClarityJasperAdmin (clarity:admin: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(tenant=clarity)] kettle.DataWareHouseKettleJob (clarity:admin: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 (tenant=clarity)] niku.njs (clarity:admin: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)
Error "User Id not found" means that the ppmjasperadmin user is not in the Jaspersoft server. This can happen due to the following:
Clarity 14.2 and above
Note: If you are on 14.2 then the command will not work, you need to delete the repository in Jaspersoft and reimport the content.