Share
Report
10So this comes from a Stackoverflow.Com question that I answered this afternoon but I cannot figure out if this is bug or by design. In both on-premises and online the postal code field is limited to 50 characters. If you increase the size of this field the UI will allow it buy the underlying SQL field, CustomerAddressBase.PostalCode, will remain at its OOTB size of 50, and when saving a value to this field greater than 50 it throws a SQL error.
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts"> <ErrorCode>-2147204784</ErrorCode> <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" /> <Message>Generic SQL error.</Message> <Timestamp>2013-10-04T13:57:19.13039Z</Timestamp> <InnerFault i:nil="true" /> <TraceText i:nil="true" /> </OrganizationServiceFault>I would of expected if this is by design that the CRM 2011 customization UI would have prevented a user from increasing the field size, but you can increase it.
http://stackoverflow.com/questions/19184031/change-contacts-zip-postal-code-field-length/
This is in both CRM 2011 On-Premises Rollup 12 and CRM Online.
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
