Error - Changing Maximum Length on Text Field

(0) Share

Report

Posted on by stuart

2,080

I have a Single Line of Text field on an entity that is currently set to Maximum Length 255. If I try and increase it to 500 I get an error dialog with the error text as follows

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.IndexOutOfRangeException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #52F94B79Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>System.IndexOutOfRangeException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #52F94B79</Message>
<Timestamp>2015-07-29T07:24:04.5132535Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>

Anyone had something similar and know how to resolve?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Hikmat Daghestani 170 on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

I had a similar problem. It appears that my problematic field was related to another similar field in another form through a process that copies the content.

Make sure the field you're working on is not related to another field in CRM, in case it is, make sure the other field has the same maximal length.

I hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

Same here wit CRM 2016 v8.0.1.79 on-premises

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

And I'm getting this on a text field in CRM Online 2016 when just trying to change from 5 characters to 10 characters.

Was this reply helpful? Yes No
GailM on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

Hi Saroj,

I'm having a similar problem but with the bru_name field. Date Type = Single line of text, Format = Text, Maximum Length = 100.

I cannot increase this maximum length to 101. I can, however modify it to 99 for example and then back to 100. Unfortunately, not able to 150.

I hope you can help me with this.

Kind regards,

Gail

Was this reply helpful? Yes No
Suggested answer

Jharana Baliyar Singh 2,667 on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

Hi Stuart,

We can change maximum length up to 4000 characters as if you select formats as Email, Text, Text Area, URL and Ticker Symbol and Phone.Please check below links:

msdynamicscrmblog.wordpress.com/.../types-of-fields-in-dynamics-crm-2013

www.greytrix.com/.../changing-max-allowable-length-of-text-field-using-jquery

Thanks,

Jharana B.Singh

Was this reply helpful? Yes No
Suggested answer

Saroj Das 3,355 on at

Like (4)

Report

RE: Error - Changing Maximum Length on Text Field

Hello,

The Single line of text field has different formats,(Text, Text Area, Phone, Email etc.). So If you are using Text format, it will take maximum 450 characters but for Text Area, it will accept maximum 4000 characters.

Hope this help.

Thanks,

Saroj

Was this reply helpful? Yes No
Larry McCoy on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

I've had a similar issue. I've tried to increase the field length on several built-in fields on the Contact entity. I need to "Assistant Name", "Spouse Name" and "Assistant Phone" to be longer than 100 characters. When I try to update the field length, I get this error: "System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error". I am able to set them to less than 100 characters, but any value over 100 causes the error.

Was this reply helpful? Yes No
JDMCRM 1,799 on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

Yeah that definitely wouldn't be ideal. Hopefully someone will have a solution.

Was this reply helpful? Yes No
stuart 2,080 on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

Thanks - same error when I try different amounts. I know I could create a new field and copy old values across and update all my workflows and processes etc etc but it seems a bit of a ball ache to have to do this. Never personally seen this before - on other fields I've always been able to do this without issue.

Was this reply helpful? Yes No
JDMCRM 1,799 on at

Like (0)

Report

RE: Error - Changing Maximum Length on Text Field

I haven't come across this issue. A couple of things, have you tried making the Maximum Length larger than 500, say 900 or 1500? Same error?

Another possibility, depending on how many records you have, could be to recreate the field yourself and set up an on-demand workflow that populates the new field with the data from the old field for all of your records within that entity.

Was this reply helpful? Yes No