A technical UC4 Fan Blog
The end of the year is approaching, and many offices are almost deserted in this supposedly contemplative time. Just at this time of the year, there are some special tasks, such as the annual financial statements and the holiday shopping season. If you are one of the chosen ones who must hold the fort, then this article should help save you from a small misfortune that might occur at the end of the year: The end of the calendar ... I mean a UC4 calendar, of course.
CALE validity period
Actually, Calendars don't end in UC4, but are valid some time back and forwards as defined by the keywords "NOW_MINUS" and "NOW_PLUS" in the UC4 variable UC_CLIENT_SETTINGS.
Only static Calendar Keywords and Keywords that depend on static ones have a fixed validity period and will expire if you don't adjust them in time.
Although one usually requires few or no static calendar definitions, most holiday Calendars in client 0 include at least one static entry, and if you haven't applied a hotfix for some time, your holiday Calendar might expire on 31.12.2011.
UC4 offers the possibility of automatic notification n days before a Calendar Keyword expires. The configuration of this feature is also in the UC4 variable UC_CLIENT_SETTINGS:
Check when Calendar Keywords expire
This little SQL provides a list of all calendar terms, sorted by expiration date, and is intended to avoid unpleasant End-Of-Year surprises:
a.OKB_OH_IDNR = b.OH_IDNR
and b.OH_DELETEFLAG = 0
and b.OH_CLIENT != 0
I wish you a Merry Christmas and a Happy New Year!
Welcome to my UC4-Tech-Blog
Here you can find technical articles on UC4 Operations Manager
(versions 6.00 and 8.00) and the UC4 Auomation Engine (version 9.00). I describe automation approaches, helpful SQL queries, and experiences with administration of a UC4 OM system and its components.
I hope you find interesting articles, and I'm looking forward to your comments.
One last small note:
I have no direct connection to UC4 or the UC4 Software GmbH other than being a User of their software. The official, non-technical UC4-Blog can be found at http://www.uc4.com/blog
Name: Philipp Elmer
UC4-User since: Summer 2006
I'm a freelancer and started in December 2000 as a Unix operator. My job always included some form of batch-processing, process-automation and scheduling.
Before working with UC4, I already scheduled with cron ;-) , Maestro and Control-M.