Product: Dynamics 365 Business Central
Article Link: http://help.truecommerce.com/en/articles/7946412-dynamics-365-business-central-error-request-url-too-long
Error: <HTML><HEAD><TITLE>Request URL Too Long</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Request URL Too Long</h2>
<hr><p>HTTP Error 414. The request URL is too long.</p>
</BODY></HTML>
Alt. Error: Error parsing NaN value. Path '', line 1, position 1.
Issue: When exporting out a very large Purchase Order (850) or other inbound transaction from Transaction Manager you receive the error 'Error parsing NaN value. Path '', line 1, position 1.' - upon further looking within the Log you will see that the Business Central RESP JSON() returns a 'Request URL Too Long' error
Reason: Since Dynamics 365 Business Central is a web-based ERP you're passing data through web-urls back and forth between it and Transaction Manager to properly send/receive data - this includes data such as items.
When a transaction with a large amount of items on it is received and attempted to be passed through the OData Query (Web-URL) you can hit the browsers/servers limit of how many characters can be in a single request exceeding the length.
The error Error parsing NaN value. Path '', line 1, position 1. is a bit of a generic error and mean multiple things - usually it's a failure to properly parse data between Dynamics 365 Business Central & Transaction Manager
Solution - Set Request Length Limit
You can split up your requests into chunks by using the Request Filter Length Limit setting within Transaction Manager. This will limit how many characters can be sent in a single request.
The recommended setting is 5000 - but you may need to limit it by 1000 or so in order to get the request to complete as some older browsers are unable to handle beyond 2000.
Navigate: Business System → (Company) → Company Configuration → Integration Options
Set: Request Filter Length Limit
Recommended Value: 5000
If you do not see this setting - contact support to have it added
rev 5/25/2023