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
Time slicing job crashed recently while processing and the job did not pick up correctly.
Need to repopulate the DAILYRESOURCEAVAILCURVE data with calendar data
Please follow these steps to repopulate the DAILYRESOURCEAVAILCURVE slice with the current resource calendar data