问题从TFS 2010升级到TFS 2012 RC [英] Problem Upgrading from TFS 2010 to TFS 2012 RC
问题描述
我们有5个TFS 2010项目集合，4个已成功升级到TFS 2012 RC。 1个失败的集合恰好是最初从TFS 2008升级到TFS 2010的集合。 错误 在
Core Framework 流程中有详细信息; 执行以下脚本时发生错误：upd_SecuritySnapshotToDev11RC1.sql。第3行开始批处理失败。语句行：17。脚本行：19。错误：1911目标表或视图中不存在列名'PartitionId'
。 我无处可去，并且非常感谢任何有用的建议。
We have 5 TFS 2010 project Collections and 4 were successfully upgraded to TFS 2012 RC. The 1 collection that failed happened to be the one originally upgraded from TFS 2008 to TFS 2010. The Error was in the Core Framework process with this detail; An error occurred while executing the following script: upd_SecuritySnapshotToDev11RC1.sql. Failed batch starts on the line 3. Statement line: 17. Script line: 19. Error: 1911 Column name 'PartitionId' does not exist in the target table or view. I have nowhere to go on this one and will greatly appreciate for any helpful advice.
以下是日志摘录;
  ++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++ 11：33：14.477]跳过步骤：前导键 - 转换快照表。
[11：33：14.477] +++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++ ：33：14.477]鸟;  Step Performer：Framework.ExecuteSql
[11：33：14.477] 步骤数据文本：< SqlStepData category =" Framework"资源= QUOT; upd_LocationCommonToDev11RC1.sql; FrameworkSharedToDev11RC1.sql; FrameworkCommonToDev11RC1.sql; FrameworkCollectionToDev11RC1.sql; upd_FrameworkCollectionLeadingKey.sql; upd_SecuritySharedToDev11RC1.sql; upd_SecuritySnapshotToDev11RC1.sql; upd_OAuthCommonToDev11RC1.sql; upd_RegistryToDev11RC1.sql">< SetServiceVersion
服务= QUOT;指挥QUOT;版本= QUOT; 2英寸类别= QUOT;框架" />< SetServiceVersion service =" ConnectedService"版本= QUOT 1 QUOT;类别= QUOT;框架" />< SetServiceVersion service =" DatabasePartition"版本= QUOT 1 QUOT;类别= QUOT;框架" />< SetServiceVersion service =" Location"
version =" 4" />< SetServiceVersion service =" MessageQueue"版本= QUOT; 3英寸类别= QUOT;框架" />< SetServiceVersion service =" RecordListener"版本= QUOT; 2英寸/>< SetServiceVersion service ="注册"版本= QUOT; 2英寸/>< SetServiceVersion service =" Job"
version =" 4" />< SetServiceVersion service =" Signing"版本= QUOT; 2英寸类别= QUOT;框架" />< SetServiceVersion service =" SendMail"版本= QUOT; 2英寸类别= QUOT;框架" />< SetServiceVersion service =" Event"版本= QUOT; 3英寸类别= QUOT;框架" /><< SetServiceVersion
service =" EventNotification"版本= QUOT; 3英寸类别= QUOT;框架" />< SetServiceVersion service =" Security"版本= QUOT; 4英寸类别= QUOT;框架" />< SetServiceVersion service =" ProcessTemplate"版本= QUOT; 3英寸类别= QUOT;框架" />< SetServiceVersion service =" OAuth"
version =" 2"类别= QUOT;框架" />< SetServiceVersion service =" Property"版本= QUOT; 2英寸类别= QUOT;框架" />< SetServiceVersion service =" IdentityMap"版本= QUOT; 2英寸类别= QUOT;框架" />< SetServiceVersion service =" StrongBox"版本= QUOT; 2英寸类别= QUOT;框架"
/>< SetServiceVersion service =" Locking"版本= QUOT; 3英寸类别= QUOT;框架" />< SetServiceVersion service =" File"版本= QUOT; 4英寸类别= QUOT;框架" />< SetServiceVersion service =" Registry"版本= QUOT; 2英寸类别= QUOT;框架" />< SetServiceVersion
service =" ServicingHistory"版本= QUOT 1 QUOT;类别= QUOT;框架" />< SetServiceVersion service =" Servicing"版本= QUOT; -1"类别= QUOT;框架" />< SetServiceVersion service =" ResourceManagement"版本= QUOT; 2英寸类别= QUOT;框架" /><< SetServiceVersion
service =" FileContent"版本= QUOT; 2英寸类别= QUOT;框架" />< / SqlStepData>
[11：33：14.477] 步骤数据：DatabaseCategory =>框架
[11：33：14.477] 步骤数据：SqlResource => upd_LocationCommonToDev11RC1.sql; FrameworkSharedToDev11RC1.sql; FrameworkCommonToDev11RC1.sql; FrameworkCollectionToDev11RC1.sql; upd_FrameworkCollectionLeadingKey.sql; upd_SecurityShaapshotToDev11RC1.sql; upd_SecuritySnapshotToDev11RC1.sql; upd_OAuthCommonToDev11RC1.sql; upd_RegistryToDev11RC1.sql
[11：33：14.477] &NBSP;&NBSP;步骤数据：BatchTimeout => -1
[11：33：14.477] 步骤数据：参数=>
[11：33：14.477] 步骤数据：RequiresExclusiveDatabaseLock =>错误
[11：33：14.477] 步骤数据：数据库=>
[11：33：14.477] 步骤数据：AcquireLock =>错误
[11：33：14.477] 步骤数据：服务=> Microsoft.TeamFoundation.Server.Servicing.TFCollection.SetServiceVersionStepData []
[11：33：14.477] 检索脚本花了2毫秒左右b $ b [b：11：33：21.913] SQL信息：重新创建没有HostId的PK_tbl_AccessMapping
[11：33：21.913] 从tbl_AccessMapping中删除列HostId。
[11：33：21.913] 将IX_tbl_ServiceDefinition_HostId_ServiceType_Identifier重命名为PK_tbl_ServiceDefinition
[11：33：21.913] 警告：更改对象名称的任何部分可能会破坏脚本和存储过程。
[11：33：21.913] 在没有HostId的情况下重新创建PK_tbl_ServiceDefinition
[11：33：21.913] 从tbl_ServiceDefinition删除列HostId。
[11：33：21.913] 模块'prc_iiCloneSecurity'取决于缺少的对象'prc_pRenameToken'。该模块仍将创建;但是，在对象存在之前，它无法成功运行。
[11：33：21.913] 模块'prc_iiRenameTokens'取决于缺少的对象'prc_iiSecurityUpdateLock'。该模块仍将创建;但是，在对象存在之前，它无法成功运行。
[11：33：21.913] 模块'prc_pRenameToken'取决于缺少的对象'prc_pRenameTokens'。该模块仍将创建;但是，在对象存在之前，它无法成功运行。
[11：33：21.913] 模块'prc_pSetAccessControlEntry'取决于缺少的对象'prc_pSetAccessControlLists'。该模块仍将创建;但是，在对象存在之前，它无法成功运行。
[11：33：21.913] 模块'prc_iiConfigureAccessMapping'取决于缺少的对象'prc_iiLogLocationChange'。该模块仍将创建;但是，在对象存在之前，它无法成功运行。
[11：33：21.913] 警告！最大密钥长度为900字节。索引'PK __＃7D39AAE__8CD42C8A01FE6003'的最大长度为1040字节。对于某些较大值的组合，插入/更新操作将失败。
[11：33：21.913] 警告！最大密钥长度为900字节。索引'PK __＃03E6A87__8CD42C8A05CEF0E7'的最大长度为1040字节。对于某些较大值的组合，插入/更新操作将失败。
[11：33：21.913] 删除tbl_server_status
[11：33：21.913] 在没有ServiceHostId的情况下重新创建IX_tbl_SecurityAccessControlEntry为
[11：33：21.913] 从tbl_SecurityAccessControlEntry中删除ServiceHostId列。
[11：33：21.913] 重新创建没有ServiceHostId的IX_tbl_SecurityTokenDelta
[11：33：21.913] 从tbl_SecurityTokenDelta中删除ServiceHostId列。
[11：33：21.913] 重新创建没有ServiceHostId的IX_tbl_SecurityInheritance
[11：33：21.913] 从tbl_SecurityInheritance中删除ServiceHostId列。
[11：33：21.913] 重新创建没有ServiceHostId的IX_tbl_SnapshotInstanceSecurityACEData
[11：33：21.913] [错误]执行以下脚本时发生错误：upd_SecuritySnapshotToDev11RC1.sql。第3行开始批处理失败。语句行：17。脚本行：19。错误：1911目标表或视图中的列名'PartitionId'不存在
。
[11：33：21.947] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException：执行以下脚本时发生错误：upd_SecuritySnapshotToDev11RC1.sql。第3行开始批量启动失败。语句行：
17.脚本行：19。错误：1911目标表或视图中不存在列名'PartitionId'。
[11 ：33：21.947]鸟;&NBSP;&NBSP;&NBSP;&NBSP;在Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteScripts（List`1脚本，SqlParameter [] sqlParameters，List`1 serviceVersions，Boolean acquireLock）
[11：33：21.947] &NBSP;&NBSP;&NBSP;在Microsoft.TeamFoundation.Server.Servicing.TFCollection.FrameworkStepPerformer.ExecuteSql（String stepData，ServicingContext servicingContext）
[11：33：21.947] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep（String servicingOperation，String stepType，String stepData，ServicingContext
servicingContext）
[11： 33：21.947]鸟;&NBSP;&NBSP;&NBSP;&NBSP;在Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep（ServicingStep步骤，ServicingContext servicesContext，ServicingStepGroup组，ServicingOperation servicingOperation）
[11：33：21.947]步骤失败：前导键 - 完成。执行时间：7秒。
[11：33：23.540] 删除项目。密钥：TargetRequestContext。
[11：33：23.540] 清除字典，删除所有项目。
[08：17：58.467] 创建包含2个初始项目的字典：
[08：17：58.467] CollectionProperties => 4c4381bd-67c5-4147-96a9-62a599845e7d（XXXXCollection）
[08：17：58.467] RequestingIdentity => IdentityDescriptor（IdentityType：System.Security.Principal.WindowsIdentity; Identifier：S-1-5-21-2466626570-1323649411-3792354178-1002）
[08：17：58.467] 获取维修作业锁'Servicing-4c4381bd-67c5-4147-96a9-62a599845e7d'
$
[08：17：58.593] 设置令牌。关键：JobId。价值：bd53683f-bc05-4a92-ad9b-9f7f23a3bece。
[08：18：04.170] 设定项目。密钥：TargetRequestContext。值：Microsoft.TeamFoundation.Framework.Server.TeamFoundationRequestContext。
[08：18：04.327] 在Tfs_Configuration数据库上将TFS_SERVICE_LEVEL设置为"Dev11.RC1"。
[08：18：07.993] 在XXXXCollection数据库上将TFS_SERVICE_LEVEL设置为"Tfs2010.SP1.KB2182621.P＃1"。
[08：18：08.070] 设置令牌。密钥：ServiceLevelFrom。价值：Tfs2010.SP1.KB2182621。
[08：18：09.640] [错误] TF30040：数据库配置不正确。联系您的Team Foundation Server管理员。
[08：18：09.773] Microsoft.TeamFoundation.Framework.Server.DatabaseConfigurationException：TF30040：未正确配置数据库。联系您的Team Foundation Server管理员。 ---> System.Data.SqlClient.SqlException：过程
或函数'prc_QueryRegistry'需要参数
'@ partitionId'，这是未提供的。$
[08：18：09.773] at System.Data.SqlClient.SqlConnection.OnError（SqlException exception，Boolean breakConnection，Action`1 wrapCloseInAction）
[08：18：09.773] 在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning（TdsParserStateObject stateObj，Boolean callerHasConnectionLock，Boolean asyncClose）
[08：18：09.773] 在System.Data.SqlClient.TdsParser.TryRun（RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj，Boolean& dataReady）
[08:18:09.773] ;&NBSP;&NBSP;在System.Data.SqlClient.SqlDataReader.TryConsumeMetaData（）
[08：18：09.773] at System.Data.SqlClient.SqlDataReader.get_MetaData（）
[08：18：09.773] 在System.Data.SqlClient.SqlCommand.FinishExecuteReader（SqlDataReader ds，RunBehavior runBehavior，String resetOptionsString）
[08：18：09.773] 在System.Data.SqlClient.SqlCommand.RunExecuteReaderTds（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，Boolean async，Int32 timeout，Task& task，Boolean asyncWrite）
[08：18：09.773] &NBSP;&NBSP;&NBSP;&NBSP;在System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String方法，TaskCompletionSource`1完成，Int32超时，任务和任务，布尔
asyncWrite）
[08：18：09.773]鸟;&NBSP;&NBSP;&NBSP;&NBSP;在System.Data.SqlClient.SqlCommand.RunExecuteReader（CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，String method）
[08：18：09.773] 在System.Data.SqlClient.SqlCommand.ExecuteReader（CommandBehavior behavior，String method）
[08：18：09.773] 在System.Data.SqlClient.SqlCommand.ExecuteReader（CommandBehavior behavior）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute（ExecuteType executeType，CommandBehavior behavior）
[08：18：09.773] ---内部异常堆栈跟踪结束---
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException（Int32 errorNumber，SqlException sqlException，SqlError sqlError）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException（SqlException sqlException）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException（SqlException ex，QueryExecutionState queryState）
[08：18：09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException（异常例外）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute（ExecuteType executeType，CommandBehavior behavior）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.RegistryComponent.QueryRegistry（Int32 partitionId，String registryPath）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationBaseRegistryService.ReadEntriesInternal（TeamFoundationRequestContext requestContext，String completeRegistryPath）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationBaseRegistryService.ReadEntries（TeamFoundationRequestContext requestContext，String registryPathPattern，Boolean includeFolders）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationBaseRegistryService.ReadEntriesFallThru（TeamFoundationRequestContext requestContext，String registryPathPattern）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.GetConnectionDefaults（TeamFoundationRequestContext requestContext）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.LoadDatabaseSettings（TeamFoundationRequestContext requestContext，String databaseCategory）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.GetDatabaseSettings（TeamFoundationRequestContext requestContext，String category）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.ReadSettings（TeamFoundationRequestContext requestContext，String databaseCategory，AccessIntent intent）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Initialize（TeamFoundationRequestContext requestContext，String databaseCategory，Int32 serviceVersion）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.DatabaseServicingProvider.CreateServicingHistoryComponent（ServicingContext servicingContext）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.DatabaseServicingProvider.Microsoft.TeamFoundation.Framework.Server.IServicingStepGroupExecutionHandler.StartStepGroup（ServicingContext servicingContext，ServicingOperation
servicingOperation，ServicingStepGroup stepGroup，Boolean validating）
[08： 18：09.773]鸟;&NBSP;&NBSP;&NBSP;&NBSP;在Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.StartStepGroup（ServicingOperation servicingOperation，ServicingStepGroup stepGroup）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformOperations（Int32 stepsToPerform）
[08：18：09.773] 在Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.Execute（Int32 numberOfStepsToPerform）
[08：18：09.863] 删除项目。 Key：TargetRequestContext。
[08：18：09.867] 清除字典，删除所有项目。
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[11:33:14.477] Step skipped: Leading Key - Transform snapshot tables.
[11:33:14.477] +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[11:33:14.477] Executing step: Leading Key - Finalize
[11:33:14.477] Step Performer: Framework.ExecuteSql
[11:33:14.477] Step Data Text: <SqlStepData category="Framework" resource="upd_LocationCommonToDev11RC1.sql;FrameworkSharedToDev11RC1.sql;FrameworkCommonToDev11RC1.sql;FrameworkCollectionToDev11RC1.sql;upd_FrameworkCollectionLeadingKey.sql;upd_SecuritySharedToDev11RC1.sql;upd_SecuritySnapshotToDev11RC1.sql;upd_OAuthCommonToDev11RC1.sql;upd_RegistryToDev11RC1.sql"><SetServiceVersion
service="Command" version="2" category="Framework" /><SetServiceVersion service="ConnectedService" version="1" category="Framework" /><SetServiceVersion service="DatabasePartition" version="1" category="Framework" /><SetServiceVersion service="Location"
version="4" /><SetServiceVersion service="MessageQueue" version="3" category="Framework" /><SetServiceVersion service="RecordListener" version="2" /><SetServiceVersion service="Registration" version="2" /><SetServiceVersion service="Job"
version="4" /><SetServiceVersion service="Signing" version="2" category="Framework" /><SetServiceVersion service="SendMail" version="2" category="Framework" /><SetServiceVersion service="Event" version="3" category="Framework" /><SetServiceVersion
service="EventNotification" version="3" category="Framework" /><SetServiceVersion service="Security" version="4" category="Framework" /><SetServiceVersion service="ProcessTemplate" version="3" category="Framework" /><SetServiceVersion service="OAuth"
version="2" category="Framework" /><SetServiceVersion service="Property" version="2" category="Framework" /><SetServiceVersion service="IdentityMap" version="2" category="Framework" /><SetServiceVersion service="StrongBox" version="2" category="Framework"
/><SetServiceVersion service="Locking" version="3" category="Framework" /><SetServiceVersion service="File" version="4" category="Framework" /><SetServiceVersion service="Registry" version="2" category="Framework" /><SetServiceVersion
service="ServicingHistory" version="1" category="Framework" /><SetServiceVersion service="Servicing" version="-1" category="Framework" /><SetServiceVersion service="ResourceManagement" version="2" category="Framework" /><SetServiceVersion
service="FileContent" version="2" category="Framework" /></SqlStepData>
[11:33:14.477] Step Data: DatabaseCategory => Framework
[11:33:14.477] Step Data: SqlResource => upd_LocationCommonToDev11RC1.sql;FrameworkSharedToDev11RC1.sql;FrameworkCommonToDev11RC1.sql;FrameworkCollectionToDev11RC1.sql;upd_FrameworkCollectionLeadingKey.sql;upd_SecuritySharedToDev11RC1.sql;upd_SecuritySnapshotToDev11RC1.sql;upd_OAuthCommonToDev11RC1.sql;upd_RegistryToDev11RC1.sql
[11:33:14.477] Step Data: BatchTimeout => -1
[11:33:14.477] Step Data: Parameters =>
[11:33:14.477] Step Data: RequiresExclusiveDatabaseLock => False
[11:33:14.477] Step Data: Database =>
[11:33:14.477] Step Data: AcquireLock => False
[11:33:14.477] Step Data: Services => Microsoft.TeamFoundation.Server.Servicing.TFCollection.SetServiceVersionStepData[]
[11:33:14.477] It took 2 ms to retrieve script(s)
[11:33:21.913] SQL Info: Recreating PK_tbl_AccessMapping without HostId
[11:33:21.913] Dropping column, HostId, from tbl_AccessMapping.
[11:33:21.913] Renaming IX_tbl_ServiceDefinition_HostId_ServiceType_Identifier to PK_tbl_ServiceDefinition
[11:33:21.913] Caution: Changing any part of an object name could break scripts and stored procedures.
[11:33:21.913] Recreating PK_tbl_ServiceDefinition without HostId
[11:33:21.913] Dropping column, HostId, from tbl_ServiceDefinition.
[11:33:21.913] The module 'prc_iiCloneSecurity' depends on the missing object 'prc_pRenameToken'. The module will still be created; however, it cannot run successfully until the object exists.
[11:33:21.913] The module 'prc_iiRenameTokens' depends on the missing object 'prc_iiSecurityUpdateLock'. The module will still be created; however, it cannot run successfully until the object exists.
[11:33:21.913] The module 'prc_pRenameToken' depends on the missing object 'prc_pRenameTokens'. The module will still be created; however, it cannot run successfully until the object exists.
[11:33:21.913] The module 'prc_pSetAccessControlEntry' depends on the missing object 'prc_pSetAccessControlLists'. The module will still be created; however, it cannot run successfully until the object exists.
[11:33:21.913] The module 'prc_iiConfigureAccessMapping' depends on the missing object 'prc_iiLogLocationChange'. The module will still be created; however, it cannot run successfully until the object exists.
[11:33:21.913] Warning! The maximum key length is 900 bytes. The index 'PK__#7D39AAE__8CD42C8A01FE6003' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail.
[11:33:21.913] Warning! The maximum key length is 900 bytes. The index 'PK__#03E6A87__8CD42C8A05CEF0E7' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail.
[11:33:21.913] Dropping tbl_server_status
[11:33:21.913] Recreating IX_tbl_SecurityAccessControlEntry without ServiceHostId
[11:33:21.913] Dropping column, ServiceHostId, from tbl_SecurityAccessControlEntry.
[11:33:21.913] Recreating IX_tbl_SecurityTokenDelta without ServiceHostId
[11:33:21.913] Dropping column, ServiceHostId, from tbl_SecurityTokenDelta.
[11:33:21.913] Recreating IX_tbl_SecurityInheritance without ServiceHostId
[11:33:21.913] Dropping column, ServiceHostId, from tbl_SecurityInheritance.
[11:33:21.913] Recreating IX_tbl_SnapshotInstanceSecurityACEData without ServiceHostId
[11:33:21.913] [Error] An error occurred while executing the following script: upd_SecuritySnapshotToDev11RC1.sql. Failed batch starts on the line 3. Statement line: 17. Script line: 19. Error: 1911 Column name 'PartitionId' does not exist
in the target table or view.
[11:33:21.947] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: An error occurred while executing the following script: upd_SecuritySnapshotToDev11RC1.sql. Failed batch starts on the line 3. Statement line:
17. Script line: 19. Error: 1911 Column name 'PartitionId' does not exist in the target table or view.
[11:33:21.947] at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteScripts(List`1 scripts, SqlParameter[] sqlParameters, List`1 serviceVersions, Boolean acquireLock)
[11:33:21.947] at Microsoft.TeamFoundation.Server.Servicing.TFCollection.FrameworkStepPerformer.ExecuteSql(String stepData, ServicingContext servicingContext)
[11:33:21.947] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext
servicingContext)
[11:33:21.947] at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation)
[11:33:21.947] Step failed: Leading Key - Finalize. Execution time: 7 seconds.
[11:33:23.540] Removing item. Key: TargetRequestContext.
[11:33:23.540] Clearing dictionary, removing all items.
[08:17:58.467] Creating dictionary with 2 initial items:
[08:17:58.467] CollectionProperties => 4c4381bd-67c5-4147-96a9-62a599845e7d (XXXXCollection)
[08:17:58.467] RequestingIdentity => IdentityDescriptor (IdentityType: System.Security.Principal.WindowsIdentity; Identifier: S-1-5-21-2466626570-1323649411-3792354178-1002)
[08:17:58.467] Acquiring servicing job lock 'Servicing-4c4381bd-67c5-4147-96a9-62a599845e7d'
[08:17:58.593] Setting token. Key: JobId. Value: bd53683f-bc05-4a92-ad9b-9f7f23a3bece.
[08:18:04.170] Setting item. Key: TargetRequestContext. Value: Microsoft.TeamFoundation.Framework.Server.TeamFoundationRequestContext.
[08:18:04.327] TFS_SERVICE_LEVEL is set to 'Dev11.RC1' on Tfs_Configuration database.
[08:18:07.993] TFS_SERVICE_LEVEL is set to 'Tfs2010.SP1.KB2182621.P#1' on XXXXCollection database.
[08:18:08.070] Setting token. Key: ServiceLevelFrom. Value: Tfs2010.SP1.KB2182621.
[08:18:09.640] [Error] TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator.
[08:18:09.773] Microsoft.TeamFoundation.Framework.Server.DatabaseConfigurationException: TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator. ---> System.Data.SqlClient.SqlException: Procedure
or function 'prc_QueryRegistry' expects parameter
'@partitionId', which was not supplied.
[08:18:09.773] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[08:18:09.773] at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
[08:18:09.773] at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
[08:18:09.773] at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
[08:18:09.773] at System.Data.SqlClient.SqlDataReader.get_MetaData()
[08:18:09.773] at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
[08:18:09.773] at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
[08:18:09.773] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean
asyncWrite)
[08:18:09.773] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
[08:18:09.773] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
[08:18:09.773] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
[08:18:09.773] --- End of inner exception stack trace ---
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(Exception exception)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.RegistryComponent.QueryRegistry(Int32 partitionId, String registryPath)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationBaseRegistryService.ReadEntriesInternal(TeamFoundationRequestContext requestContext, String completeRegistryPath)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationBaseRegistryService.ReadEntries(TeamFoundationRequestContext requestContext, String registryPathPattern, Boolean includeFolders)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationBaseRegistryService.ReadEntriesFallThru(TeamFoundationRequestContext requestContext, String registryPathPattern)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.GetConnectionDefaults(TeamFoundationRequestContext requestContext)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.LoadDatabaseSettings(TeamFoundationRequestContext requestContext, String databaseCategory)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.GetDatabaseSettings(TeamFoundationRequestContext requestContext, String category)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationDatabaseSettings.ReadSettings(TeamFoundationRequestContext requestContext, String databaseCategory, AccessIntent intent)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Initialize(TeamFoundationRequestContext requestContext, String databaseCategory, Int32 serviceVersion)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.DatabaseServicingProvider.CreateServicingHistoryComponent(ServicingContext servicingContext)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.DatabaseServicingProvider.Microsoft.TeamFoundation.Framework.Server.IServicingStepGroupExecutionHandler.StartStepGroup(ServicingContext servicingContext, ServicingOperation
servicingOperation, ServicingStepGroup stepGroup, Boolean validating)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.StartStepGroup(ServicingOperation servicingOperation, ServicingStepGroup stepGroup)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformOperations(Int32 stepsToPerform)
[08:18:09.773] at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.Execute(Int32 numberOfStepsToPerform)
[08:18:09.863] Removing item. Key: TargetRequestContext.
[08:18:09.867] Clearing dictionary, removing all items.
推荐答案
您好pogican，
Hi pogican,
感谢您的提问。
我试图让熟悉这个话题的人参与进一步研究这个问题。可能会有一些时间延迟。感谢您的耐心等待。
I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.
感谢您的理解和支持。
祝你好运，
这篇关于问题从TFS 2010升级到TFS 2012 RC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
