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