Error on modifying an object in Plesk: Dependent row(s) isn't found

Symptoms

The following error is shown while performing operations on Plesk objects (i.e. subscriptions, mailboxes etc.):

PLESK_ERROR: Error: Unable to execute file-sharing: ERROR: Dependent row(s) 'FileSharingUsers.userId = 268' isn't found for 'smb_users.id = 268'.

Cause

Missing entries in fileSharingUsers table.

Resolution

1. Connect to the server via SSH.
2. Create Plesk database backup using steps from the following article: How to back up/restore Plesk system databases

3. Connect to Plesk database:

   # plesk db

4. Identify the missing entries:

   MYSQL_LIN: select count(*) from smb_users where id not in (select userId from fileSharingUsers);
   +----------+
   | count(*) |
   +----------+
   |      230 |
   +----------+

5. Insert the missing values into the fileSharingUsers table:

   MYSQL_LIN: insert into fileSharingUsers(userId,login) select id, login from smb_users where id not in (select userId from fileSharingUsers);