APSC inconsistency: Cannot find registry resource for Application ID

Created:

2016-11-16 12:48:32 UTC

Modified:

2017-02-13 06:13:39 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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 Parallel Plesk:

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:

Can not find registry resource for Application ID a8e7efab-ee80-4e11-a9c7-f7f79044b248

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. 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.

  2. Check for this application in the PSA database:

    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 |
    +-------------------+

    In the above example, records show for the broken application and its corresponding domain.

  3. Remove the inconsistent records from the PSA database:

    mysql> delete from psa.apsContexts where id=17;

    mysql> delete from psa.apsContextsApplications where apsContextId=17;
Have more questions? Submit a request
Please sign in to leave a comment.