Duplicate entries in IPH tables prevent ILM partition drop

book

Article ID: 144921

calendar_today

Updated On:

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.