web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Contact Last Name att...
Microsoft Dynamics CRM (Archived)

Contact Last Name attribute limitations?

(1) ShareShare
ReportReport
Posted on by Ivaylo Moshekov

Hi everyone,

I have increased the maximum length of last name attribute in Contact to 210.

Upon creating a new contact with last name greater than 150 symbols I get a generic SQL error. I tried tracing and the actual error is "Crm Exception: Message: Generic SQL error., ErrorCode: -2147204784, InnerException: System.Data.SqlClient.SqlException (0x80131904): Operation failed. The index entry of length 948 bytes for the index 'ndx_ContactCover' exceeds the maximum length of 900 bytes."

Is there any way to overcome this limitation?

Thank you in advance :)

*This post is locked for comments

I have the same question (0)
  • ashlega Profile Picture
    ashlega 34,477 on at

    Hi,

     900 is the maximum size of SQL indexes, but I am wondering why is the error happening when you are adding data (and not when you were updating the metadata for that column).. Do you have any additional "keys" defined for the contact entity where LastName attribute would be a part of the key?

  • Ivaylo Moshekov Profile Picture
    Ivaylo Moshekov on at

    Hi Alex,

    I have a key for contact entity but it does not include last name attribute. I have a feeling it has to do something with all the yomi fields but I am not sure yet

  • ashlega Profile Picture
    ashlega 34,477 on at

    Similar error here(just FYI):

    community.dynamics.com/.../158944

  • Ivaylo Moshekov Profile Picture
    Ivaylo Moshekov on at

    What if I create a plug-in to replace yomi fields with empty string on create of a contact?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans