Can not find registry resource for Application ID

Discussion in 'Parallels Plesk Panel 11.x for Linux Problems, Suggested Fixes, and How-To' started by scool, Sep 9, 2013.

Thread Status:
Not open for further replies.
  1. scool

    scool New Member

    Messages:
    41
    New configuration files for the Apache web server were not created due to the errors in configuration templates:
    Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: Can not find registry resource for Application ID 8f27b0c0-b80f-4d77-8164-26f5886dbb37 file: /usr/local/psa/admin/plib/Template/Processor.php line: 27 code: 0 Previous error: Template_Exception: Can not find registry resource for Application ID 8f27b0c0-b80f-4d77-8164-26f5886dbb37 file: /usr/local/psa/admin/plib/Template/Processor.php line: 27 code: 0 Previous error: Apspp_Exception: Can not find registry resource for Application ID 8f27b0c0-b80f-4d77-8164-26f5886dbb37 file: /usr/local/psa/admin/plib/Apspp/Registry.php line: 147 code: 0. The error message containing the detailed error descriptions was sent to you by e-mail. Please resolve the issues and click here to generate broken configuration files once again or here to generate all configuration files.


    Does anyone knows what this is about?
  2. abdi

    abdi Product Expert

    Messages:
    2,202
  3. scool

    scool New Member

    Messages:
    41
    Thank you Abdi, yes i have already check that. Not worked
    Last edited: Sep 9, 2013
  4. scool

    scool New Member

    Messages:
    41
    The owner of the website said to me that for some reason installed twice the wordpress package via application vault.
    Then he tried to unistall both installation, and then the plesk crashed with the error above.

    Screenshot_1.jpg
    Screenshot_2.png

    Now, on the menu left, the attached error appeared, and i haven't found any kb article to help me.
    Can you please assist? i suppose i have to manually login to mysql and remove several entries.

    Ofcourse i cannot remove client account and re-created it, neither via ssh. The same error appears again.
    [root@ns1 ~]# /usr/local/psa/bin/subscription -r domain.tld
    Can not find registry resource for Application ID 8f27b0c0-b80f-4d77-8164-26f5886dbb37
    Last edited: Sep 9, 2013
  5. IgorG

    IgorG Parallels Team

    Messages:
    16,096
    It appears that this application was broken and the only solution is removing it. Try to do following:

    mysql> select * from apsContextsApplications where registryApplicationId="8f27b0c0-b80f-4d77-8164-26f5886dbb37";
    mysql> delete from apsContextsApplications where id=XXX;

    XXX is id from first select.
  6. scool

    scool New Member

    Messages:
    41
    Thank you for your reply.
    query executed, but plesk still not working.
  7. IgorG

    IgorG Parallels Team

    Messages:
    16,096
    What exactly was done and what exactly not working?
  8. scool

    scool New Member

    Messages:
    41
    As i said, the customer just tried to unistall wordpress app, from application vault. I have no idea what is supposed to go wrong on such an action. this is very weird.
    I tried to have explained from the customer exactly what he did, but he only said that by mistake he installed twice wordpress app, and on unistall the subscription crached.

    At this time, every customer logging in on my panel, see the menu error on the left menu. (white screenshot).
    Current customer , cannot login, and on login action the following error appears

    Screenshot_1.png
  9. IgorG

    IgorG Parallels Team

    Messages:
    16,096
    It is database inconsistency. Try to search related KB articles and fix it in database by yourself or contact Support Team if you can't.
  10. scool

    scool New Member

    Messages:
    41
    Unfortunatly i cannot afford this time (per incident support $75) , and only related kb article i found is this, but not helped
    http://kb.parallels.com/en/112733

    How is possible a wrong action by a customer to destroy the psa records? isn't a bit risky?
  11. abdi

    abdi Product Expert

    Messages:
    2,202
  12. IgorG

    IgorG Parallels Team

    Messages:
    16,096
    It is difficult to say without detailed investigation directly on customer's server. Therefore I suggest contact Support Team.
  13. scool

    scool New Member

    Messages:
    41
    The only available support is the "per incident support" for $75 ?
  14. IgorG

    IgorG Parallels Team

    Messages:
    16,096
    If you have Unlimited 11.5 license - support is free.
  15. abdi

    abdi Product Expert

    Messages:
    2,202
  16. StéphanS

    StéphanS Product Expert

    Messages:
    138
    I had a similar issue.
    A customer had clicked the install app button several times in a row (it wasn't going fast enough for them..).

    They then tried to delete it multiple times again.


    I did the dumps as described in http://kb.parallels.com/en/112733
    And then grepped both .sql's for the Application ID.

    Only the psa dump had the entry.


    I managed to fix the error by running:



    Code:
    mysql> SELECT * FROM psa.apsContextsApplications WHERE psa.apsContextsApplications.registryApplicationId = 'x6d3x1ds-6dz5-s5xq-d956-5x5fg5sjl564';
    +----+--------------+--------------------------------------+
    | id | apsContextId | registryApplicationId                |
    +----+--------------+--------------------------------------+
    | 89 |           56 | x6d3x1ds-6dz5-s5xq-d956-5x5fg5sjl564 |
    +----+--------------+--------------------------------------+
    1 row in set (0.00 sec)
    
    mysql> SELECT * FROM psa.apsContexts WHERE psa.apsContexts.id IN (SELECT psa.apsContextsApplications.apsContextId FROM psa.apsContextsApplications WHERE psa.apsContextsApplications.registryApplicationId = 'x6d3x1ds-6dz5-s5xq-d956-5x5fg5sjl564');
    +----+-----------+---------+-------+----------------+
    | id | pleskType | pleskId | ssl   | subscriptionId |
    +----+-----------+---------+-------+----------------+
    | 56 | hosting   |     304 | false |            259 |
    +----+-----------+---------+-------+----------------+
    1 row in set (0.00 sec)
    
    
    mysql> DELETE FROM psa.apsContexts WHERE psa.apsContexts.id IN (SELECT psa.apsContextsApplications.apsContextId FROM psa.apsContextsApplications WHERE psa.apsContextsApplications.registryApplicationId = 'x6d3x1ds-6dz5-s5xq-d956-5x5fg5sjl564');
    Query OK, 1 row affected (0.01 sec)
    
    mysql> DELETE FROM psa.apsContextsApplications WHERE psa.apsContextsApplications.registryApplicationId = 'x6d3x1ds-6dz5-s5xq-d956-5x5fg5sjl564';
    Query OK, 1 row affected (0.00 sec)
    
    

    Hope this helps someone out!


    (The numbers and id's have been replaced, but the logic has been kept)
  17. StéphanS

    StéphanS Product Expert

    Messages:
    138
    This has now been put into a KB article it seems.
    The SQL used is different (and easier for SQL beginners), but the result is exactly the same.

    http://kb.parallels.com/en/118260
  18. StéphanS

    StéphanS Product Expert

    Messages:
    138
    It seems that the logic has been changes since some recent micro update:


    Code:
    mysql> select * from apsContextsApplications;
    ERROR 1146 (42S02): Table 'apsc.apsContextsApplications' doesn't exist
  19. IgorG

    IgorG Parallels Team

    Messages:
    16,096
    [root@ppu11-5 ~]# grep 'patch version' /root/.autoinstaller/microupdates.xml
    <patch version="30" timestamp="" installed-at="20140129T165405" />

    [root@ppu11-5 ~]# plesk db

    mysql> select * from apsContextsApplications;
    Empty set (0.00 sec)

    mysql> desc apsContextsApplications;
    +-----------------------+------------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +-----------------------+------------------+------+-----+---------+----------------+
    | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
    | apsContextId | int(10) unsigned | NO | | NULL | |
    | registryApplicationId | varchar(36) | NO | | NULL | |
    +-----------------------+------------------+------+-----+---------+----------------+
    3 rows in set (0.00 sec)
  20. StéphanS

    StéphanS Product Expert

    Messages:
    138
    My bad indeed.

    These tables reside in psa not in apsc.
Thread Status:
Not open for further replies.

Share This Page