APSC inconsistency: Cannot find registry resource for Application ID

Symptoms

• The following error is shown when accessing an application link in the Applications tab in Plesk:

  PLESK_ERROR: Internal error: Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b
  Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b

  OR

• The following error is shown when trying to remove a subscription:

  PLESK_ERROR: Can not find registry resource for Application ID fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b

Cause

The application was incorrectly removed. As a result, while the application was left in the PSA database, it was removed from the APSC database.

Resolution

1. Connect to the server via SSH;

2. Backup psa and apsc databases;

3. Check there is an apsc.aps_registry_object record for this application ID:

   # plesk db
   mysql> select * from apsc.aps_registry_object where uid='fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b';
   Empty set (0.00 sec)

   In the above example, there is no record for this application in the APSC database.

4. Check for this application in the PSA database:

   # plesk db
   mysql> select * from psa.apsContextsApplications where registryApplicationId='fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b';
   +----+--------------+--------------------------------------+
   | id | apsContextId | registryApplicationId |
   +----+--------------+--------------------------------------+
   | 19 | 17 | fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b |
   +----+--------------+--------------------------------------+
   mysql> select * from psa.apsContexts where id=17;
   +----+-----------+---------+-------+----------------+
   | id | pleskType | pleskId | ssl | subscriptionId |
   +----+-----------+---------+-------+----------------+
   | 17 | hosting | 530 | false | 527 |
   +----+-----------+---------+-------+----------------+
   mysql> select name from psa.domains where id=530;
   +-------------------+
   | name |
   +-------------------+
   | domain.tld |
   +-------------------+

   Note: In the above example, records are shown for the broken application and its corresponding domain.

5. Remove the inconsistent records from the PSA database:

   # plesk db
   mysql> DELETE FROM psa.apsContexts WHERE id=17;
   mysql> DELETE FROM psa.apsContextsApplications WHERE apsContextId=17;