Odata import error - company name 30 characters long & includes spaces so too long

(0) Share

Report

Posted on by Community Member

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%20Bbbbbbb%20Cccccccccccc%20Ltd')/

The result when hitting NAV is

<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> [^]
<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.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

What is the length of your company name, it should be 30 characters, and it looks like your company name is 33 characters.

It cannot be more than 30 characters.

msdn.microsoft.com/.../jj863505%28v=nav.70%29.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

The company name as it appears in Navision is in the format "Aaaaa Bbbbbbb Cccccccccccc Ltd" i.e. 30 characters including the spaces.

If I count the characters in the hyperlink it is 36 characters so it doesn't look like it is counting the characters in the hyperlink i.e. not the %20.

It seems as though the spaces are being counted as 2 characters which may explain why it thinks the string is 33 characters long instead of 30.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

As you mentioned earlier the CU 17 has an platform fix for "You encounter a runtime error when you save changes to an OData set in a company with 30 characters in the company name."

Please apply that and try.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Is CU17 already available? I couldn't find it.

Is it possible to get hold of just the fix 363433 to try that alone instead of applying a whole CU?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

blogs.msdn.com/.../cumulative-update-17-for-microsoft-dynamics-nav-2013-r2-has-been-released.aspx

The best way is to create a new demo database with same company name and try, and try again after apply the above.

It is platform hotfix you cannot apply just 363433,

Was this reply helpful? Yes No
Suggested answer

Daniele Rebussi 2,480 on at

Like (0)

Report

From the list of cumulative updates in CustomerSource I'm still not able to see it even if it was released 3 days ago.

Only downloadable from KB link https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;EN-US;3039826

Was this reply helpful? Yes No