Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.
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?