Unable to resolve all conflicts while restoring domain backup

Symptoms

"Unable to resolve all conflicts" while trying to restore domain backup from CLI:

/usr/local/psa/bin/pleskrestore --restore /var/lib/psa/dumps/domains/<domain_name>/<damain_backup>.xml -level domains
Unable to resolve all conflicts

While trying to restore from Plesk GUI restoration doesn't go beyond IP mapping page.

Several conflicts in output xml log if aforementioned command run with -verbose option:

<conflicting-objects>
   <node name="domain">
    <attributes>
     <attribute name="id" value="123"/>
     <attribute name="guid" value="e7a6d663-7295-43ad-99b3-9e6a882a678d"/>
     <attribute name="owner-guid" value="f3335088-4627-4bdf-80c1-60b80490be0e"/>
     <attribute name="name" value="3100000.ru"/>
    </attributes>
   </node>
   <node name="phosting">
    <attributes>
     <attribute name="guid" value="e7a6d663-7295-43ad-99b3-9e6a882a678d_phosting"/>
     <attribute name="owner-guid" value="e7a6d663-7295-43ad-99b3-9e6a882a678d"/>
    </attributes>
   </node>
  </conflicting-objects>
[...]

Cause

Software issue with internal ID PPPM-569 . One of the users in database has & (ampersand) symbol in its password.

Resolution

Try to execute restore command once more(this time with -conflicts-resolution flag):

/usr/local/psa/bin/pleskrestore --restore /var/lib/psa/dumps/domains/<domain_name>/<damain_backup>.xml -level domains -conflicts-resolution conflict_resolution_rules

The error output should refer to a string which contains faulty password.Now you have to change this user's password in Plesk GUI, config.inc.php file of the corresponding domain and the dump.xml file of previously created backup.

1. Navigate to Domains > find %domain% > Websites&Domains tab> Databases > %domain% > %user% > New Password

2. Copy password from Step 1 to $database_password field of /var/www/vhosts/%domain%/httpdocs/core/config/config.inc.php file

3. Find and replace the old one in /usr/local/psa/PMM/rsessions/%session_id%/dump.xml with the new one

4. Restore the backup:

   /usr/local/psa/bin/pleskrestore --restore /var/lib/psa/dumps/domains/<domain_name>/domain_backup.xml -level domains -verbose