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

  1. Install POA 5.5.2 as soon as it is available.

Or

  1. 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.
  2. Destroy the subscription again in PBA-E.

Internal content

Link on internal Article