"Resource Assignments by Task” report incomplete

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The "Resource Assignments by Task” report is not returning the expected results based on the project/task level results found on the Project / Tasks – Assignments portlet.

The same few records are missing at all times from the report.

Running the report query against the DB provides the same results that the report displays.

What can cause the report not to be complete?

Cause

The "Update Earned Value and Cost Totals" was simultaneously running with the Load DWH job

Resolution

Set the "Update Earned Value and Cost Totals" incompatible with the Load DWH job

OR

Change the job schedules so these jobs do not collide in execution