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

Notifications

Announcements

No record found.

News and Announcements icon
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,006

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 49,438 User Group Leader on at

    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,006 on at

    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

    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

    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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans