Some UC_HOLIDAYS.X keywords have 2022 expiration in 12.3 and pre-21.0.5

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

Some default calendars for 12.3.9 HF2 and 21.0.0 through 21.0.4 contain keywords in client 0 that expire 2022-12-31.  
The same keywords in some systems that were installed before 2022-12-31 or are 21.0.5 and later expire in 2029-12-31
Steps to check:
Run the following on a system that was installed before 2022-12-31 db:
mssql: select OH_Client, OH_Name, OKB_Name, OKB_ValidTo FROM OH, OKB WHERE OH_Idnr=OKB_OH_idnr AND OKB_ValidTo < getdate() AND OH_Client in (0) and oh_deleteflag = 0
oracle: select OH_Client, OH_Name, OKB_Name, OKB_ValidTo FROM OH, OKB WHERE OH_Idnr=OKB_OH_idnr AND OKB_ValidTo < sysdate AND OH_Client in (0) and oh_deleteflag = 0

Result: no keywords returned
Run the same on 21.0.5
Result: no keywords returned

Run the same on 12.3.9 HF2 and systems pre-21.0.5
Result: Around 65 keywords are returned.  Most are UC_HOLIDAYS.* with keyword EASTER and TOTAL.  UC_MONTH/ALL is also returned with a okb_validto of 2022-12-31

Environment

Release : 12.3.9

Cause

Some calendar keywords were set to expire in 2022 before 21.0.5.  These would automatically update at the year change on 31 December; but if the systems were installed in 2023, it won't update until 31 December 2023

Resolution

The solution is to update to the version 21.0.5 or use an export from a previous version.

Attached to this article are three .xml exports from 12.3.9 which can be imported into a system that was installed after 2022-12-31.  They have a validity period with an end in 2029.