Custom fiscal TSV does not show some of the periods data (empty/blank)

Products

• Clarity PPM On Premise

Issue/Introduction

We expect our custom TSV values to display in pan left and right within the defined period. They do not display for some of the periods. This is a fiscal custom TSV and the fiscal periods are covering the expected range.

Environment

Release : All supported Clarity releases

Component : CA PPM TIME SLICING

Resolution

When looking in PRJ_BLB_SLICEREQUESTS table we can see the slices for this custom TSV 'test':
(Example IDs and results)

5000013 test::test1::default

5000014 test::test1::segment

We need to correct only the 'segment slice' to ensure it covers the requested period. Use the following query, whilst correcting the from_date and ID to match your own records:

update prj_blb_slicerequests
set from_date ='2019-06-30 00:00:00',
expiration_date = null,
request_completed_date =null
where id =5000014;
commit

Wait until Time Slicing runs and updates expiration date and request_completed_date, then see if it things display correctly.

Additional Information

Note: do not increase the slice to cover too many years to avoid performance issues.