From July 9th till 13th we will be at #MSInspire. See you there!

How to Fix the Error: Binding operation failed to allocate buffer space in Dynamics AX

How to Fix the Error: Binding operation failed to allocate buffer space in Dynamics AX
20 Mar 2014

Binding Operation Failed to Allocate Buffer Space in Dynamics AX??

When you work with QueryRun and Query Objects in Dynamics AX, chances are you will come across the following error:

Binding Operation Failed To Allocate Buffer Space

This error is generated when your QueryRun object causes the Application Object Server (AOS) to hit the buffer limit. But don’t worry, for there are ways to fix this problem. Actually there’s two ways to resolve this error:

  • Increase your buffer limit OR
  • Force literals for the query you are building in Dynamics AX

Let’s look at the first method.

Increase Buffer Limit

The first method is to increase the buffer limit. To do so, go to Administrative tools -> Microsoft Dynamics Ax 2009 Server Configuration -> the Database Tuning tab (as shown below) and set the buffer size you want.

How to Fix the Error: Binding operation failed to allocate buffer space in Dynamics AX

Force literals for the Query You Are Building in Dynamics AX

The second method involves forcing literals for the query you are trying to build. This is easy to do once you’ve created an instance of the query. Simple call a query.literal(1).

This will force Application Object Server to accept the buffer allocation requirement, and allow your advanced query to run. This in turn, will allow your QueryRun operation to finish as desired.

And that’s it!

Contact us today if you are interested in Microsoft Dynamics AX Services. Folio3 specializes in development of custom solutions and CRM based on clients needs.

Share

Raza Rabbani

Latest From Our Blog
7 Ways Dynamics 365 Finance and Operations Boos...
dynamics 365 finance
November 9, 2018
Introduction Launched by Microsoft, Dynamics 365 ERP is one of the most effective for businesses today. It is perfect to save the time, effort and ...
Read more
The Ultimate Guide to Dynamics 365 HR Payroll P...
dynamics hr payroll
October 30, 2018
For any business, irrespective of its size, payroll processing is one of the most important functions. Payroll processing is a method through which...
Read more
An Ultimate Guide to Dynamics 365 Business Cent...
business-central-2
September 24, 2018
Microsoft Dynamics Business Central can capably support all your financial processes, whereby enabling smooth integration with supply chain, operat...
Read more
Contact Form