我正在尝试使用MOSS Central Administration的操作空间中的Manage Microsoft Content Management Server Migration Profiles工具将数据从Microsoft Content Management Server (MCMS) 2002实例迁移到新的Microsoft Office Sharepoint Server (MOSS) 2007安装中。
在分析配置文件时，我收到 4 个警告，所有这些都可以安全地忽略，但是当我实际执行迁移配置文件时，我收到相同的警告和一个附加错误，描述如下：
Line 6: Incorrect syntax near ';'.
我在 SQL Server 中闲逛时多次看到此错误并将其识别为 Transact SQL 错误消息，但找不到正在执行的实际 SQL 语句，因此我可以确定错误的来源。
编辑：在MCMS 2002 迁移类别上启用详细日志记录并仔细研究统一日志记录服务 (ULS)日志后，我在错误点收到了更完整的堆栈跟踪，以及下面列出的更多异常情况。
异常情况： 以下是迁移前分析期间 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
具体来说，在运行迁移前分析或运行迁移配置文件时，第 4 行和第 5 行上的两个高级警报作为警告反映在迁移报告中。此外，迁移报告中还会出现另外两个警告，指出两个表包含应该为空的数据 (LayoutProperty和)。NodeLayout根据文档，警告不足以阻止迁移的发生。其他异常在第 7-20 行，表明一系列测试是skipped because database check is blocked. ULS 没有给出任何额外的警告来表明数据库检查在异常情况下被阻止或退出。
将配置文件从迁移前分析切换到导出后，会出现一个中等级别的警告LastChangeTime is not set or incorrect. (null)。与警告中所有跳过的测试名称和 SQL 表名称一样，主要搜索引擎无法（除了LayoutProperty）找到对这些对象或测试的任何引用。
最后，指示实际实时迁移尝试的日志部分附加在下面：
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 命令解析失败的堆栈跟踪出现在第 15-17 行。下面附加了更简洁的堆栈跟踪版本。
全栈跟踪：
迁移引发异常：第 6 行：';' 附近的语法不正确..
在 System.Data.SqlClient.SqlConnection.OnError（SqlException 异常，
布尔中断连接）
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（
TdsParserStateObject stateObj)
在 System.Data.SqlClient.TdsParser.Run（RunBehavior 运行行为，
SqlCommand cmdHandler、SqlDataReader 数据流、BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds（字符串方法名，
布尔异步）
在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery（DbAsyncResult 结果，
字符串方法名，布尔型 sendToPipe)
在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
在 Microsoft.SharePoint.Publishing.Internal.Administration.MigrationBatchCommand
.ExecuteImmediate（字符串命令）
在 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
（迁移数据访问数据访问）
在 Microsoft.SharePoint.Publishing.Administration.ContentMigration
.MigrateInternal()。
此日志信息均未指示未通过解析器检查的 SQL 命令。我已经检查了托管源数据库和目标数据库的 SQL 服务器以获取查询跟踪，但似乎都没有触发解析失败条件。这似乎发生在 SharePoint 服务器上。
是否还有其他我应该调查的位置可能会告诉我在哪里可以找到错误的根源？