How to decrease the Buffer size in AX 2012

I got keep getting this type of Maximum Buffer size while making the entry on during all transactions like Purchase order, Sales order, creation of Master data and so on. Then finally I got the solution to reduce this type of issue.

Error Message:

The total, internal size of the records in your joined SELECT statement is 7100 bytes, but Microsoft Dynamics is by default parameter tuned not to exceed 49152 bytes.

It is strongly recommended that you split your tables(s) into smaller units.

Alternatively, you have to specify a Maximum buffer size value of 70 Kbytes or higher on the ‘Database Tuning’ tab page in the Microsoft Dynamics AX Server Configuration Utility. The default value is 24 Kbytes.

Exit Microsoft Dynamics Immediately, and follow the directive above. Use of the table(s) will cause unpredictable results.

Reason: When you run the AX application it need some space to process the data or making of any transactions. For that application is going to allocate some space for make the process. In case if the size is getting filled of then the application may through this type of error and waring message on your screen.

Solution:

1)  Navigation Path: System Administrator >> Setup >> Licensing >> License Configuration

2)  Remove the Update Objects from the License configuration and click Apply button.

3) It will ask you for Full compilation process and once if it is completed next Table Synchronization will start for further process. It will take couple of hours to complete this all process in between don’t disturb the process make as it is just look your eyes on your screen. Once completed just close and open the AX application.

4) If your problem solved, then you will not get any messages like above again.

In case if you getting any messages like below the you need to Table Synchronization again, for that check the below path.

Error: Cannot select a record in Party location relationships (DirPartyLocation). Name: 0, 0. The SQL database has issued an error.

Navigation path for Table synchronization:

System Administrator >> Periodic >> Database >> Consistency check

Wait for few more minutes to complete this process, once completed you can access the application without getting any error messages again.

Now you can access the AX without getting errors during the postings. 

Share your comments...!