Microsoft Dynamics AX (Archived)

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

(0) Share

Report

Posted on by atef@83

805

HI all

we have strange error after Update Ax 2012 R3 with Cu8,Cu9,Cu10

after that when we try to open AP Module and create new Vendor We Got this error also if i click on edit it's pop up this error

8863.Untitled.png

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Crispin John Augustine 37,081 on at

Like (0)

Report

Never faced this before. But it is relatively explanatory.

Have you by any chance added too many new fields in VendTable?

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

It is documented here:

[View:https://technet.microsoft.com/en-us/library/aa569634.aspx:750:50]

We are running with a buffer size of 100kb due to large selects for exchanging data with our eCommerce portal through AIF.

Was this reply helpful? Yes No
atef@83 805 on at

Like (0)

Report

Thanks For Reply there is no any new fields added to Vendtable

Was this reply helpful? Yes No
atef@83 805 on at

Like (0)

Report

thank you for reply but if i change Buffer size to this number it's safe or not

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

The documentation clearly says that it is to troubleshoot overly large tables and joins, which are causing performance issues.

You should be looking at the root cause of the problem on why do you get the error message of that form. Like too many added fields, too many customizations which have added a lot of additional tables to the join, or using a lot of XDS policies for security filtering, and so on.

Increasing the maximum buffer size can hurt performance too, but it will make the error message go away immediately after restarting the AOS service. Make sure you change it on each AX AOS instances within your environment!

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can create new AX server configuration with this size buffer

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

From AX Client Reset User Usage Data, It resolves for me.

Was this reply helpful? Yes No