Thursday, 1 August 2013

Purchase requisition error “The total, internal size of the records in your joined SELECT statement is 51314 bytes, but…” [AX 2012 R2]

In AX 2012 R2 you might get this on the purchase requisition form. This happens because a lot of fields have been deleted as part of R2 and new ones added on the purchase requisition line table.

2013-08-01_1120

  • The total, internal size of the records in your joined SELECT statement is 51314 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 49152 bytes.
  • It is strongly recommended that you split your table(s) into smaller units.
  • Alternatively, you have to specify a 'Maximum buffer size' value of 51 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 directives above. Use of the table(s) will cause unpredictable results.

Solution

Turn off the upgrade config keys.

2013-08-01_1122

You should have these turn off in your production environments.

3 comments:

Palle Agermark said...

That's a very good tip.

I recon many people, incl. myself, would starting looking all sorts of other Places to fix the bug.

Vimal Raja v said...

Very useful tips for me .i resolved the error. thank u Ahmed

BSR Krishna said...

This will also work
Increasing Max Buffer size in AX 2012 Server configuration utility > Database tuning tab Maximum buffer size into 50 KB or greater than 50 KB