Non Java based CP/WP processes end abnormally after reconnecting to a Oracle database

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Non Java based CP/WP processes end abnormally after reconnecting to a Oracle database.

Normal error captured from the TNS listener when the database is not available:
20260204/214801.076 - U00003592 UCUDB - Status: '' Native error: '12514' Msg: 'ORA-12514: TNS:listener does not currently know of service requested in connect descriptor'
20260204/214812.077 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'CMIT' time: '11:006.619.000'
20260204/214812.077 - U00003603 Program error: Client is not correctly supplied when calling ZULOGG.
20260204/214812.077 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.

Reconnection to database is successful after database becomes available again:
20260204/214812.078 - U00003537 UCUDB - RECONNECT: DB call 'OCITransRollback': Return code: '-1'.
20260204/214812.078 - U00003593 UCUDB PGE: error at SQL error Ref '-1'
20260204/214812.173 - U00003538 UCUDB: Re-connection to database successful. Processing will continue.
20260204/214812.173 - U00029110 UCUDB - Session parameters:
20260204/214812.198 - U00003535 DB INFO: 'NLS_LANGUAGE                   = AMERICAN'
20260204/214812.198 - U00003535 DB INFO: 'NLS_TERRITORY                  = AMERICA'
20260204/214812.198 - U00003535 DB INFO: 'NLS_CURRENCY                   = $'
20260204/214812.198 - U00003535 DB INFO: 'NLS_ISO_CURRENCY               = AMERICA'
20260204/214812.198 - U00003535 DB INFO: 'NLS_NUMERIC_CHARACTERS         = .,'
20260204/214812.198 - U00003535 DB INFO: 'NLS_CALENDAR                   = GREGORIAN'
20260204/214812.198 - U00003535 DB INFO: 'NLS_DATE_FORMAT                = DD-MON-RR'
20260204/214812.198 - U00003535 DB INFO: 'NLS_DATE_LANGUAGE              = AMERICAN'
20260204/214812.198 - U00003535 DB INFO: 'NLS_SORT                       = BINARY'
20260204/214812.198 - U00003535 DB INFO: 'NLS_TIME_FORMAT                = HH.MI.SSXFF AM'
20260204/214812.198 - U00003535 DB INFO: 'NLS_TIMESTAMP_FORMAT           = DD-MON-RR HH.MI.SSXFF AM'
20260204/214812.198 - U00003535 DB INFO: 'NLS_TIME_TZ_FORMAT             = HH.MI.SSXFF AM TZR'
20260204/214812.198 - U00003535 DB INFO: 'NLS_TIMESTAMP_TZ_FORMAT        = DD-MON-RR HH.MI.SSXFF AM TZR'
20260204/214812.198 - U00003535 DB INFO: 'NLS_DUAL_CURRENCY              = $'
20260204/214812.198 - U00003535 DB INFO: 'NLS_COMP                       = BINARY'
20260204/214812.198 - U00003535 DB INFO: 'NLS_LENGTH_SEMANTICS           = BYTE'
20260204/214812.198 - U00003535 DB INFO: 'NLS_NCHAR_CONV_EXCP            = FALSE'
20260204/214812.198 - U00003535 DB INFO: 'SID                            = 140'

Process gets terminated:
20260204/214812.211 - U00011816 Server 'AUTOMIC#WP002': Termination initiated.

And ultimately ends:
20260204/214812.366 - U00003410 Server 'AUTOMIC#WP002' version '24.4.3+build.1765543096850' ended abnormally.

Environment

Database: Oracle
Automation Engine version: 24.4.3+build.1765543096850

Cause

DE182215

Resolution

Workaround:

The CP/WP processes that stopped will need to be manually restarted

Solution:

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

Fix version:
Component(s): Automation Engine

Automation.Engine 24.4.4 - Available

Additional Information

Public Title: WPs terminate abnormally after reconnecting to the Oracle database.

Public Description: A problem has been fixed where WPs would terminate abnormally after reconnecting to the Oracle database.