An Adhoc report from the Resource Management domain that is reporting on Actuals posted is missing data at times. The data is there originally but after an Incremental Load Data Warehouse job run, the data is missing.
Steps to Recreate
- Create a project starting on 1/1/2020 and ending on 12/31/2021. Name it "Administration"
- Financial enable it and change its Financial status to open
- Create a task starting on 1/1/2020 and ending on 12/31/2021
- Staff the project
- Assign a resource to the task
- Post actuals in Oct/2020 for Amos (quantity=9)
- Run all required jobs (Post Transactions, Import Actuals, Investment Allocation)
- Run Load Data Warehouse full (note you have actuals for the resource in the Adhoc Report)
- Be prepared to update the task of the Administration project with a new assignment to the same task right after you start the Load Data Warehouse job as Incremental
- Start the load data warehouse as incremental
- Wait about 10 seconds and really quick assign another resource to the task
- Post a transaction in Dec/2020 for the new resource (quantity=10)
- When Incremental Load Data Warehouse completes view the Adhoc report for the actuals on the resource.
Expected Result - The new and previous data is included
Actual Result - The data is no longer there