Search Engine: Elastic

Article ID: 117591, created on Sep 30, 2013, last review on May 6, 2014

  • Applies to:
  • Operations Automation 5.5
  • Business Automation 5.5


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 ? )'..


This is caused by a product issue scheduled to be fixed in POA 5.5 update 2.


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


  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.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e 5b048d9bddf8048a00aba7e0bdadef37 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF