Clarity

  • 1.  Health Report error for Timeslice Setup for Week Start Dates

    Posted Sep 17, 2018 11:59 AM

    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.



  • 2.  Re: Health Report error for Timeslice Setup for Week Start Dates

    Broadcom Employee
    Posted Sep 18, 2018 06:40 PM


  • 3.  RE: Health Report error for Timeslice Setup for Week Start Dates

    Posted Jun 26, 2019 03:22 PM
    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




  • 4.  RE: Health Report error for Timeslice Setup for Week Start Dates
    Best Answer

    Broadcom Employee
    Posted Jun 27, 2019 09:16 AM
    Did you also check this post?

    https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=748407#bmb3a1475e-986e-441b-8ce6-2c63e37e568a

    For the weekly slices all of them need to start on the same day and be the same weekday as the first day of your week in Project Management Settings.

    Note that in later versions you do not need to run Update Report Tables job as it is included in the Load DW job.

    Liz