DAILYRESOURCEAVAILCURVE slice missing data

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are looking at resource availability through a custom query-based portlet but we are seeing odd results.
We are looking to the DAILYRESOURCEAVAILCURVE slice (slice id 1)
The query returns values like 0 and 8 for most resources and calendars.
On some though, the value returned is NULL for the current years, but shows data for the year 2026
How can it be the slice does not contain any data for current year but shows data for future ones?
Should the slice not have availability data for the current periods as those resources are currently working on the system and are part of current investments?

The query we are using is similar to the one published on the KB below:
Resource calendars: working and non-working days

Cause

Time slicing job crashed recently while processing and the job did not pick up correctly.

Resolution

Need to repopulate the DAILYRESOURCEAVAILCURVE data with calendar data

Please follow these steps to repopulate the DAILYRESOURCEAVAILCURVE slice with the current resource calendar data

1. Run the following update:
   UPDATE prcalendar
   SET    slice_status = '1'
2. Run the Time slicing job
3. Run the following update:
   UPDATE prj_resources
   SET    slice_status = '1'
4. Run the Time slicing job
5. Run the Datamart Extraction job
6. Run the Datamart roll up job