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

(0) Share

Report

Posted on 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

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Sohaib Cheema 48,972 User Group Leader on at

Like (0)

Report
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.

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.

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.

Was this reply helpful? Yes No
Daxing 155 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sohaib Cheema 48,972 User Group Leader on at

Like (0)

Report
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

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

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

Was this reply helpful? Yes No
Daxing 155 on at

Like (0)

Report

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.

Thanks,

Dev

Was this reply helpful? Yes No
Sohaib Cheema 48,972 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
Daxing 155 on at

Like (0)

Report

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

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?

Was this reply helpful? Yes No
Sohaib Cheema 48,972 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Daxing 155 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Daxing 155 on at

Like (0)

Report

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!

Was this reply helpful? Yes No