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

Products

• CA Automic Workload Automation - Automation Engine

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

Environment

Release : 12.1

Component : AUTOMATION ENGINE

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.

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.