500 JSON does not allow non-finite numbers

Question

We get this error from an application ONLY when it queries a particular text field and the value has the letter "E" in it.

If we query the value "75E003300011" we get the error. But if we query "750C17200011" the app returns a record. If we query this same data in ArcGIS desktop, we get no error.

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!