APSC inconsistency: Cannot find registry resource for Application ID - Plesk (Windows/Linux)

APPLIES TO:
Parallels Plesk Automation 11.1
Parallels Plesk Panel 11.0 for Linux
Parallels Plesk Panel 11.5 for Linux
Parallels Plesk Panel 11.0 for Windows
Parallels Plesk Panel 11.5 for Windows

Symptoms
This error is shown when you access an application link in the ‘Applications’ tab in Parallels Plesk Panel:
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
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
Check there is an aps_registry_object record for this application ID:
mysql> select * from aps_registry_object where uid=’fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b’;
Empty set (0.00 sec)
In the above example, we have not got the record for this application in the APSC database.
Check for this application in the PSA database:
mysql> select * from apsContextsApplications where registryApplicationId=’fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b’;
+—-+————–+————————————–+
| id | apsContextId | registryApplicationId |
+—-+————–+————————————–+
| 19 | 17 | fbea5fe0-7e00-42fb-9fa0-e4fd2e664f8b |
+—-+————–+————————————–+

mysql> select * from apsContexts where id=17;
+—-+———–+———+——-+—————-+
| id | pleskType | pleskId | ssl | subscriptionId |
+—-+———–+———+——-+—————-+
| 17 | hosting | 530 | false | 527 |
+—-+———–+———+——-+—————-+

mysql> select name from domains where id=530;
+——————-+
| name |
+——————-+
| domain.tld |
+——————-+
In the above example, records show for the broken application and its corresponding domain.

Remove inconsistent records from PSA database:

mysql> delete from apsContexts where id=17;

mysql> delete from apsContextsApplications where apsContextId=17;