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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / String truncation issu...
Microsoft Dynamics AX (Archived)
Answered

String truncation issue, after changing the size

(0) ShareShare
ReportReport
Posted on by krishna.rao@dax 3,002

Hello,

I've changed the Extended data type "RetailVariantId" size from 10 to 30. Done sync db.

Prior to this, data exists in the system.

Experiencing weird behaviour in the system(Not always). 

1. Entering field more than size 10, giving error( SQL error description: [Microsoft][SQL Server Native Client 11.0]String data, right truncation). However accepting the values.

2. open the form second time(after few minutes saving the entries), the string is truncated to size 10.

3. Open the form, next day value displays actual (not truncated).

Requesting you to share your experience to resolve this .

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 48,893 User Group Leader on at
    RE: Sting truncation issue, after changing the size

    it seems a random behavior, seems database is not synchronized properly. have you given a try to full Database synchronization?

    note that usually increasing length should not be an issue, as long as you finish DB synch successfully. reducing length can be a disaster.

    I would recommend you full database sych and fix all issues of synch. As you may be aware that if any EDT is being used in any of views which are based on union queries the corresponding field of union query from other datasoucre should be of same length, as the one you are modifying. This is a very common mistake done by developers while changing length of edt(s)

  • krishna.rao@dax Profile Picture
    krishna.rao@dax 3,002 on at
    RE: Sting truncation issue, after changing the size

    Thanks Sohaib, I'll do the full db sync .

    BTW, other folks may drop their valuable suggestions.

  • Dimas Ayala Profile Picture
    Dimas Ayala 5 on at
    RE: String truncation issue, after changing the size

    I had a similar issue and the problem was I modified a field in a table, that was used in a map that combine with other tables. The solution was to set the same EDT to all related tables in the MAP.

  • ES-Morten Profile Picture
    ES-Morten 12 on at
    RE: String truncation issue, after changing the size

    Full sync + AOS restart seemed to do the trick for me.

    Edit: typo

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans