Cannot create business object in Plesk: mailmng-outgoing failed: ERROR:outgoing:column name is not unique

Symptoms

• Migration to Plesk finishes with one of the following warnings and domain is created with No Hosting type (without hosting):

  PLESK_ERROR: Failed deployment of domain example.com
  Warning:
  Execution of /usr/local/psa/admin/plib/api-cli/domain.php --create example.com -owner user -do-not-apply-skeleton -notify false -guid 056529ff-e402-463a-aa35-f82d124c4480 -creation-date 2015-03-09 -ip 10.10.10.10 -ignore-nonexistent-options failed with return code 1. Stderr is An error occurred during domain creation: mailmng-outgoing failed: ERROR:outgoing:column name is not unique

• Cannot create domain/subscription/reseller/customer with the same error:

  PLESK_ERROR: An error occurred during domain creation: mailmng-outgoing failed: ERROR:outgoing:column name is not unique

  or

  PLESK_ERROR: Error: mailmng-outgoing failed: ERROR:__main__:UNIQUE constraint failed: domains.name 

Cause

Inconsistensy in outgoing mail control database.

Resolution

1. Connect to the destination Plesk server via SSH.

2. Backup database:

   # cp /var/lib/plesk/mail/outgoing/data.db{,_bk}

3. Remove the subscription in question from the outgoing mail control database:

   # /usr/local/psa/admin/sbin/mailmng-outgoing --remove-domain --domain-name=example.com

4. In case of migration re-sync subscription;

5. In other cases re-create domain/subsctiption/reseller/customer.