Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading 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
SSRS and SSAS Integration
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.
There is a great discussion on that here that I also had to read recently:
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?
Are you using AX 2012 or 2009?
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.
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.
From dynamics AX server configuration utility at database tuning tab, increase the maximum buffer size. Your problem will solve.
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.
Setting what Jimmy pointed to will help. Try going up to 32. Do not exceed 80.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13