Wrong status in ILM Partitions table may cause trouble when trying use ILM

Products

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

Issue/Introduction

When trying to drop a partition, some issues may occur :
- Unable to disconnect the users from the partition which is supposed to get dropped
- Unable to switch current partition to the next one

Cause

Check the ILM status on the partition in question :
select IPH_State from IPH where IPH_PARTITION=<number>

If the the status is different than "1" then there is an issue.

Environment

Release : 12.1

Component : AUTOMATION ENGINE

Resolution

Change IPH table status in order to delete the ILM partition.

To do so, run the SQL query :
update IPH set IPH_State=1 where IPH_PARTITION=<number>;
commit;

Then the partition can be dropped.