Unable to open domain tab or Hosting Settings in Plesk: Unable to find service node for web service on domain with id=xxx

Symptoms

• Opening domains tab in Domains > example.com or Domain > example.com > Hosting Settings results in the following error:

external error: Unable to find service node for web service on domain with id=23

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

• Solution from the following article didn't help: https://support.plesk.com/hc/en-us/articles/12377770337175

Cause

Inconsistency in the Plesk database.

Resolution

Note: Steps below are the same for both Linux and Windows.  

1. Connect to the Plesk server via SSH/RDP.

2. Create Plesk database backup

3. Access Plesk database

4. Find what ip_address_id is assigned to the domain name with the id of the error:

mysql> SELECT param, val FROM dom_param WHERE dom_id = 23;
+---------------------+--------------------------------------+
| param | val |
+---------------------+--------------------------------------+
| ip_addr_id | 2 |
+---------------------+--------------------------------------+

mysql> SELECT ip_address_id FROM ip_pool WHERE id=(SELECT pool_id FROM clients WHERE id=(SELECT cl_id FROM domains WHERE id=23));
+---------------+
| ip_address_id |
+---------------+
| 1 |
| 2 |
+---------------+

3. Check if the IPs with ip_address_id 1 and 2 exist:

mysql> SELECT id,ip_address FROM IP_Addresses WHERE id=1;
+----+-----------------+
| id | ip_address |
+----+-----------------+
| 1 | 203.0.113.2 |
+----+-----------------+
1 row in set (0.00 sec)

mysql> SELECT id,ip_address FROM IP_Addresses WHERE id=2;
Empty set (0.00 sec)

4. Update the ID for the IP_Addresses table:

mysql> UPDATE IP_Addresses SET id=2 WHERE ip_address='203.0.113.2';

5. Check what ID does ip_address_id=2 have in the ip_pool table:

mysql> SELECT * FROM ip_pool;
+----+---------------+-----------+
| id | ip_address_id | type |
+----+---------------+-----------+
| 1 | 1 | exclusive |
| 1 | 2 | exclusive |
+----+---------------+-----------+
2 rows in set (0.00 sec)

6. The ip_address_id=2 should have a unique id=1. Update the ip_pool table:

mysql> UPDATE ip_pool SET id=2 WHERE ip_address_id=1;