A subscription cancellation order fails:
Removing of Service of Subscription #XXXXXX is failed. Deletion service of Subscription #XXXXXX failed.
In PEMGATE.log and in poa.log, an error can be seen:
Parallels Operations Automation error #extype_id #120, module_id #db_service, Foreign key 'domain_hosting_bindings_fk2' 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 ? )'..
The same error may also occur when trying to destroy a terminated/stopped subscription by clicking the "Destroy" button in Business Automation (BA).
The DNS hosting resource usage on the Operations Automation (OA) side is incorrect:
plesk=> SELECT s.curr_usage FROM subs_resources s JOIN resource_types rt ON s.rt_id = rt.rt_id WHERE rt.restype_name = 'DNS hosting' AND s.sub_id = <SUB_ID>; curr_usage ------------ 0
One of the possible reasons is bug POA-81039/POA-81477 (The resource usage data becomes incorrect if the addDomain is executed for the existing domain with DNS hosting).
Adjust a resource usage to 1 (please contact Odin Support for assistance) and retry the attempt to provision an order or destroy a subscription.