我正在尝试使用pipe理Microsoft内容pipe理服务器迁移configuration文件工具在MOSSpipe理中心的操作空间中将数据从Microsoft内容pipe理服务器（MCMS）2002实例迁移到新的Microsoft Office Sharepoint Server（MOSS）2007安装。
在分析configuration文件时，我收到4条警告，所有这些警告都可以安全地忽略，但是当我实际执行迁移configuration文件时，我会得到相同的警告和额外的错误，其描述如下：
Line 6: Incorrect syntax near ';'. 我曾多次在SQL Server中看到此错误，并将其识别为Transact SQL错误消息，但无法find正在执行的实际SQL语句，以便我可以确定错误的来源。
编辑：在MCMS 2002迁移类别上启用详细日志logging，并通过统一日志logging服务（ULS）日志钻研后，我收到了一个更完整的堆栈跟踪的错误点，以及一些更多的exception下面列出。
exception情况：以下是在迁移前分析时间内ULS日志的缩写列表。
01 MCMS 2002 Migration Verbose Start ConnectionCheck 02 MCMS 2002 Migration Verbose End ConnectionCheck 03 MCMS 2002 Migration Verbose Start DatabaseCheck 04 MCMS 2002 Migration High Extra table SiteDeployLock will not be migrated 05 MCMS 2002 Migration High Analysis: Extra index PK__SiteDeployLock__05D8E0BE 06 MCMS 2002 Migration Verbose End DatabaseCheck 07 MCMS 2002 Migration Medium Pre-migration analysis: RootCheckTask is skipped because database check is blocked. 08 MCMS 2002 Migration Medium Pre-migration analysis: RightsGroupNameCheckTask is skipped because database check is blocked. 09 MCMS 2002 Migration Medium Pre-migration analysis: InvalidNameCheckTask is skipped because database check is blocked. 10 MCMS 2002 Migration Medium Pre-migration analysis: LeafNameCheckTask is skipped because database check is blocked. 11 MCMS 2002 Migration Medium Pre-migration analysis: LeafLengthCheckTask is skipped because database check is blocked. 12 MCMS 2002 Migration Medium Pre-migration analysis: TemplateNameCheckTask is skipped because database check is blocked. 13 MCMS 2002 Migration Medium Pre-migration analysis: TemplateCollisionCheckTask is skipped because database check is blocked. 14 MCMS 2002 Migration Medium Pre-migration analysis: PlaceholderCheckTask is skipped because database check is blocked. 15 MCMS 2002 Migration Medium Pre-migration analysis: CheckedOutItemsCheckTask is skipped because database check is blocked. 16 MCMS 2002 Migration Medium Pre-migration analysis: SubmittedItemsCheckTask is skipped because database check is blocked. 17 MCMS 2002 Migration Medium Pre-migration analysis: DeletedItemsCheckTask is skipped because database check is blocked. 18 MCMS 2002 Migration Medium Pre-migration analysis: UserCheckTask is skipped because database check is blocked. 19 MCMS 2002 Migration Medium Pre-migration analysis: FileSizeCheckTask is skipped because database check is blocked. 20 MCMS 2002 Migration Medium Pre-migration analysis: HostHeaderMapCheckTask is skipped because database check is blocked. 21 MCMS 2002 Migration Verbose Start Server check 22 MCMS 2002 Migration Verbose End Server check 23 MCMS 2002 Migration Verbose Start Server emptyness check 24 MCMS 2002 Migration Verbose End Server emptyness check 25 MCMS 2002 Migration Medium PreMigrationAnalyzer: Dry run starts 26 MCMS 2002 Migration Verbose CleanLockProcedure: start. 27 MCMS 2002 Migration High CleanLockProcedure: connection system lock is null 28 MCMS 2002 Migration Verbose Finished all tasks 29 MCMS 2002 Migration High PreMigrationAnalyzer ends with True 30 MCMS 2002 Migration Verbose Migration profile status is changed to AnalysisPassed
具体而言，在运行迁移前分析或运行迁移configuration文件时，第4行和第5行中的两个高级警报将作为警告反映在迁移报告中。 另外，另外两个警告出现在迁移报告中，表明包含数据的两个表格（ LayoutProperty和NodeLayout ）应该是空的。 根据文件，警告不足以阻止移民的发生。 其他exception在第7-20行，表示skipped because database check is blocked.而被skipped because database check is blocked.的一系列testingskipped because database check is blocked. ULS没有给出任何额外的警告，表明数据库检查在特殊情况下被阻止或退出。
从预迁移分析切换到导出后 ，有一个中等级别的警告： LastChangeTime is not set or incorrect. (null) LastChangeTime is not set or incorrect. (null) 。 与警告中的所有跳过的testing名称和SQL表名一样，主要search引擎无法（除了LayoutProperty ）find对这些对象或testing的引用。
最后，表示实际实时迁移尝试的日志部分如下所示：
01 MCMS 2002 Migration Medium LastChangeTime is not set or incorrect. (null) 02 MCMS 2002 Migration Verbose Set export lock 03 MCMS 2002 Migration Verbose CleanLockProcedure: start. 04 MCMS 2002 Migration Verbose CleanLockProcedure: end. 05 MCMS 2002 Migration Verbose Prepare for export 06 MCMS 2002 Migration Verbose Open connection... 07 MCMS 2002 Migration Verbose Create temporary stored procedures 08 MCMS 2002 Migration Verbose Create temporary tables... 09 MCMS 2002 Migration Verbose Initialize temporary tables... 10 MCMS 2002 Migration Verbose InitializeTemporaryTables: start 11 MCMS 2002 Migration Verbose Initialize export table... 12 MCMS 2002 Migration Verbose InitializeExportTable: start 13 MCMS 2002 Migration Verbose CleanLockProcedure: start. 14 MCMS 2002 Migration Verbose CleanLockProcedure: end. 15 MCMS 2002 Migration High Migration throws exception: Line 6: Incorrect syntax near ';'.. Stacktrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Publishing.Internal.Administration... 16 MCMS 2002 Migration High ....MigrationBatchCommand.ExecuteImmediate(String command) at Microsoft.SharePoint.Publishing.Internal.Administration.MigrationBatchCommand.ExecuteWaitingCommands() at Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDBSerializer.SerializeSelectedExportObject(StringCollection objectAttribs) at Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess.InitializeExportTable(ScopeType scopeType) at Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess.InitializeTemporaryTables(DateTime lastChangeTime) at Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess.InitializeDatabase(DateTime lastChangeTime, Boolean isAnalysis, SqlConnection connection) at Microsoft.SharePoint.Publishing.Internal.Admin... 17 MCMS 2002 Migration High ...stration.MigrationDataAccess.InitializeDatabase(DateTime lastChangeTime, Boolean isAnalysis) at Microsoft.SharePoint.Publishing.Administration.ContentMigration.Export(MigrationDataAccess dataAccess) at Microsoft.SharePoint.Publishing.Administration.ContentMigration.MigrateInternal(). 18 MCMS 2002 Migration Verbose MigrationProfile: GetInstance. Start. 19 MCMS 2002 Migration Verbose MigrationProfile: GetInstance. End. 20 MCMS 2002 Migration Verbose Migration profile status is changed to Failed
SQL命令parsing失败的堆栈跟踪显示在15-17行。 以下附加了一个更清晰的堆栈跟踪版本。
全堆栈跟踪：
迁移引发exception：第6行：“;”附近的语法不正确
在System.Data.SqlClient.SqlConnection.OnError（SqlExceptionexception，
布尔breakConnection）
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（
TdsParserStateObject stateObj）
在System.Data.SqlClient.TdsParser.Run（RunBehavior runBehavior，
SqlCommand cmdHandler，SqlDataReader的dataStream，BulkCopySimpleResultSet
bulkCopyHandler，TdsParserStateObject stateObj）
在System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds（String methodName，
布尔asynchronous）
在System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery（DbAsyncResult结果，
String methodName，Boolean sendToPipe）
在System.Data.SqlClient.SqlCommand.ExecuteNonQuery（）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationBatchCommand
.ExecuteImmediate（String命令）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationBatchCommand
.ExecuteWaitingCommands（）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDBSerializer
.SerializeSelectedExportObject（StringCollection objectAttribs）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess
.InitializeExportTable（ScopeType scopeType）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess
.InitializeTemporaryTables（DateTime lastChangeTime）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess
.InitializeDatabase（DateTime lastChangeTime，Boolean isAnalysis，
SqlConnection连接）
在Microsoft.SharePoint.Publishing.Internal.Administration.MigrationDataAccess
.InitializeDatabase（DateTime lastChangeTime，Boolean isAnalysis）
在Microsoft.SharePoint.Publishing.Administration.ContentMigration.Export
（MigrationDataAccess dataAccess）
在Microsoft.SharePoint.Publishing.Administration.ContentMigration
.MigrateInternal（）。
这个日志信息都没有指出parsing器检查失败的SQL命令。 我已经检查了托pipe源数据库和目标数据库的SQL服务器的查询的跟踪，但似乎都没有触发parsing失败的条件。 这似乎发生在SharePoint服务器上。
还有其他地方我应该调查，可能会告诉我在哪里可以find错误的来源？
ULS日志将包含您正在查找的数据。 将您的SharePoint日志logging转换为详细，然后开始挖掘。