Duplicate entries in IPH tables prevent ILM partition drop

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When trying to drop a partition, the ILM will keep skipping it.

The partition seems to be seen as "checked" by AWA but is not shown as so in the interface.

Environment

Release : 12.2

Component : ACTION BUILDER

Cause

This error may occur when the previous ILM did not end well.
Duplicated line may be visible in the table :

IPH_IDNR,IPH_PARTITION,IPH_TABLESPACE,IPH_MINVALUE,IPH_MAXVALUE,IPH_DATEFROM,IPH_DATETO,IPH_TABLE,IPH_STATE
1005034,7,UC4_DATA,1364000,1625999,04/08/2019 22:00:15,08/09/2019 22:00:05,MELD,2
1005035,7,UC4_DATA,1008000,1009999,04/08/2019 22:00:15,08/09/2019 22:00:05,XAO,2
1006034,7,UC4_DATA,1451000,1625999,21/08/2019 22:00:14,08/09/2019 22:00:05,MELD,2
1006035,7,UC4_DATA,1008000,1009999,21/08/2019 22:00:14,08/09/2019 22:00:05,XAO,2
1006064,7,UC4_DATA,1613000,1625999,05/09/2019 22:00:13,08/09/2019 22:00:05,MELD,0
1006065,7,UC4_DATA,1009000,1009999,05/09/2019 22:00:13,08/09/2019 22:00:05,XAO,0

Entries with state 2 will cause the ILM to skip the partition.

Resolution

DBA action : Remove the duplicate lines in IPH table for the IPH_PARTITION causing trouble with IPH_STATE=2.