Parallels

Symptoms

The domain migration is failed with the following error in "migration.result" log file:


Location of the "migration.result" file is:
C:\Program Files\Parallels\Plesk\PMM\rsessions\20091009162759913\
where 20091009162759913 is date and time the migration was performed.

The failure occurs in the following conditions:

1. Migration is performed from Plesk version older than 9.x;
2. Source server is Windows or Linux;
3. The destination server is Windows;

Cause

The length of login name is 16 characters, but since Plesk 9.0 the maximum login name is 15.

Resolution

Ti fix the error it is necessary to figure out domains which has login names more than 15 symbols on source server using commands below and rename found users in Plesk:

Windows:

If Plesk database engine works in MySQL use this command to find list of required users:

"%plesk_bin%\dbclient.exe" --direct-sql "--sql=select * from sys_users where length(login)>15"

If Plesk database engine works in Jet or MS SQL use this command to find list of required users:

"%plesk_bin%\dbclient.exe" --direct-sql "--sql=select * from sys_users where len(login)>15"

Then reduce user logins which length is more than 15 symbols renaming them in Plesk.

Linux:

Login to mysql and run this query:

select d.displayName,s.login from sys_users s, domains d, hosting h where (length(s.login)>15) and (h.sys_user_id=s.id) and (h.dom_id=d.id)

Then reduce user logins which length is more than 15 symbols renaming them in Plesk.