• 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
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff 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
2
Views
144
JVG
J
O
Resolved Failed to reset cache for the instance #9: Failed to update PHP handler for the instance #9
Replies
3
Views
2K
ose1955
O
Pascal_Netenvie
Issue Plesk migrator problem
Replies
7
Views
1K
Pascal_Netenvie
Pascal_Netenvie
S
Issue Plesk Panel keep redirecting when trying to login Admin Panel
Replies
7
Views
2K
IgorG
IgorG
K
Issue Plesk Migrator - Obsidian 18.0.56 - Errors / unable to migrate
Replies
4
Views
2K
salvis
S
Back
Top