Crash with forced traces at cold start after upgrade from V9 to V11.1.3 HF1

book

Article ID: 84328

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
U00029108 UCUDB: SQL_FEHLER Database-Handles DB-HENV: af86f0 DB-HDBC: b3f580
U00003592 UCUDB - Status: '' NativeError: '30036' Msg: 'ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO''

If you made an upgrade of the Automic Engine to a higher version it is recommended to do a cold start with one of the working processes.

During this process data from several tables will be deleted.

If the sizing of the undo tablesspace is to small it will run out of space (e.g.: during the deletion of table BT).

Cause

Cause type:
Configuration
Root Cause: If the sizing of the undo tablesspace is to small it will run out of space (e.g.: during the deletion of table BT).

Environment

OS Version: N/A

Resolution

1) Extend the undo tablespace
2) Truncate related tables (e.g. BH, BT)


Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A