Error changing IIS Application Pool global settings: Domains.id isn't found for 'IisAppPoolDomains.domainId'

Created:

2016-11-16 13:18:48 UTC

Modified:

2017-04-24 11:39:44 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error changing IIS Application Pool global settings: Domains.id isn't found for 'IisAppPoolDomains.domainId'

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 12.5 for Windows

Symptoms

Switching application pools to dedicated for all domains in Plesk-> Tools & Settings > IIS Application Pools > Global Settings fails with error:

    Dependent row(s) 'Domains.id = 1334' isn't found for 'IisAppPoolDomains.domainId = 1334'.
---------------------- Debug Info -------------------------------
0: Abstract.php:297
Db_Table_Abstract->findRelated(object of type Db_Table_Row_IisAppPoolDomain, string 'domain')
1: Row.php:95
Db_Table_Row->__get(string 'domain')
2: IisAppPoolsPolicy.php:105
Db_Table_Row_IisAppPoolsPolicy->_switchToDedicated()
3: IisAppPoolsPolicy.php:67
Db_Table_Row_IisAppPoolsPolicy->save()
4: IISAppPoolUIPointer.php:147
IISAppPoolUIPointer->accessItem(string 'POST', NULL null)
5: UIPointer.php:619
UIPointer->access(string 'POST')
6: plesk.php:36

Cause

Inconsistency in Plesk database, table IisAppPoolDomains .

Resolution

  1. Create dump psa database:

    "%plesk_dir%\\MySQL\\bin\\mysqldump.exe" -uadmin -p<plesk_admin_passwd> -P8306 psa > c:\\psa.sql
  2. Login to psa database and check IisAppPoolDomains table:

    mysql> select * from IisAppPoolDomains where domainid=1334;
    +----------+--------+
    | domainId | poolId |
    +----------+--------+
    | 1334 | 1 |
    +----------+--------+
    1 row in set (0.00 sec)
  3. Check and make sure that there is such domain in domain table:

    mysql> select * from domains where id=1334 or parentDomainId=1334;
    Empty set (0.00 sec)

    mysql> select * from domains where webspace_id=1334;
    Empty set (0.00 sec)

If there is no such domain, delete orphaned record from IisAppPoolDomains table:

    mysql> delete from IisAppPoolDomains where domainid=1334;
Have more questions? Submit a request
Please sign in to leave a comment.