When attempting to export records via Microsoft Dynamics and the number of records is greater than 5,000, you may receive this error.
The number of records in the table exceeds the maximum number of 5000. Set a filter to decrease the number of records in the table. Exporting too many records at once can affect system performance.
Dynamics CRM Online
Follow this guide.
Dynamics NAV
Open using your preferred ClientUserSettings.config
NAV 2013 R2
Default location is
C:Users<username>AppDataRoamingMicrosoftMicrosoft Dynamics NAV71
NAV 2013
Default location is
C:Users<username>AppDataRoamingMicrosoftMicrosoft Dynamics NAV70
NAV 2009
On Windows 7, Windows Vista, or Windows Server 2008, the default location is
C:Users<username>AppDataLocalMicrosoftMicrosoft Dynamics NAV
On Windows Server 2003 or Windows XP, the default location of this file is
C:Documents and Settings<username>Local SettingsApplication DataMicrosoftMicrosoft Dynamics NAV
Where
<username>
is the name of the user.
Change MaxNoOfXMLRecordsToSend property value from 5000 to, for example, the maximum integer value of 2147483647
<add key="MaxNoOfXMLRecordsToSend" value="2147483647" />
If you’ll insert a number bigger that 2147483647 you’ll receive the following error message:
The MaxNoOfXMLRecordsToSend config
<add key="MaxNoOfXMLRecordsToSend" value="2147483647" />
Duration setting must have a value between -2,147,483,648 and 2,147,483,647.