Well, with SQL Server 2008 I was unable to get that particular error, but I’ll see if I can install 2005 and try again.
Part of the problem could be that I don’t exactly know what’s leading to the error. The group configuration doesn’t seem too strange, so it might have to do with the values coming in from the device, which I can’t replicate. The best I can find about that error is that it comes from the values being outside the valid range for the data type, like smaller than 1e-38 or something.
Ideally you could create a test group with just one item that reproduced the problem. Then we could play around with changing data types in the database (some people suggested decimal instead of float). If that worked, you could change the datatype mapping in the db translator file and have FSQL re-create the tables for you.
Regards,