For those who may not be aware.
Dear Broadcom Customer,
The purpose of this Critical Alert is to inform you of a potential problem that has been recently identified with Automic Automation. Please read the information provided below and follow the instructions in order to avoid being impacted by this problem.
PRODUCT(S) AFFECTED: Automic Automation RELEASE: V12.2 and V12.3
PROBLEM DESCRIPTION:
The Jobs or Workflows running as recurring (C_PERIOD) can fail on the last day of the month with FAULT_OTHER and stop executing. This may also cause an outage on the last day of the month or first day of the month due to long running time critical calls and a system loop.
SYMPTOMS:
Sometimes, the last Report will end on the before last day of the month with the following error: U01001200 **** input timestamp.
It is possible variants of this scenario with from and to times going across midnight without any skipped days can also cause a system loop. When this happens the following may be seen:
There will be very long running time critical database calls on the statement:
select * from eh where eh_ah_idnr = ?
Sometimes this is accompanied by a message from Oracle:
U00003592 UCUDB - Status: '' Native error: '1555' Msg: 'ORA-01555: snapshot too old: rollback segment number 1 with name "snapshot_name" too small'
as well as locking on the db
When the blocking session is killed the system appears to recover.
IMPACT:
Job scheduling stops, causing an outage.
RESTORATION OF SERVICE:
When the blocking session is killed the system appears to recover.
PROBLEM RESOLUTION:
Update to a fix version listed below or a newer release.
Fix versions for Component: Automation Engine
Automation.Engine 12.3.5 HF4 - available
Automation.Engine 12.3.6 - available
Automation.Engine 12.2.10+HF2 - available