Applicable to:
- Plesk for Windows
Symptoms
Unable to copy database under Plesk > Domains > example.com > Databases > Copy.
- No errors are shown in Plesk GUI.
- There are the following records in
%plesk_dir%admin\logs\php_error.logafter enabling Plesk debug:CONFIG_TEXT: [2017-08-15 10:24:23] ERR [1] PleskUtilException: E:\Parallels\Plesk\/admin/bin/dbbackup --copy "-server-type=mssql" -with-data "-src-server=(local)" "-src-port=0" "-src-server-login=dbuser" "-src-server-pwd=<password>" "-src-database=ORIGINAL_DB" "-dst-server=(local)" "-dst-port=0" "-dst-server-login=sa" "-dst-server-pwd=<password>" "-dst-database=CLONED_DB" failed with message: Command 'IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Accounting].[AccountCatalogView]'))
EXEC dbo.sp_executesql @statement = N'
CREATE VIEW [Accounting].[AccountCatalogView]
as
[...]
' failed
Invalid object name 'Accounting.AccountCatalog'.
...
[2017-08-15 10:24:23] ERR [panel] Task failed: id=3717, pid=43812, type=db-clone, error=Database cloning failed.
DEBUG [panel] Db_Clone_Exception: Database cloning failed.
file: E:\Parallels\Plesk\admin\plib\Db\Clone\Task.php
line: 53
code: 0OR
CONFIG_TEXT: 2018-06-14 15:36:24] ERR [1] "C:\Program Files (x86)\Plesk\admin\bin64\dbbackup" --copy "-server-type=mssql" -with-data "-src-server=example.com" "-src-port=0" "-src-server-login=dbname" "-src-server-pwd=******" "-src-database=dbname" "-dst-server=example.com" "-dst-port=0" "-dst-server-login=plesk_database_user" "-dst-server-pwd=******" "-dst-database=dbname" failed with code 21. stdout: Command 'IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[Active_Members_ListQRY]')) EXEC dbo.sp_executesql @statement = N'CREATE VIEW [dbo].[Active_Members_ListQRY] AS SELECT.... FROM.... WHERE... ''Active'') ' ' failed Invalid object name 'dbo.tablename'.
Cause
Plesk bug ID #PPPM-6901, which is planned to be fixed in future Plesk updates.
Resolution
As a workaround export and then import database under Plesk > Domains > example.com > Databases > Export Dump/Import Dump.
Comments
2 comments
Time to fix it. Never saw this feature working.
@Marco we will do our best to fix this issue soon, but no ETA yet.
Please sign in to leave a comment.