• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Please beaware of a breaking change in the REST API on the next Plesk release (18.0.62).
    Starting from Plesk Obsidian 18.0.62, requests to REST API containing the Content-Type header with a media-type directive other than “application/json” will result in the HTTP “415 Unsupported Media Type” client error response code. Read more here

Problem to copy Mssql Database in Plesk panel

Status
Not open for further replies.
L

LiranA

New Pleskian
Hello,

I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ".
In the %plesk_dir%\admin\logs\ under the php-error.log i have this error:

"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."

Do you know what is the problem? or how can i debug it?

Please help me because I am stuck.

thanks,
liran
 
This is what i see in the event viewer (any solution?)

Log Name: Plesk
Source: dbbackup.exe
Date: 05/02/2014 13:31:41
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: servername
Description:
dbbackup.DbBackupException: Unable to copy database 'db1' to database 'db2'' ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Script transfer failed. ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Script failed for Server 'servername\MSSQLSERVER2012'. ---> Microsoft.SqlServer.Management.Smo.PropertyCannotBeRetrievedException: Property TextHeader is not available for StoredProcedure '[dbo].[ProductLoadAllPagegNopAjaxFilters]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextProperty(String requestingProperty, ScriptingPreferences sp, Boolean bThrowIfCreating)
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.BuildText(ScriptingPreferences sp)
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextForScript(ScriptingPreferences sp, Boolean forCreate, String[] expectedObjectTypes, Boolean forceCheckNameAndManipulateIfRequired)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptInternal(StringCollection queries, ScriptingPreferences sp, Boolean bForCreate)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptSP(StringCollection queries, ScriptingPreferences sp, Boolean bForCreate)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreate(StringCollection queries, ScriptingPreferences sp)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreateInternal(StringCollection query, ScriptingPreferences sp, Boolean skipPropagateScript)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObject(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.Script(DependencyCollection depList, SqlSmoObject[] objects, ISmoScriptWriter writer)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithListWorker(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
at Microsoft.SqlServer.Management.Smo.TransferBase.EnumScriptTransfer()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.TransferBase.EnumScriptTransfer()
at dbbackup.MsCopyProvider.CopyObjects(Boolean withData)
at dbbackup.MsCopyProvider.Copy(Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.MsCopy(String srcDbName, String dstSrv, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.Copy(String srcDbName, String dstSrv, Nullable`1 dstPort, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
--- End of inner exception stack trace ---
at dbbackup.DbBackupManager.Copy(String srcDbName, String dstSrv, Nullable`1 dstPort, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.Main(String[] args)
 
i can't find any problem by security, maybe this will be more informative:


Log Name: Plesk
Source: dbbackup.exe
Date: 05/02/2014 13:31:41
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: skyweb
Description:
dbbackup.DbBackupException: Unable to copy database 'db1' to database 'db2'' ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Script transfer failed. ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Script failed for Server 'servername\MSSQLSERVER2012'. ---> Microsoft.SqlServer.Management.Smo.PropertyCannotBeRetrievedException: Property TextHeader is not available for StoredProcedure '[dbo].[ProductLoadAllPagegNopAjaxFilters]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextProperty(String requestingProperty, ScriptingPreferences sp, Boolean bThrowIfCreating)
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.BuildText(ScriptingPreferences sp)
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextForScript(ScriptingPreferences sp, Boolean forCreate, String[] expectedObjectTypes, Boolean forceCheckNameAndManipulateIfRequired)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptInternal(StringCollection queries, ScriptingPreferences sp, Boolean bForCreate)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptSP(StringCollection queries, ScriptingPreferences sp, Boolean bForCreate)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreate(StringCollection queries, ScriptingPreferences sp)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreateInternal(StringCollection query, ScriptingPreferences sp, Boolean skipPropagateScript)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObject(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType& scriptType)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.Script(DependencyCollection depList, SqlSmoObject[] objects, ISmoScriptWriter writer)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithListWorker(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
at Microsoft.SqlServer.Management.Smo.TransferBase.EnumScriptTransfer()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.TransferBase.EnumScriptTransfer()
at dbbackup.MsCopyProvider.CopyObjects(Boolean withData)
at dbbackup.MsCopyProvider.Copy(Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.MsCopy(String srcDbName, String dstSrv, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.Copy(String srcDbName, String dstSrv, Nullable`1 dstPort, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
--- End of inner exception stack trace ---
at dbbackup.DbBackupManager.Copy(String srcDbName, String dstSrv, Nullable`1 dstPort, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.Main(String[] args)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="dbbackup.exe" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2014-02-05T11:31:41.000000000Z" />
<EventRecordID>128</EventRecordID>
<Channel>Plesk</Channel>
<Computer>servername</Computer>
<Security />
</System>
<EventData>
<Data>dbbackup.DbBackupException: Unable to copy database 'db1' to database 'db2'' ---&gt; Microsoft.SqlServer.Management.Smo.FailedOperationException: Script transfer failed. ---&gt; Microsoft.SqlServer.Management.Smo.FailedOperationException: Script failed for Server 'servername\MSSQLSERVER2012'. ---&gt; Microsoft.SqlServer.Management.Smo.PropertyCannotBeRetrievedException: Property TextHeader is not available for StoredProcedure '[dbo].[ProductLoadAllPagegNopAjaxFilters]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. The text is encrypted.
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextProperty(String requestingProperty, ScriptingPreferences sp, Boolean bThrowIfCreating)
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.BuildText(ScriptingPreferences sp)
at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.GetTextForScript(ScriptingPreferences sp, Boolean forCreate, String[] expectedObjectTypes, Boolean forceCheckNameAndManipulateIfRequired)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptInternal(StringCollection queries, ScriptingPreferences sp, Boolean bForCreate)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptSP(StringCollection queries, ScriptingPreferences sp, Boolean bForCreate)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreate(StringCollection queries, ScriptingPreferences sp)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.ScriptCreateInternal(StringCollection query, ScriptingPreferences sp, Boolean skipPropagateScript)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObject(Urn urn, ScriptingPreferences sp, ObjectScriptingType&amp; scriptType)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreate(Urn urn, ScriptingPreferences sp, ObjectScriptingType&amp; scriptType)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptCreateObjects(IEnumerable`1 urns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptUrns(List`1 orderedUrns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.DiscoverOrderScript(IEnumerable`1 urns)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.ScriptWorker(List`1 urns, ISmoScriptWriter writer)
at Microsoft.SqlServer.Management.Smo.ScriptMaker.Script(DependencyCollection depList, SqlSmoObject[] objects, ISmoScriptWriter writer)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithListWorker(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects, Boolean discoveryRequired)
at Microsoft.SqlServer.Management.Smo.TransferBase.EnumScriptTransfer()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.TransferBase.EnumScriptTransfer()
at dbbackup.MsCopyProvider.CopyObjects(Boolean withData)
at dbbackup.MsCopyProvider.Copy(Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.MsCopy(String srcDbName, String dstSrv, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.Copy(String srcDbName, String dstSrv, Nullable`1 dstPort, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
--- End of inner exception stack trace ---
at dbbackup.DbBackupManager.Copy(String srcDbName, String dstSrv, Nullable`1 dstPort, String dstSrvLogin, String dstSrvPwd, String dstDbName, Boolean withData, Boolean copyIFLoginsExist)
at dbbackup.DbBackupManager.Main(String[] args)</Data>
</EventData>
</Event>
 
IgorG said:
Would you like to share a cause and solution?
Click to expand...

yes, the problem was created by the customer and not by the system. he has deleted the user from the mssql and this is what cause the problem.

thank you for your help.
 
Status
Not open for further replies.

Similar threads

J
Resolved Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
6
Views
9K
JVG
J
H
Question MariaDB doesn't start after upgrade
Replies
3
Views
192
Kaspar@Plesk
Kaspar@Plesk
C
Resolved Mariadb not working - DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
7
Views
406
Crash79797
C
O
Resolved Failed to reset cache for the instance #9: Failed to update PHP handler for the instance #9
Replies
3
Views
3K
ose1955
O
Pascal_Netenvie
Issue Plesk migrator problem
Replies
7
Views
1K
Pascal_Netenvie
Pascal_Netenvie
Back
Top