Clean up policies in policy manager: <policy name> cannot be deleted at this time: it is still in use as the underlying policy fragment for an encapsulated assertion

Products

• CA API Developer Portal

Issue/Introduction

Can not remove policy or folder:  

Delete folder API Portal Integration:

 

Environment

ssg 10.x, ssg 11.x. 

Cause

The policy or fragment is still in use. 

Resolution

if the policy actually is encapulated assertion:

1. In policy manager go to tasks-> extensions and add-ons-> manage encapsulated assertions
2. Select the encapsulated assertion in question and then use the export option and save the xml file
3. Then use the remove option to delete the encapsulated assertion in question from Policy Manager. 
4. Restart (log out of) policy manager

If the policy is a regular policy or fragment:

Find out all polices that uses or includes the policy/fragment, remove all reference police/fragment then select the policy and use delete option to delete the policy/fragment. 

To find all polices and fragments that use or include the policy/fragment that you want to remove:  

Run below sql in the mysql ssg database: 

select name from ssg.policy where xml like '%<the policy name that you want to remove>%'  or  xml like '%<the policy guid that you want to remove>%'  ; 

You can find policy/fragment guid by selecting the policy/fargment and right click the properties. 

Additional Information

It is possible that the include assertion uses the fragment guid instead of name.