DB Unload fails: 'ORA-00955: name is already used by an existing object'

Products

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

Issue/Introduction

DB Unload fails with the below error 

U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 9e484850  DB-HDBC: 9e4dcb88
U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
U00003592 UCUDB - Status: '' Native error: '955' Msg: 'ORA-00955: name is already used by an existing object'
U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'create global temporary table clct_run(run number(38, 0)) on commit preserve rows'
U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00955: name is already used by an existing object'
U00037184 Error on creating temporary table.

Environment

Release: 24.4.4

Component: Utilities

Sub-Component: DBUnload

Cause

DE183852

Resolution

Solution:

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

Fix version:

Component(s): Utilities

Automation.Engine 24.4.4 HF1 - Available
Automation.Engine 24.4.5 - Planned release June 2026

Workaround:
The 24.4.3 unload utility can be used in the meantime

Additional Information

Fix Desc:Resolved an issue in DBUnload (Oracle) where an incorrectly defined temporary table persisted beyond the database session, leading to conflicts on subsequent executions.