Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

runing query SalesTableListPage...

by
on 15 Jul 2009
  • Not Answered

How can I change "Buffer size" ?

by
on 9 Nov 2010
  • Verified Answer

AX 2012 - Asset Import (DMF utility)

by
on 5 Apr 2013
  • Verified Answer
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

Maximum buffer size problem while running SSRS report which uses AOT query

This question is not answered
syed baber
Posted by
on 24 Sep 2012 5:21 PM

Hi,

I am trying to run ReturnAcknowledgementAndDocument report, and getting the following error:

The total, internal size of the records in your joined SELECT statement is 24678 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 24576 bytes. 

Actually, we have modified the SalesTable to add lot of fields, but in AOT query I have removed all those fields plus lot of fields which are not being used in the report, but even then I am getting the same error. The only case in which I am not getting the error is by removing the data source FormLetterRemarks from AOT query, but obviously I can't do that because it is already there by design. 
Any idea or clue how to resolve this issue?
Thanks,
Syed Baber.
All Replies
  • Andy Adamak
    Posted by
    on 24 Sep 2012 5:24 PM

    There is a great discussion on that here that I also had to read recently:

    dynamicsuser.net/.../276955.aspx
  • syed baber
    Posted by
    on 24 Sep 2012 5:43 PM

    I have deleted lot of fields from SalesTable datasource which are not being used in the report and also deleted some fields from other datasource as well, but that doesn't seems to be decreasing the size and I am still getting the same error. Am I doing something wrong, why it is not decreasing the buffer size when I have deleted lot of fields from the datasource?
  • Andy Adamak
    Posted by
    on 25 Sep 2012 9:07 AM

    Are you using AX 2012 or 2009?

  • Andy Adamak
    Posted by
    on 25 Sep 2012 9:26 AM

    I haven't looked into 09, but if you're using 2012 I have a quick thought: Have you modified the ReturnAcknowledgmentAndDocumentTmp table (and therefore your ReturnAcknowledgmentAndDocumentDP)?  

    I usually get this error when I add too many fields to a report's tmp table.  After the report data provider class runs, it selects this entire table and you'll get this error if it's too wide.  
  • syed baber
    Posted by
    on 25 Sep 2012 3:59 PM

    I am using AX 2012 and haven't made any modifications in Tmp table. I have just added lot of fields in SalesTable, but in report AOT query I have removed lot of fields from SalesTable datasource which are not being used in reports but no luck.
  • Ali Zaidi
    Posted by
    on 19 Oct 2012 4:52 AM

    From dynamics AX server configuration utility at database tuning tab, increase the maximum buffer size. Your problem will solve.

  • Jimmy Liu
    Posted by
    on 19 Oct 2012 12:49 PM

    Please go to "Database Tuning" tab in Microsoft Dynamics AX Server Configuration Utility and check "Maximum buffer size (KB)" on it.  Try to increase the setting may be resolved your problem.
  • AX Man
    Posted by
    on 14 Nov 2012 1:55 AM

    Setting what Jimmy pointed to will help.  Try going up to 32.  Do not exceed 80.