From Ubiquity Server Wiki
In the event that you get the unhelpful Transfer Failed error after attempting to use the Mass Migrate feature in NodeWorx, you can 99% of the time fix this error by issuing the repair operation on all databases under the given SiteWorx account.