Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : iyyHxwMyv//nJvxaCzb7q2
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / To increase the size o...
Microsoft Dynamics AX (Archived)

To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

Like (0) ShareShare
ReportReport
Posted on 9 May 2016 14:05:16 by Daxing 155

Hello,

   Our Accounting team uses Project management and accounting module for Accounting and our version is DAX 2012 CU3 (feature pack). We have a third party application that sends Fee and Hour transactions to data via DAX services. Currently the LedgerJournalTrans.Txt (Txt column in the LedgerJournalTrans table) is of string type with size 255. This Txt field uses LedgerJournalTransTxt EDT and this again using TransTxt EDT which is of type string and allows only 255 characters. 

  They are asking to us to see if the LedgerJournalTrans.Txt can accept upto 1000 characters. If I were to increase its size then I have to increase the size of TransTxt EDT size. This has to be quick change and I need some advise if I can go ahead and increase or will there be any other things that might break because of this change? 

 

My idea is to make changes in Development environment and ask them to perform an end to end testing. Please advise.

 

Thanks,

 

Dev

*This post is locked for comments

  • Daxing Profile Picture
    Daxing 155 on 25 May 2016 at 14:29:42
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    Sohaib, Now it appears that they need to send in more data than 1000 to store in the field and asking if the size can be increased to 3000 characters. For that I need to increase the size of the TransTxt EDT to 3000 and that might make me to increase the buffer size as well. At this time the max buffer size is set to 70. Would there be any performance issues on the AOS when the max buffer size is increased to a number that can accommodate/handles the 3000 size? Thanks!

  • Verified answer
    Daxing Profile Picture
    Daxing 155 on 24 May 2016 at 20:17:41
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    Sorry forgot to update Sohaib. Yes, it had fixed the issue.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on 12 May 2016 at 14:13:27
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    you can increase max buffer size by AOS service configuration which has been kept at 48, by default due to performance reasons

  • Daxing Profile Picture
    Daxing 155 on 12 May 2016 at 14:02:16
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    TranxTxtEDTSynchronizationError.png

    Hello Sohaib,

     Just an update on this. I increased the TransTxt size to 1000 and it automatically asked if I want to synchronize and I click on Ok. It is complaining about the attached error regarding the custaccountstatementexttmp table internal size 'The internal size of a custaccountstatementexttemp record is 67884 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 33792'. I also tried to increase the size to only 700 and I still get the same error. When I just put it back to the default out of the box 255 size then synchronization went well.  It appears that it is not relevant but some how it may be related not sure. Any clue what does it complain about this?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on 09 May 2016 at 20:36:18
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    yes, in your environment  it is modifiable. Might be you have a different application version.

    you can proceed to change length. And synch full DB afterwards, so that will make sure no views/tables have issues

  • Daxing Profile Picture
    Daxing 155 on 09 May 2016 at 19:03:10
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    I am looking at it and I think I can change it. Please see the image attached. I do not see it being inherited or using Name EDT. Here is the image where I put the cursor right at the 255 size.

    TranxTxtEDT.png

    Thanks,

    Dev

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on 09 May 2016 at 18:51:30
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    I think TransTxt will not allow you modify its length, as I can see its being extended from Name (EDT)

    You have to modify Name EDT. Doing so can bring other effects such as

    1. Throughout system, wherever Name is being used, length will be increased such as vendor name, customer name, employee name, prospect name and so on.

    2. You also need to increase length of DirPartyName (EDT), because those two combine in many views. So keeping length of both EDT's same will be good

  • Daxing Profile Picture
    Daxing 155 on 09 May 2016 at 18:24:42
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    Thanks Sohaib. I put the table name wrong in my previous posting. It is the ProjJournalTable table (not the LedgerJournalTrans) and the column is Txt. However, it is still using the TransTxt. If I change the size of the TransTxt EDT then all the columns that use the TransTxt EDT directly and also any EDTs that use/inherit from TransTxt (ex. LedgerJournalTransTxt as had mentioned in my previous posting) will change their size.

    From your posting, my understanding is that, I can go ahead and increase the size of the TransTxt EDT default size from 255 to to 1000. And once done, yes I do a full DB (right click on the Data dictionary and Synchronize).

    We are not using MR so, no need to worry about the step number 2.

    I will make changes to the TransTxt EDT size to 1000 and do a full db.

    Thanks,

    Dev

  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 46,614 User Group Leader on 09 May 2016 at 17:38:10
    RE: To increase the size of TransTxt Extended datatype size - DAX 2012 CU3 feature pack - please advise

    Yes, you can increase length. Increasing length with specifically mentioned numbers such as 400, 500, 700 etc. is good approach as converting field to MEMO size makes it useless with Full Text Indexes.

    As you will increase length of field, I recommend you two points.

    1. Full DB synchronize after increasing length of EDT. Because many view are dependent on Length of EDT(s) in the sense when views are using union queries, associated field might not has less length. This is a very common issue. Doing full DB synchronization and fixing all error manually will smooth journey for future. Else it will keep on bumping the Red error message for certain view always.

    2. If you are using Management Reporter. Make sure to increase length of Table which is saving transaction description. The posted transactions text goes into MR DB. But increasing length in AX DB does NOT increases length of field in MR DB. And if you will not increase length manually in MR DB, you users can face situation so that they will see Report in MR with incomplete description.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,000 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans