Symptoms

Upgrade subscriptions task failed:

subdomain service #2570 does not exist

Select returns a not completely deleted subdomain service.

SELECT ds.ds_id AS hosting_id, ds.name AS name, ds.is_locked AS is_locked, ds.subscription_id AS sub_id, ds.hd_id AS webspace_id, ds.service_id AS service_id, s.host_id AS host_id, s.sc_id AS sc_id FROM domain_services ds JOIN services s ON (ds.service_id = s.service_id) WHERE ds.ds_id = 991;

Same error can occur when trying to change the service template of the subscription.

Cause

Subscription - related tasks were cancelled and it caused orphaned records in OSA database (subdmain services).

Resolution

Please contact Odin Technical Support on this matter.

Internal content

Link on internal Article