Unable to access domain page in Plesk GUI: Unable to find service node for ip address with id

Symptoms

• Unable to access Plesk > Domains > example.com page with the error:
  

  PLESK_ERROR: Error: Unable to find service node for ip address with id=

• The "plesk repair db" utility reports the following inconsistencies:
  

  MYSQL_WIN: Inconsistency in the table 'DomainServices' for the column
  ipCollectionId: Web service cannot operate: the IP address list with
  ID 63 is empty .................................................... [ERROR]

Cause

Database inconsistency

Resolution 

1. Log into the server via RDP
2. Start a command prompt as Administrator
3. Create a backup for psa database in C:\ root:
   

   MYSQL_WIN: plesk db dump psa > C:\psa.sql

4.  Find database inconsistency:
   

   MYSQL_WIN: plesk repair db -n

   The output will be similar to the following:

   MYSQL_WIN: Inconsistency in the table 'DomainServices' for the column
   ipCollectionId: Web service cannot operate: the IP address list with
   ID 63 is empty .................................................... [ERROR]

5.  Using the ID from the error above, findv ID of the affected domain:
   

   MYSQL_WIN: plesk db " select * from DomainServices where ipCollectionId = 63;"
   +------+--------+------+--------+---------------+----------------+
   | id | dom_id | type | status | parameters_id | ipCollectionId |
   +------+--------+------+--------+---------------+----------------+
   | 2126 | 924 | web | 0 | 0 | 63 |
   +------+--------+------+--------+---------------+----------------+

6.  Then find the name of the affected domain by executing the following command, using dom_id found on the previous step as id:
   

   MYSQL_WIN: plesk db "select name from domains where id=924;"
   +---------------+
   | name |
   +---------------+
   | exampe.com |
   +---------------+

7. Using the query below, determine that example.com domain is hosted on IP 203.0.13.2:

   MYSQL_WIN: plesk db "select val,displayVal from dns_recs where host like '%example.com%';"
   ..................................................
   +------------------------------+------------------------------+
   | val | displayVal
   +------------------------------+------------------------------+
   | 203.0.13.2 | 203.0.13.2
   | 203.0.13.2 | 203.0.13.2 |

8.  Find ID of the 203.0.13.2 IP:

   MYSQL_WIN: plesk db "select id from IP_Addresses where ip_address='203.0.13.2';"
   +----+
   | id |
   +----+
   | 60 |
   +----+

9. Run the following commands one by one to fix database inconsistency for example.com domain:

   MYSQL_WIN: plesk db "insert into IpAddressesCollections values(63, 60)"

   MYSQL_WIN: plesk db "insert into IpAddressesCollections values(63, 60)"