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.
Release : 12.2
Component : ACTION BUILDER
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.