ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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.

 

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.

Environment

Release : 15.8.1

Component : CA PPM SAAS TIME SLICING

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