ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Wrong status in ILM Partitions table may cause trouble when trying use ILM
book
Article ID: 143534
calendar_today
Updated On:
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
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.
Environment
Release : 12.1
Component : AUTOMATION ENGINE
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;