How to overcome such an error?

Question

Drupal

The specified file 366 could not be copied to public://images/bands/366: "copy(366) [ function.copy ]: failed to open stream: No such file or directory File /home/isys/nocover.isys. by/sites/all/modules/migrate/plugins/destinations/file.inc, line 393"
Occurs during migration

Answer 1

If you set a goal - to make it in one request, then there is a solution, how acceptable it is - I don’t know ..

UPDATE `userprofiles` SET 
    `Value` =
    CASE `Field`
        WHEN 'Password' THEN 'pass'
        WHEN 'First name' THEN 'Ivan'
        WHEN 'Login' THEN 'SkyFox'
        ELSE `Value`
    END
WHERE `UserId` = 2

Answer 2

No way. Write 10 requests per transaction.