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.

4 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

Blogger said...

BlueHost is one of the best website hosting provider for any hosting plans you require.