Unable to able to delete custom form

Products

• CA Service Catalog

Issue/Introduction

How to delete a custom form within CA Service Catalog

Environment

CA Service Catalog - all versions

Resolution

The following conditions need to be met to be able to delete any form via CA Service Catalog Form Designer:

1.  There should not be any request whose status is not 0 (deleted) which used this particular form.

Query to identify which requests have used this form:  

select d.request_id from usm_subscription_detail d left outer join usm_request r on d.request_id = r.request_id where d.subscription_type=5 and d.status != 0 and r.status != 0 and d.text_1=22387

2.  There should not be any active Options which this particular form attached to it

Query to identify which active Service Options have the form attached: select *from usm_rate_definition where item_type = 14 and status = 1 and text_1=22387

Note: In the above queries, '22387' is the Form ID that needs to be deleted

For item #1, you have to delete the requests or move all these requests into a completed state and perform an "archive" to archive all the completed requests (remove from production tables into achieve tables)

If the above actions are not feasible, then the only option would be to create a new folder under forms in forms designer (i.e. Unused Forms) and move all the unused forms under this folder so that those are not mixed with active forms.