AWA - U00021152 REORG during DB maintenance

Products

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

Issue/Introduction

The maintenance will sometimes fail with the error below :

U00021152 REORG: client: 'XXX', type: 'YYYY', object name: 'OBJECT_NAME'  was ignored because there are still non-archived STATISTIC / REPORT records.

But when looking in the database for those objects (OH_IDNR) we cannot find any records in tables RH,RT,AH,EH...

Environment

Release :  ALL

Component : AUTOMATION ENGINE

Cause

This is the default behavior, the unload utility checks if there are executable objects marked for deletion which are not archived.

The message will be produced for all Executable Object that has OH_DeleteFlag=1 (Deleted) as described by the query below:

select OH_Client, OH_Name, OH_OType from OH where OH_DeleteFlag = 1 and OH_Otype in (Select OTYP_Type from UC_OTyp where OTYP_Executable = 1)

Resolution

Check the value of the option "No archive check" on the DB REORG/DB UNLOAD ini files (it should be set on both).

Setting this value to 1 (true) will disable the archive check and will allow the maintenance to run properly.

[ REORG ]
no_Archive_Check=1

Additional Information

More details here and here