Automic Workload Automation

  • Private Community

  • 1.  Help recalculating calendar

    Posted Apr 27, 2017 05:21 PM

    I recently added a keyword to our main calendar. After I saved the calendar, a bunch of other keywords went red and when I hover over them it says "The Calendar has not yet been (re)calculated." None of the keywords have a validity date range so I'm not sure what is hanging up the recalculation. Is there a way to manually recalculate the calendar?



  • 2.  Help recalculating calendar

    Posted Apr 27, 2017 05:26 PM
    The act of clicking "Save" after a modification is what causes the calendar to recalculate.  But the recalculation process can take some time, depending upon various factors.  I wonder if maybe it just wasn't done calculating yet?


  • 3.  Help recalculating calendar

    Posted Apr 27, 2017 05:31 PM
    I added the keyword a couple hours ago and it was still showing as having to recalculate when I last checked a couple minutes ago. It shouldn't take that long to recalculate should it?


  • 4.  Help recalculating calendar

    Posted Apr 27, 2017 05:34 PM
    Nope.


  • 5.  Help recalculating calendar



  • 6.  Help recalculating calendar

    Posted Apr 27, 2017 05:47 PM
    And just in case it is a validity period issue, here is a database query that finds all calendar keywords with a validity date less than 12/31/2017;

    select OH_Client, OH_Name as 'Calendar', OKB_Name as 'keyword', OKB_ValidTo as 'Valid until'
    FROM OH, OKB
    WHERE OH_Idnr=OKB_OH_idnr
    AND OKB_ValidTo < '2017-12-31 23:59:59:999'
    order by 1, 2, 3;


  • 7.  Help recalculating calendar

    Posted Apr 27, 2017 05:56 PM
    Thank you for the query. I was able to track down a single keyword with it that had a validity period that ended in 2015 that wasn't being used by anything. We removed that keyword and saved the calendar and all the keywords recalculated with no issues.


  • 8.  Help recalculating calendar

    Posted Apr 27, 2017 06:02 PM
    Yea, those validity periods can sit and hide for years and not bite you until the next time you need to recalculate.  Glad I could help!