Facebook
TwitterTITLE:
an issue with migrations
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:Plesk Obsidian, both 18.0.04, ubuntu 18.04 from digitalocean image
PROBLEM DESCRIPTION:when migrating from one server to the next it always fails, i've tried to fix it but am having no luck
STEPS TO REPRODUCE:install migrator,
try to migrate
ACTUAL RESULT:try to migrate
Failed to fetch basic information about resellers, clients and domains data from source servers
Cause: Failed to execute SQL query on Plesk database: failed to parse JSON returned by SQL script.
Query:
SELECT Subscriptions.id as subscription_id, clients.id, login, pname
FROM clients
LEFT JOIN Subscriptions ON
Subscriptions.object_id = clients.id
AND Subscriptions.object_type = 'client'
WHERE clients.type = 'reseller'
Command's exit code: 255
Command's stdout:
Command's stderr: Died at AgentConfig.pm line 23.
That is a critical error, migration was stopped.
EXPECTED RESULT:Cause: Failed to execute SQL query on Plesk database: failed to parse JSON returned by SQL script.
Query:
SELECT Subscriptions.id as subscription_id, clients.id, login, pname
FROM clients
LEFT JOIN Subscriptions ON
Subscriptions.object_id = clients.id
AND Subscriptions.object_type = 'client'
WHERE clients.type = 'reseller'
Command's exit code: 255
Command's stdout:
Command's stderr: Died at AgentConfig.pm line 23.
That is a critical error, migration was stopped.
for it to work?
ANY ADDITIONAL INFORMATION:
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:Help with sorting out