The Jaspersoft Report(Missing Time) is not accurate.

Document ID : KB000047682
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

The Jaspersoft Report(Missing Time) is not accurate.
The Data Warehouse DWH does not display time entry hours in adhoc view/reports.

Cause:
The time slicing job did not fully process the time slice id DAILYRESOURCETIMECURVE

Resolution:

1. Go to Administration > Data Administration > Time Slices >
a. Check time slice id = 55555 DAILYRESOURCEAVAILCURVE is withing range.
b. Check time slice id = 1 DAILYRESOURCEAVAILCURVE is within range.

If not, reslice it by modifying the following fields.
a. Set "Number of Periods" to be the desired number of periods.
b. Clear out the "Expiration Date"
c. click Submit.

2. Run the following sequence of jobs:
a. Time Slicing job.
b. Update Report Tables job with all parameters checkmarked
c. Load Datawarehouse job with "Full" parameter checkmarked 

3. Validate the data is in PPM schema:

select * from PRJ_BLB_SLICES where slice_request_id in (55555)

4. Validate the data is in the DWH schema:

select * from DWH_TME_SHEET
select * from DWH_TME_ENTRY

Additional Information:
CLRT-81328