Unable to open domain tab or Hosting Settings in Plesk:

[mahesh]

Question:
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:

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

• Connect to the Plesk server via SSH/RDP.
• Create Plesk database backup
• Access Plesk database
• 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 |
+---------------------+--------------------------------------+

Code Select Expand

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 |
+---------------+
Check if the IPs with ip_address_id 1 and 2 exist:

Code Select Expand

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)



Code Select Expand

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

Update the ID for the IP_Addresses table:

Code Select Expand

mysql> UPDATE IP_Addresses SET id=2 WHERE ip_address='203.0.113.2';
Check what ID does ip_address_id=2 have in the ip_pool table:

Code Select Expand

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

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

Code Select Expand

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