Hi Patricio.
We've found the same error in 15.3. Still unsolved.
But we believe is caused by a product defect.
We activated the User's Action tracing, in the Administration > Resources > user properties
Then, we navigated to the Status Report to capture the error in the trace file <CAPPMFOLDER>\logs\app-trace.xml
As a result, we found the following SQL Query in the xml trace file:
SELECT 'week_start_date', COUNT(1) invalid FROM (SELECT day(s.from_date) slice_start_day,wd.start_day ppm_start_day FROM prj_blb_slicerequests s,
(SELECT prWeekStart + 1 start_day FROM prSite) wd WHERE s.period = 1 AND s.is_dwh_request = 1
AND day(s.from_date) != day(wd.start_day)) weekstartdate
If you analize carefully the query, you can find a inconsistence among the values being compared.
For example, if the slice start date is "April 09th 2018", the resulting weekday should be 2 (Monday), but the query shows a 9 (the day of the month).
We are working with CA Support on this.
Please verifiy if you are experimenting the same situation.
Best regards
Juan
Original Message:
Sent: 09-17-2018 11:58 AM
From: Patricio Bermudez
Subject: Health Report error for Timeslice Setup for Week Start Dates
Hello,
I contact with the community because we need to apply the upgrade as soon as, but we found an error in the Health Report related with the Timeslice Setup for Week Start Dates.
We validate the configuration in the environment and we think that is fine. If someone can help me it would be great.
Best regards.
Patricio.