1 Reply Latest reply on Nov 14, 2016 2:01 PM by giri RSS
    green.kim.twsp Explorer

    JSON does not allow non-finite numbers

    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?