AE - Error while running Reorg/unload ORA-01555: snapshot too old

book

Article ID: 110900

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

I got the following error when running reorg or unload as below:

20180810/142218.599 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 2361050 DB-HDBC: 23abe68 
20180810/142218.599 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' 
20180810/142218.599 - U00003592 UCUDB - Status: '' Native error: '1555' Msg: 'ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_2210851416$" too small' 
20180810/142222.600 - U00000006 DEADLOCK 
20180810/142222.600 - U00003594 UCUDB Ret: '6' opcode: 'EXEC' SQL Stmnt: 'UPDATE AH SET AH_DeleteFlag = 1 WHERE AH_Idnr = ?'

Environment

Release:
Component: AAUTEN

Resolution

According to the Oracle message, please contact a DBA and ask them to increase the size of rollback segment 8 with name "_SYSSMU8_2210851416$".


'ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_2210851416$" too small'

Additional Information

You can find more information here:
http://www.dba-oracle.com/t_ora_01555_snapshot_old.htm
https://docs.oracle.com/database/121/ADMQS/GUID-26945DEA-D1F9-42BA-8CB5-7BE4DB6EC14D.htm#ADMQS12051 
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6013.htm 

 

This can also be caused by a large amount of records being deleted at one time.  Updating the reorg_chunk_size to a lower number in the unload ini file may help.  More info can be found here: https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Admin/inifiles/admin_ini_utility_db_unload.htm?Highlight=reorg_chunk_size