While opening any AX form or report that uses a large number of data-sources and joins, you can get an error message which is similar to:
"The total, internal size of the records in your joined Select statement is 29374 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 27646 bytes. It is strongly recommended that you split your tables(s) into smaller units."
If you increase the maximum buffer size, then this error will stop occurring. To increase the maximum buffer size,
1) Open the "Microsoft Dynamics AX 2012 Server Configuration".
2) Create a new configuration if one is not not present by going to the "Manage" button and clicking "Create configuration".
3) Under the "Database Tuning" tab, Adjust the value of "Maximum buffer size (KB):"
4) Apply and save the changes.
This value must be increased in small increments. For example, 1 KB at a time, after applying the changes you should see its effects. Keep increasing the value in small increments till the error message no longer comes.
This is the safe way to increase the value, other wise the risk is, if you increase the value too much, lets say you update the value from 24 KB to 124 KB then this might result in frequent AX crashes.
"The total, internal size of the records in your joined Select statement is 29374 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 27646 bytes. It is strongly recommended that you split your tables(s) into smaller units."
If you increase the maximum buffer size, then this error will stop occurring. To increase the maximum buffer size,
1) Open the "Microsoft Dynamics AX 2012 Server Configuration".
2) Create a new configuration if one is not not present by going to the "Manage" button and clicking "Create configuration".
3) Under the "Database Tuning" tab, Adjust the value of "Maximum buffer size (KB):"
4) Apply and save the changes.
This value must be increased in small increments. For example, 1 KB at a time, after applying the changes you should see its effects. Keep increasing the value in small increments till the error message no longer comes.
This is the safe way to increase the value, other wise the risk is, if you increase the value too much, lets say you update the value from 24 KB to 124 KB then this might result in frequent AX crashes.
hi all,
ReplyDeletecheck this below link.
http://www.axdynamicsworld.com/2016/10/how-to-decrease-buffer-size-in-ax-2012.html