500 JSON não permite números não finitos

Question

<\/HEAD>Recebemos este erro de um aplicativo SOMENTE quando ele consulta um campo de texto específico e o valor contém a letra "E".<\/P> Se consultarmos o valor "75E003300011" recebemos o erro. Mas se consultarmos "750C17200011", o app retorna um registro. Se consultarmos esses mesmos dados no ArcGIS desktop, não ocorre erro.<\/P><\/BODY><\/HTML>

HillaryBjorstrom · Answer

Also i was able to query outside of my application. Directly in the Rest Service fine. It seems to happen in the application itself.

HillaryBjorstrom · Answer

Yes i think it is. I have seen this before in sql when converting data in a view. To get past it there I would use a a cast or convert function in the view. i think something simliar would work here. I am asking our programmer if he can add it into our application. Another option that may help you get by would be to add another field and add a letter in the front like S7E054546110. That may help too.

KimMcDonough · Answer

Yes!~ Another voice crying out in the wilderness! This is NOT a problem with the data. For some reason, Arc is interpreting the text field as an Exponential number when it sees an "E". This has to be a bug!