JWP generates forced trace during Telemetry Data collection routine at 01:00 AM everyday

Products

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

Issue/Introduction

During the Telemetry data collection routine which occurs every night at 01:00 AM - We can see the JWP's creating forced traces.

The issue has been identified with Customers running

1) Oracle database 

Below can be seen in the JWP log file:

U00045276 Collect telemetry data now.

U00003590 UCUDB - DB error: '22008', 'ORA-01861: literal does not match format string ', '1861', 'java.sql.SQLDataException'

U00003620 Routine 'com.automic.kernel.impl.DBAction' forces trace because of error.

 ----------------------- Stack Trace -----------------------

 Caused by: java.sql.SQLDataException: ORA-01861: literal does not match format string

 

 2) MSSQL DB with German 

Below can be seen in the JWP log file:

U00045276 Telemetriedaten werden jetzt gesammelt.

U00003590 UCUDB - DB-Fehler: 'S0003', 'Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.', '242', 'com.microsoft.sqlserver.jdbc.SQLServerException'

U00003620 Routine 'com.automic.kernel.impl.DBAction' erzwingt Trace wegen Fehler.

 ----------------------- Stack Trace -----------------------

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

 

Environment

Release : 21.0.5

                 21.0.5 HF1

Component: Automation Engine

Functional Area: Telemetry Data Collection

Cause

The issue has been confirmed to be a bug by our Dev team.

 

Resolution

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

Fix version:

Components: AutomationEngine

Fixed Versions: Automation.Engine 21.0.5 HF2 (Release date: 2023-03-28)