Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Server Configuration U...
Finance forum
Unanswered

Server Configuration Utility - specify max buffer size

Posted on by

Hello,

I have the following error on UAT environment:

"The total, internal size of the records in your joined SELECT statement is 206056 bytes, but Microsoft Dynamics 365 for Finance and Operations is by default performance-tuned not to exceed 196608 bytes."

And the system suggests:

"Alternatively, you have to specify a 'Maximum buffer size' value of 202 Kbytes or higher on the 'Database Tuning' tab page in the Microsoft Dynamics 365 for Finance and Operations: Server Configuration Utility. The default value is 24 Kbytes."

Do you know in Azure environment where can I find Server Configuration Utility?

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,645 Moderator on at
    RE: Server Configuration Utility - specify max buffer size

    You have to report it to Microsoft. If its stopping you  from  doing your work  in prod env, you might have to contact DSE as suggested above by Nikolaos and see if they can help.

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Server Configuration Utility - specify max buffer size

    Believe it or not, sometimes there are problems also in the standard application.

    Do you experience this only in UAT, but not PROD? Do you have different posting group setup in PROD?

    Anyway, if you need that setup, I advise you to create a service request for the DSE team to increase the limit in your environment. If it works, then ask them to increase it for PROD environment, too.

  • Teo Profile Picture
    Teo on at
    RE: Server Configuration Utility - specify max buffer size

    The form that gives the error is TaxAccountGroup and it has no customizations.

    This is the screenshot from the error:

    VS.png

    There are a lot of reference datasources in this form. But can this cause the problem since it is standard functionality? 

    VS.png

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,645 Moderator on at
    RE: Server Configuration Utility - specify max buffer size

    There is no server config utility in D365. Looks like your select statement is quite heavy. During which operation you are getting this error ? Is that functionality customized ?

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: Server Configuration Utility - specify max buffer size

    I haven't heard of this error in D365FO so far. Maybe because they seem to have increased the default value to 196 KB.

    To my knowledge there is no Server configuration utility for D365FO, everything is handled with config files.

    You don't have access to the configuration files in Microsoft hosted D365FO environments.

    You could try to trim your statement (it is coming from a customization, right?), or create a service request of type Other for the DSE team and ask if they can increase the limit.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans