search cancel

UC_HOLIDAYS Calendars not calculated anymore after 31/12/2022

book

Article ID: 258173

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

After 31/12/2022 the Holiday Calendars that were delivered with the initial data are no longer calculated for year 2023 and later.

As the validity for calendar is not calculated, Tasks would be in status "FAULT_OTHER - Start Impossible" due to the miscalculation of the Calendar Event.

This would happen for all default Holiday calendars UC_HOLIDAYS.* from Client 0.

All systems running before 31.12.2022 should have recalculated the Calendar on year change.

Investigation:

To check Calendars validity, the following query can be used:

select min(Okb_validto), oh_name from okb, oh 
where OKB_OH_Idnr = oh_idnr and okb_oh_idnr < 100000 and oh_deleteflag = 0 group by oh_name order by 1 asc;

For the column OKB_ValidTo there should not be entries before 2023(time of the creation of this Article) and should be in the future e.g. 2026

Environment

Release : 12.x and 21.x

Component: Automation Engine

Functional Area: Calendars and Calendars Keywords

Cause

Defect: since October 2016 all Automation Engine versions would contain an Initial Data with Calendars having as End of Valid Date set to 31/12/2022

This could be seen with this line in the XML export of the Holiday Calendars:

<OKB_VALIDTO>2022-12-31 00:00:00.0</OKB_VALIDTO>

Resolution

Workaround:

Update the impacted Calendar/s by adding/removing an Event so that the Calendar validity is recalculated.

Solution:

Update to a fix version listed below or a newer version if available.

Fix version:
Component(s): Automation Engine
Will be fixed in Automation.Engine 21.0.5 - Planned release Second Half February 2023

Additional Information

Solution Details:

An issue has been fixed where the holidays were not calculated in the future, the calculation end time was 2022.

New Validity Date has been set to 2032-12-31 and will be updated accordingly during future builds.