AccountNum is a very commonly used EDT. The impact of such a change is huge! It is affecting at least one select statement as indicated in the message, but I would suspect many more selects would fail for the same reason. I would check with your customer to determine if 150 characters is absolutely required. If so, you have no choice but to take the advice -- i.e. use the Configuration Utility to increase the buffer size. Performance will probably NOT be very good if such a large account number is used.
You may want to have the customer consult Microsoft support before you do this. It seems dangerous to me. On Wed, Feb 11, 2009 at 2:53 AM, cs_suchitra <cs_suchi...@yahoo.com> wrote: > Hi, > > I got this below mentioned error when i tried to change the string > size of the EDT AccountNum from 20 to 150. Can anyone please tell me > what would be the impact of such a change and what will happen if all > the tables using this EDT have more than 1 lakh records? > > error: > The total, internal size of the records in your joined SELECT > statement is 37264 bytes, but Microsoft Dynamics is by default > performance-tuned not to exceed 24576 bytes. > It is strongly recommended that you split your table(s) into smaller > units. > Alternatively, you have to specify a 'Buffer size' value of 37 Kbytes > or higher in the 'SQL' tab page in the Microsoft Dynamics > Configuration Utility. The default value is 24 Kbytes. > Exit Microsoft Dynamics immediately, and follow the directives above. > Use of the table(s) will cause unpredictable results. > > Thanks in advance! > > Suchitra > >