search cancel

WPs cannot be restarted after saving a Queue with Calendar Event Exception

book

Article ID: 213465

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

WPs cannot be started anymore (all WP stop) if a particular Calendar Event is added as Queue Exception.
Somehow, WP calculates a wrong date, ie 2021.04.31 00:00:00 for the OUA_NextCheck value which cannot be saved into the database generating the error "Invalid time format"


Errori in WP traces look like this:

20210408/131842.816 - U00009909 TRACE: (BINDPAR: OUA_OH_Idnr    )                     00007FFBA333A65C 000004
20210408/131842.816 -                    >1052214<
20210408/131842.816 - U00009909 TRACE: (BINDPAR: OVP_CaleName   )                     00007FFBAF35A91A 000008
                00000000 5245562E 434F4D4D          >REV.COMM<
20210408/131842.816 - U00009909 TRACE: (BINDPAR: OVP_CaleKeyName  )                     00007FFBAF35A9E3 000004
                00000000 42415345               >BASE<
...    
20210408/131842.816 - UCQERT(Next) - next check - local time - pPqert->ret_nextcheck='2021.04.31 00:00:00.000000'
...
20210408/131842.816 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20210408/131842.816 - U00003592 UCUDB - Status: '22007' Native error: '0' Msg: 'Invalid time format'
20210408/131842.816 - U00003594 UCUDB Ret: '3590' opcode: 'UPDT' SQL Stmnt: 'UPDATE OUA SET OUA_CurrPriority = ?,OUA_NextCheck = ? WHERE OUA_OH_Idnr = ?'
20210408/131842.816 - U00009909 TRACE: (BINDPAR: OUA_NextCheck   )                     00007FFBA333A674 000016
                00000000 5F2E31AF FB7F0000 F00E6D01 00000000 >_.1¯û...ð.m.....<
20210408/131842.816 -                    >11871.-20687.32763 00:3824:365.0<
20210408/131842.816 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20210408/131842.816 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR  ', '22007', 'Invalid time format'

Cause

This issue only affects queue exceptions, it was due to a correction introduced in 12.2.5/ 12.3.2 that caused this side-effect.

Environment

Versions affected: 12.2.5+, 12.3.2+

Component : AUTOMATION ENGINE

Resolution

Workaround:

Remove the Calendar Event Exception from the Queues (or delete the calendar event from the OVP entry),after doing so the WP will start correctly again.

Solution:

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

Fix version:
Component(s): Automation.Engine 

Automation.Engine 12.2.9 - Available
Automation.Engine 12.3.6 - Planned release in July 2021