Duplicate entries in IPH tables prevent ILM partition drop

Products

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

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.

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.

Environment

Release : 12.2

Component : ACTION BUILDER

Resolution

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