Symptoms

Subscription provisioning fails:

Error occurred while domain updating: Unable to update domain data: Unable to find service node for webmail '<webmail_name>'.

Cause

Database inconsistency. According to psa database the webmail is installed on the service node that does not exist.

mysql> select product_id, serviceNodeId from Webmails;
+------------+---------------+
| product_id | serviceNodeId |
+------------+---------------+
| horde      |             4 |
+------------+---------------+
2 rows in set (0.00 sec)

According to the query above, webmail service is installed on the node #4. But there is no such node.

mysql> select id, ipAddress from ServiceNodes where id = 4;
Empty set (0.00 sec)

Resolution

By default, the webmail installs on Management node, unless you have separate node for that.

Table psa.Webmails has to be corrected. The value serviceNodeId for necessary webmail should contain the ID of existent service node, the Webmail service is installed on:

1. Backup the database.

2. If the webmail hosts on management node, update the database the way below:

   mysql> update Webmails set serviceNodeId=1;
   

   NOTE: you may have to set another ID. It depends on the service node the webmail is installed on.

3. Restart the failed task.