Options

Odata import error - company name 30 characters with spaces

salnavsalnav Member Posts: 6
edited 2015-03-13 in NAV Three Tier
We are using Odata Navision API to import a sales order into MS NAV 2013 R2 and the Odata URL seems to be incorrectly calculating the Web URL below. (I've substituted the company name for privacy)

http://localhost:7068/AAAAA-NAV2013R2-DEV/OData/Company('Aaaaa Bbbbbbb Cccccccccccc Ltd')/

The result when hitting NAV is


<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"&gt; [^]
<m:code/>
<m:message xml:lang="en-US">
The length of the string is 33, but it must be less than or equal to 30 characters. Value: ='Aaaaa Bbbbbbb Cccccccccccc Ltd'
</m:message>
</m:error>

Taking out the spaces on the test database works but this solution isn't acceptable to the customer.

I have seen reference to hot fix 363433 (You encounter a runtime error when you save changes to an OData set in a company with 30 characters in the company name.) in cumulative update 17 (March 2015) but I can't find any more info on this & don't know if this would solve this problem.

Any help gratefully received.

Comments

  • Options
    salnavsalnav Member Posts: 6
    Update: Applying the hotfix solved the problem.
Sign In or Register to comment.