CA PPM: Time Slice data not being generated

Document ID : KB000022501
Last Modified Date : 07/06/2018
Show Technical Document Details
Issue:

We are having one or more of the following issues:

-Time Slice data is missing, deficient, discrepant in the reports/portlets/UI.
-The Administration > Data Adminstration > Time Slices page has expiration dates that have not rolled over to the next period.
-The Administration > Data Adminstration > Time Slices page has DWH time slices where the expiration dates that have not rolled over to the next period.

Cause:

When there is a need to reslice, it means that the Time Slicing job was interrupted at some point.

Often times, there will be an entry in the BG-ca logs indicating the error.

 

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 regenerated.

Method 1 - Reslice from the UI (Soft Reslice Method)

1. From the UI > Jobs > Scheduled page
Pause the Time Slicing job, only when it is the WAITING or SCHEDULED state.
If it is in PROCESSING mode, please make sure the current instance completes.
If it did is not completing, please open a case.

2. Reslice the data item in question:
Go to Administration > Data Administration > Time slices > click on the time slice ID
a. Modify the "Number of Periods" to the desired number of periods.
Click Submit.

b. Run an immediate Time Slicing job instance and let it complete.
c. Validate the data has been regenerated.

If issue still occurs, please open a case.

Method 2 - Reslice via direct database update (Hard Reslice Method)

Please contact CA Support for an approved SQL statement.

3. Review jobs that can conflict with each other set them as incompatible via Administration > Data Administration > Reports and Jobs

Additional Information:

DWH Time Slice configuration
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.

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

5. Run the Time Slicing job