Some MS SQL tables are missing after migrating from Plesk 8.6 with external MS SQL database server.

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows

Created:

2016-11-16 12:55:33 UTC

Modified:

2016-12-21 19:33:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Some MS SQL tables are missing after migrating from Plesk 8.6 with external MS SQL database server.

Symptoms

Some tables in MS SQL database are missing after migration of a domain containing MS SQL database from Plesk 8.6 with external MS SQL database server.

The following error mesages are contained in log file " %plesk_dir%\\PMM\\rsesssions\\session_id\\Psarestore.log " (Plesk 11.5) or " %plesk_dir%\\PMM\\rsesssions\\session_id\\Migration.log " (Plesk 12.0):

[2014-06-06 14:09:04.784|12176] Debug: Last error occured in command: 'CREATE TABLE [dbo].[FailerMessage] (
[NewsletterId] [uniqueidentifier] NOT NULL ,
[Email] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[FailerDate] [datetime] NULL ,
[FailedEmail] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[FailedReason] [nvarchar] (0) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]'. Error info:
System.Data.SqlClient.SqlException (0x80131904): Line 6: Length or precision specification 0 is invalid.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at psadumpagent.MsSqlScriptExecutor.execNonQuery(SqlCommand command)
at psadumpagent.MsSqlScriptExecutor.executeCommand(SqlCommand cmd)
ClientConnectionId:e256bcf1-9729-4d45-b99c-af5adbc47de0

[2014-06-06 14:09:04.971|12176] Debug: Last error occured in command: 'CREATE TABLE [dbo].[sf_CmsComment] (
[Application] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL ,
[ID] [uniqueidentifier] NOT NULL ,
[TextValue] [nvarchar] (0) COLLATE Latin1_General_CI_AS NULL ,
[Author] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[Email] [nvarchar] (256) COLLATE Latin1_General_CI_AS NULL ,
[WebSite] [nvarchar] (256) COLLATE Latin1_General_CI_AS NULL ,
[Visible] [int] NULL ,
[DateCreated] [datetime] NULL ,
[IpAddress] [nvarchar] (41) COLLATE Latin1_General_CI_AS NULL ,
[Owner] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[CntID] [uniqueidentifier] NULL
) ON [PRIMARY]'. Error info:
System.Data.SqlClient.SqlException (0x80131904): Line 4: Length or precision specification 0 is invalid.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at psadumpagent.MsSqlScriptExecutor.execNonQuery(SqlCommand command)
at psadumpagent.MsSqlScriptExecutor.executeCommand(SqlCommand cmd)
ClientConnectionId:e256bcf1-9729-4d45-b99c-af5adbc47de0

Cause

Plesk 8.6 is originally developed for Microsoft SQL Server 2000, it does not completely support MS SQL Server 2005, because a new data types was added in MS SQL Server 2005.

Resolution

Migrate the database using Backup/Restore method.

  1. Perform the migration of the domain containing such databases.

  2. Make the database backup using Plesk Backup Manager on the source server: Domains > Domain_Name > Database Backup Repository > Back Up Now

  3. When the backup is completed, download the backup file.

  4. Upload the backup file to the domain backup database repository on the destination server:

    Home > Subscriptions > Subscription_Name > Websites & Domains > Backup Manager > More Actions > Database Backup Repository

    and restore the database from the backup.

  5. Change connection strings in the website configuration files if necessary.

Have more questions? Submit a request
Please sign in to leave a comment.