cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

JSON does not allow non-finite numbers

green.kim.twsp
1-Newbie

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?

1 REPLY 1

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

Top Tags