Load DWH job fails - error "User Id not found" with username "ppmjasperadmin"

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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)

Cause

Error "User Id not found" means that the ppmjasperadmin user is not in the Jaspersoft server. This can happen due to the following:

• The user in Clarity "ppmjasperadmin" is changed to something else
• 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 on 14.2 then the command will not work, you need to delete the repository in Jaspersoft and reimport the content. 

Additional Information

Reference also:

• Load DWH job failures - troubleshooting
• Data Warehouse (DWH) known issues
• Load DWH Full - When to run to prevent failures