Value of long text field System.Description exceeds the maximum allowed length of 1000000

[colutti]

Hello

I am running the tool to migrate WI from one tenant to another one. I am getting the following error:

Microsoft.TeamFoundation.WorkItemTracking.Client.VerbatimMessageException: TF401262: Value of long text field System.Description exceeds the maximum allowed length of 1000000. ---> System.Web.Services.Protocols.SoapException: TF401262: Value of long text field System.Description exceeds the maximum allowed length of 1000000.

Is there any way to either truncate the field or to ignore those errors and just continue the migration?

[MrHinsh]

This is the first time we have encountered this error!

It looks like these are hard database limits, but that an OnPrem TFS can have it extended. https://stackoverflow.com/questions/50990026/tf401262-value-of-long-text-field-system-description-exceeds-the-maximum-length

Do you know if your local TFS has been changed to support this?

[colutti]

I have no idea. I am migrating from Azure Devops to Azure Devops but this instance is very very old and probably it has been migrated in the past from TFS to Devops. Again, I am not sure.

What can we do in this case? I think the best solution would be to add an parameter in the config to truncate the text or ignore it.

[ovebastiansen]

My guess is that a new limit has been updated higher for those fields, but not pushed down to the libs used here so a check is stopping valid value //Ove On my phone

…

________________________________ From: Rafael Colucci ***@***.***> Sent: Thursday, January 18, 2024 4:28:28 PM To: nkdAgility/azure-devops-migration-tools ***@***.***> Cc: Subscribed ***@***.***> Subject: Re: [nkdAgility/azure-devops-migration-tools] Value of long text field System.Description exceeds the maximum allowed length of 1000000 (Discussion #1861) I have no idea. I am migrating from Azure Devops to Azure Devops but this instance is very very old and probably it has been migrated in the past from TFS to Devops. Again, I am not sure. What can we do in this case? I think the best solution would be to add an parameter in the config to truncate the text or ignore it. — Reply to this email directly, view it on GitHub<#1861 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AECK4AP6XBA2QRUIHYQCXM3YPE5RZAVCNFSM6AAAAABCAJU5NKVHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4DCNZQG4ZTC>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[colutti]

I don't think so. The error comes from the API itself: System.Web.Services.Protocols.SoapException:
Also, those work items that are failing were created in 2017 and they have never been changed since then.

My guess is that when those work itens were created the limit one and now the limit is another one.

Tomorrow when I get to work I will check if I can edit and save those work itens. If my theory is correct it should fail.

Nevertheless I think the tool should check this hard limit just to be safe. It also should provide an option for the user to fail, ignore or truncate when a field, specially description, exceeds the max length. My guess is that this tools is being using by people that haave the same scenario that I do: migrate an really old instance to a new one.

[MrHinsh]

We are using the old API to maintain support for more versions of TFS.

It's very possible the limit is higher in the new API...

[colutti]

OK, thanks you for you help

What can I do to fix it?

[MrHinsh]

We would need to add a string truncate options to the system

[MrHinsh]

#1903