Article ID: 122869, created on Sep 12, 2014, last review on May 22, 2016

  • Applies to:
  • Plesk Automation 11.5

Symptoms

The error below prevents from removing the subscription:

Cannot unsubscribe 1 subscriptions. Reason: Resource #15737 does not exist. 

Cause

The error appears when subscription in incompatible with service template it is based on. For example, when subscription contains webspace, however it's service template does not contain the proper resource type (Subscription).

That situation causes database inconsistency that can be solved by removing incompatible records from database.

The situation was caused by software issue #PPA-1683.

Resolution

The fix is uncluded in Plesk Automation MU#14. Instructions on installing PA updates can be found here.

In case an udpate is not an option the following steps can be performed as workaround:

  1. Back up the database you are about to change.
  2. Open PPA database and find the ID of the webspace of the subscription.

    plesk=> select webspace_id from plesk_webspaces where domain = '<domain_name>';
     webspace_id 
    -------------
             318 
    (1 row)
    
  3. Remove the inconsistent resources IDs.

    plesk=> delete FROM plesk_webspace_resources WHERE webspace_id =  318;
    DELETE 2
    
  4. Try to remove the subscription again. If the error happens again, it should be about another ID. (15738). That ID is absent in 'plesk_webspace_resources', so find it (and remove) in 'plesk_resource_usage', then removed:

    plesk=> select * from plesk_resource_usage where webspace_id=318;
     webspace_id | resource_id | usage
    -------------+-------------+-------
             318 |       15738 |     1
    (1 row)
    
    plesk=> delete from plesk_resource_usage where webspace_id=318;
    DELETE 1
    
  5. Remove the subscription from PPA control panel.

  6. Update PA to the latest version to avoid the issue in future:

    /usr/local/ppa/bin/ppa_update --install-updates
    

Search Words

Cannot delete 1 customer account(s). Reason: Resource #1461 does not exist

New subscription

Cannot unsubscribe 1 subscriptions. Reason: Resource #778 does not exist.

Resource #10101 does not exist.

Resource does not exist

cannot remove webspace

I cannot remove or change domain

Cannot unsubscribe 1 subscriptions. Reason: Resource

tasks are failed

I cannot remove subscription

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF