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) / How can I change "...
Microsoft Dynamics AX (Archived)

How can I change "Buffer size" ?

(0) ShareShare
ReportReport
Posted on by Hatice Yaldiz

Hello,

 

When I execute project -> Quotations -> My project Quotations, I have this error message :

 

The total, internal size of the records in your joined SELECT statement is 26420 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 26 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.

Where can I find this "buffer size" ? Is there any bad consequences to do that ?

Thanks by advance for your help.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    You can change this value in the Server Configuration Utility, in the Database tuning tab, field "Maximum buffer size".

    The value specified needs to be in Kilobytes (e.g 28) and not bytes (28000),

  • Hatice Yaldiz Profile Picture
    Hatice Yaldiz on at

    Thank you very much for your answer, it's working. But, do you know if there is bad consenquence to do this ?

  • Community Member Profile Picture
    Community Member on at

    This post from Ax support covers this issue briefly.

    blogs.msdn.com/.../random-clients-crashes.aspx.

    I am not really sure what the buffer size is, but I guess changing default options could sometimes cause problems. On the other hand, your code is currently not working, so...

    The problem could probably go away by adjusting the code somehow, but since you get an error perhaps you should try to report it as an incident to the MS Support. If they recommend you to change the Maximum Buffer Size you are on the safe side :-)

  • Community Member Profile Picture
    Community Member on at

    I also found this article. It indicates that you could avoid this by forcing literals on the query causing problems. Perhaps you can try to change the Literals property of the AOT-Query "SalesQuotationListPage" to "forceLiterals". That might help...or not :-)

    blogs.msdn.com/.../binding-operation-failed-to-allocate-buffer-space.aspx

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