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

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

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.

Search Words

awstats_accounts_fk1

destroy subscription fails

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

Email subscription for changes to this article
Save as PDF