Time Slice Data Not Generated

book

Article ID: 22501

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We are having one or more of the following issues:

  1. Time Slice data is missing, deficient, discrepant have not updated in the reports/portlets/UI.
  2. The Administration > Data Administration > Time Slices page has expiration dates that have not rolled over to the next period.
  3. The Administration > Data Administration > Time Slices page has DWH time slices where the expiration dates that have not rolled over to the next period.
  4. How can the time slices be resliced to include a broader or specific date range?
  5. Jaspersoft Reports are missing time reporting periods

Cause

The Time Slicing job was interrupted and/or the BG log indicates an error caused by environmental factors beyond the control of the Clarity application/administrator such as database contention/outages/connection issues.

 

Resolution

The following methods will force a reslice, which will be force the Time Slicing job to regenerate data items. No data is ever deleted, but rather, is regenerated.

  1. Go to Administration > Data Administration > Time slices > click on the time slice ID to be resliced.
    • Enter the "From Date" which is the start date of when data needs to start from.
    • Enter the "Number of Periods" to satisfy the requested date range.
    • Click Submit.
  2. Run an immediate Time Slicing job instance and let it complete.
  3. Validate the data has been regenerated.

For Jaspersoft reports to be updated, make sure the following jobs are completed also:

  • Update Report Tables (all parameters)
  • Load Data Warehouse (full)
  • Load Data Warehouse Access Rights

Here is the best practice for setting up the time slices to coincide with the fiscal time periods.

A. Set up the fiscal time slices

  1. Pause the Time Slicing job
  2. Go to Administration > Data Administration  > Time Slices
  3. Sort by column "Slice Period" and review the 'Fiscal' types.
  • For each Fiscal type (there are 13), right-click the slice name and open it in a new tab.
  • Set the From Date, Number of Periods(in Months). This is to be provided by the business or by the Support team.

    Best Practice:
    The 'Number of Periods' should be set to 72 months.

b. Clear out the Expiration Date.
c. Click Save and Return.

Do this for the remaining slices. Note that the 'Last Run Date' will be blank, which indicates it is yet to be processed by the Time Slicing job.

B. Set up the fiscal time periods.

Note: The entity must have Monthly (or 13 period) fiscal time periods set up to cover the time range of the time slice requests.
Otherwise, the time slice requests are ignored when the Time Slicing job runs and will appear blank.

To create and activate additional fiscal time periods
1. Go to Admin > Finance > Setup > Entities >

2. select entity > Fiscal Time Periods

3. Click New and create the following monthly fiscal time periods
Example:
a. JAN 1 2021 to DEC 31 2021
b. JAN 1 2022 to DEC 31 2022

4. Select the created fiscal time periods and
go to the top right-hand side of the page, click Action > Activate

C. Unpause the Time Slicing job and let it complete.

D. Run the required jobs to ensure data is available for portlets and Jaspersoft Reports.
1. Datamart Extraction
2. Update Report Tables - all parameters checkmarked
3. Load DWH - with Full parameter checkmarked

Additional Information

Best Practices to Prevent Issue with Time Slicing job failure.
1. Do not restart BG services whilst the Time Slicing job is running / processing.
2. Set jobs that XOG data in to be incompatible with the Time Slicing job from Administration > Data Administration > Reports and Jobs > select Time Slicing job > Incompatible tab
3. Run the Time Slicing job to run every 5 minutes, instead of every minute.

 

Note: If the above does not help and/or other jobs are impacted see 49034 - Clarity Scheduled Jobs Do Not Get Processed by the Job Scheduler (BG Service Issue)