Work processes are generating trace files associated with the Oracle error 'ORA-01455: converting column overflows integer datatype.

Products

• CA Automic Workload Automation - Automation Engine
• Automic SaaS

Issue/Introduction

The work processes (WPs) constantly create forced traces with these messages:

U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 3f0cf740  DB-HDBC: 3f12c980
U00003591 UCUDB - DB error info: OPC: 'OCIStmtFetchx' Return code: 'ERROR'
U00003592 UCUDB - Status: '' Native error: '1455' Msg: 'ORA-01455: converting column overflows integer datatype'
U00003590 UCUDB - DB error: 'OCIStmtFetchx', 'ERROR   ', '', 'ORA-01455: converting column overflows integer datatype'
U00003620 Routine 'UCDS_R' forces trace because of error.
U00003590 UCUDB - DB error: 'OCIStmtFetchx', 'ERROR   ', '', 'ORA-01455: converting column overflows integer datatype'
U00003449 Output to the TRACE file is finished.
U00003100 Memory TRACE was opened with the switches '0000000000000000'.

Environment

Automic Automation Engine 24.4.X

OS: AIX 7.3

Database: Oracle 19c

Cause

A database column has exhausted its data type capacity.

DefectID: DE177418

Resolution

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

Public Title:
WP generates forced traces with database error

Public Description:
A problem has been fixed which caused forced traces with a database error stating ORA-01455: converting column overflows integer datatype

Additional Information

Article title: How to register to Broadcom Software Product updates and Critical Alerts

https://knowledge.broadcom.com/external/article?articleId=133819

Component: Automation.Engine

Automation Engine 24.4.3 - Available