迁移错误TFS 2017 RTM到2017年更新1 RC 2 [英] Migration Error TFS 2017 RTM to 2017 Update 1 RC 2

问题描述

大家好，我是b $ b我已经在2017年设立了TFS。 2017年和 得到了一些问题。

所以我试图将tfs 2017升级到Update 1 RC 2 :)
$


Systemconfig：

Hi Guys,
i have set up a TFS 2017 in jan. 2017 and  got some issues.
So i tried to upgrade the tfs 2017 to Update 1 RC 2 :)

Systemconfig:

• 操作系统：Windows Server 2012r2（最新更新）
• DBMS：SQL Server：2016 + SP1 + 2017年最后一个CU
• TFS：2017 RTM
• 语言：德语

我还安装了推荐的VC ++ Runtime - https：// support。 microsoft.com/en-us/help/3138367/update-for-visual-c-2013-and-visual-c-redistributable-package



安装更新1 RC2：

工作



TFS迁移：

Also I installed the recommed VC++ Runtime - https://support.microsoft.com/en-us/help/3138367/update-for-visual-c-2013-and-visual-c-redistributable-package

Installation Update 1 RC2:
Worked

TFS Migration:

• PreCheck - 没有错误
  
  
• 数据库迁移：错误

我恢复了配置数据库 - >相同的错误

我已将MSSQL Server语言设置为英语1033->相同的错误

我寻找更新1 RC1（可能是rc2中的新错误） - >从互联网上删除...

应该与...发生冲突本地语言设置。

I recovered the configuration database -> Same Error
I have set the MSSQL Server Language to English 1033-> Same Error
I looked for the Update 1 RC1 (maybe a new error in rc2)-> removed from the internet...
There should be a conflict with  the local language settings.

问候Jonathan

Regards Jonathan

================ Failed batch end ============================
 (Typ TeamFoundationServicingException)
Ausnahmestapelüberwachung:    bei Microsoft.TeamFoundation.Framework.Server.ServicingContext.FinishStep(Exception exception)
   bei Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Int32 stepNumber, Int32 totalSteps)
   bei Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformOperations(Int32 stepsToPerform)
   bei Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.Execute(Int32 numberOfStepsToPerform)
   bei Microsoft.TeamFoundation.Admin.UpgradeConfigDbDriver.Execute()
   bei Microsoft.TeamFoundation.Admin.ConfigureUpgradeConfigDB.Run(ActivityContext context)

Interne Ausnahmedetails:

Ausnahmemeldung: 1 error(s) occurred while executing upd_CommerceToDev15M106.sql script.
Failed batch starts on line: 22.

Error: 242, Level: 16, State: 3, Batch Line: 5, Script Line: 26
Message: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
================ Failed batch begin ==========================
-- updating billing start date for codesearch, exploratory testing and Feed.

IF NOT EXISTS(SELECT GalleryId FROM Commerce.tbl_OfferMeterDefinition WHERE GalleryId = 'ms.vss-code-search' AND BillingStartDate = '2020-10-01 20:00')
BEGIN
    UPDATE Commerce.tbl_OfferMeterDefinition SET BillingStartDate = '2016-09-22 20:00' WHERE GalleryId = 'ms.vss-code-search'
END
================ Failed batch end ============================
 (Typ SqlScriptException)
Ausnahmestapelüberwachung:    bei Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteScripts(List`1 scripts, SqlParameter[] sqlParameters, List`1 serviceVersions, Boolean acquireLock, TimeSpan maxServicingLockTime, TimeSpan maxBlockingSessionTime, Int32 sqlCommandTimeout, Boolean testRerunnability, Boolean monitorBlocking)
   bei Microsoft.VisualStudio.Services.Framework.SqlStepPerformer.ExecuteSql(ServicingContext servicingContext, ISqlConnectionInfo connectionInfo, SqlStepData sqlStepData)
   bei Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.PerformDatabaseStep(String servicingOperation, ServicingOperationTarget target, IServicingStep servicingStep, String stepData, ServicingContext servicingContext)
   bei Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.PerformStep(String servicingOperation, ServicingOperationTarget target, IServicingStep servicingStep, String stepType, String stepData, ServicingContext servicingContext)
   bei Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.PerformStep(String servicingOperation, ServicingOperationTarget target, String stepType, String stepData, ServicingContext servicingContext)
   bei Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Int32 stepNumber, Int32 totalSteps)

[Info   @12:44:54.757] Node returned: Error
[Error  @12:44:54.760] TF255356: Fehler beim Konfigurieren der Team Foundation-Datenbanken. Fehler: "TF400711: Fehler beim Ausführen von Wartungsschritt "Adding IncludedInLicense column" für Komponente CommerceOnPremToDev15M106 während ToDev15M106: 1 error(s) occurred while executing upd_CommerceToDev15M106.sql script.
Failed batch starts on line: 22.

Error: 242, Level: 16, State: 3, Batch Line: 5, Script Line: 26
Message: Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
================ Failed batch begin ==========================
-- updating billing start date for codesearch, exploratory testing and Feed.

IF NOT EXISTS(SELECT GalleryId FROM Commerce.tbl_OfferMeterDefinition WHERE GalleryId = 'ms.vss-code-search' AND BillingStartDate = '2020-10-01 20:00')
BEGIN
    UPDATE Commerce.tbl_OfferMeterDefinition SET BillingStartDate = '2016-09-22 20:00' WHERE GalleryId = 'ms.vss-code-search'
END

推荐答案

b $ b很抱歉您在升级到TFS 2017 Update 1 RC2时遇到问题。感谢报道！  '2016-09-22 20:00'不是德语和许多其他语言的有效日期。
我们将在TFS 2017 Update 1 RTW中解决此问题。

Hi,
I am sorry that you are having issue with upgrade to TFS 2017 Update 1 RC2. Thanks for reporting it!  '2016-09-22 20:00' is not a valid date in German and many other languages. We will fix this issue in TFS 2017 Update 1 RTW.

谢谢，

Thanks,

- 弗拉基米尔

这篇关于迁移错误TFS 2017 RTM到2017年更新1 RC 2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！