search cancel

Health Report Summary Shows DWH Status as Red X Incomplete

book

Article ID: 200388

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Navigating to Administration > Security and Diagnostics > Health Report > Summary > Data Warehouse,
the Status shows a Red X.

There is a Fix It link, however it only takes it to the Administration > Data Administration > Time Slices page but does not autocorrect the issue.

 

Environment

Release : 15.8.1

Component : CA PPM SAAS TIME SLICING

Cause

The time slice IDs in question do not all uniformly start on the designated first day of the work week set in Administration > Project Management > Settings
AND
have the same number of periods.

Resolution

When setting up the DWH time slices from the
Administration > Data Administration > Time Slices page, ensure that the start date
AND the day of the week that matches that of the Administration > Project Management > Settings > General > First Day of Work Week
AND have the same number of periods

1. Use the following queries to quickly find out what the days are set to:
--a
select sr.id, sr.request_name, SR.FROM_DATE, SR.PERIOD, sr.num_periods
from PRJ_BLB_SLICEREQUESTS SR
where SR.IS_DWH_REQUEST = 1
and  SR.PERIOD = <xxxx> --where xxxxx designates the period type
   order by SR.id

The field 'Period' is designated as follows:
0 = daily
1 = week
3 = month

--b
select prweekstart from PRSITE
0 - Sunday
1 - Monday
2 - Tuesday
3 - Wednesday
4 - Thursday
5 - Friday
6 - Saturday

2. Reslice the DWH slice request to start on a day consistent with the First Day of Work Week set in Administration > Project Management > Settings

Go to Administration > Data Administration > Time Slices page
Modify all the Weekly DWH time slice IDs to conform to the First Day of Work Week day:
Sort all the weekly DWH time slices by ID.
Open each ID link in a new browser tab.
Set the From Date to match the 'First Day of Work Week'

Additional Information

Monthly Slices that need to start on the same day/date and have the same number of periods.

4 MONTHLYRESOURCEACTCURVE
5 MONTHLYRESOURCEESTCURVE
6 MONTHLYRESOURCEALLOCCURVE
7 MONTHLYRESOURCEAVAILCURVE
305 MONTHLYBASEASSIGNCOSTS
312 MONTHLYRESOURCEBASECURVE
1000007 MONTHLYRESOURCEHARDALLOC
1000008 assignment::etccost_curve::dwh_month
1000010 baseline::current_team_usage::dwh_month
1000011 baseline::current_team_cost::dwh_month
1000012 team::hardallccost_curve::dwh_month
1000013 assignment::actcost_curve::dwh_month
1000014 team::alloccost_curve::dwh_month

Attachments