Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
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?