Symptoms
When provider tries to destroy a subscription in PBA, the following error is displayed:
Destroying service of Subscription #<SUB_ID> failed: Parallels Operations Automation error #extype_id #120, module_id #db_service, Foreign key 'awstats_accounts_fk1' violation while executing ' DELETE FROM subscriptions WHERE sub_id ? AND sub_id ! 1 AND NOT EXISTS (SELECT 1 FROM st_resources st JOIN subs_resources sr ON (st.src_rt_instance_id sr.rt_instance_id) WHERE sr.sub_id ? )'..
Cause
This is caused by a product issue scheduled to be fixed in POA 5.5 update 2.
Resolution
- Install POA 5.5.2 as soon as it is available.
Or
- Unprovide the awstats resource from the affected subscription by using pem.setResourceTypeLimit API method to set the resource limit to 0 in POA. Refer to the POA Public API Reference for details on using the API method.
- Destroy the subscription again in PBA-E.