Skip to main content
1-Visitor
October 13, 2011
Question

JSON does not allow non-finite numbers

  • October 13, 2011
  • 1 reply
  • 3630 views

When connecting to a MS SQL server to access a table within a database the Thingworx server throws an exception "JSON does not allow non-finite nubers. I have set the configuration for an SQLQuery handler within a Service implementation for a Thing of type database to "Select * from tblePPR_Comments". After going through the columns individually it appears to throw this error on columns of type number (int, tiny int, small int, etc.) when a null value is present in at least one of the rows.
Is there a way around this?

1 reply

5-Regular Member
November 14, 2016

Kim Green​ Are you still facing the issue? Or looking for a workaround?