CAU package: how to remove/delete old versions

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When installing a new CAU package, the newest version will be displayed in Administration Perspective, however, all previous versions are kept.

The table OBLOB is getting too large, how to delete the CAU old versions and cleanup the database to reduce the size?

Environment

Release : 12.x and 21.x

Component : AUTOMATION ENGINE

Resolution

1. Go to client 0 - Packs and click on Remove on the CAUs that you want to remove.
   
2. Perform a database query on the table HOSTS to check the HOST_TargetVersion and make sure that no Agent is using one of the old versions that you want to delete .
   Assuming you just want to keep version 21.0.9 only, make sure that the query 

   select * from host order by HOST_TargetVersion desc;
   only returns HOST_TargetVersion with agents on version 21.0.9, if you have older version agents, please update them earlier or unset the value of the column HOST_TargetVersion on them.

3. Go to Client 0 > Process Assembly Perspective > Explorer > PACKAGES > APPDATA > PCK.AUTOMIC_CAU_AGENTS_NAME_OF_THE_PACKAGE

4. Select all the store objects (CAU binary packages) that you want to delete and then click on Delete (so they will be marked for deletion and moved to Recycle bin)
   
   
5. Run DB Unload Utility with option Reorganize database to empty the recycle bin and completely remove them from the database

6. Install the latest CAU package for that same CAU Agent so that only the latest version is kept