Unable to issue a Let's encrypt certificate: Domain alias not found by id

Until a fix becomes available, use the following workaround:

1. Connect to the server via SSH;

2. Find the guid from affected domain name (e.g example.com)

# plesk db "select guid from domains where name='beechwoodguesthouse.com';"
+--------------------------------------+
| guid |
+--------------------------------------+
| 47567c0c-8c73-4f5c-ac5c-603cb22fc55c |
+--------------------------------------+

 3. Access sslit sqllite database:

# sqlite3 /usr/local/psa/var/modules/sslit/sslit.sqlite3

4. Update OrderAttribute table with value 'a:0:{}' which means no aliases to secure:

MYSQL_LIN: update OrderAttribute set value='a:0:{}' where orderId in(select id from Orders where domainGuid='47567c0c-8c73-4f5c-ac5c-603cb22fc55c' and status=0) and name='domainAliasesIdsToSign';

5. Cancel and remove all certificates request for the affected domain:

MYSQL_LIN: delete from OrderAttribute where orderId in(select id from Orders where domainGuid='47567c0c-8c73-4f5c-ac5c-603cb22fc55c' and status=0);

MYSQL_LIN: delete from Orders where domainGuid='47567c0c-8c73-4f5c-ac5c-603cb22fc55c' and status=0

6. Log into Plesk and reissue the certificate on Domains > example.com> SSL/TLS Certificate;