We are experiencing issues with connectivity to our IP21 servers. Lately I've been seeing the following cast error repeated in the logfile. I also included a few of the entries for the same thread just prior to the error.
2014-09-25T13:21:44.1463564Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"query":"select Name, IP_Trend_Time[1] as ts, cast(IP_Trend_Value[1] as int) as Value from RHM_Discretedef where Name = [[TagName]];","parameters":{"dataShape":{"fieldDefinitions":{"TagName":{"baseType":"STRING","description":"TagName","name":"TagName","aspects":{},"ordinal":0}}},"rows":[{"TagName":"JC1002.CON_Beat_Val"}]},"maxItems":500.0}
2014-09-25T13:21:44.1776078Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"query":"select Name, IP_Trend_Time[1] as ts, cast(IP_Trend_Value[1] as int) as Value from RHM_Discretedef where Name = [[TagName]];","parameters":{"dataShape":{"fieldDefinitions":{"TagName":{"baseType":"STRING","description":"TagName","name":"TagName","aspects":{},"ordinal":0}}},"rows":[{"TagName":"JC1003.CON_STS_Val"}]},"maxItems":500.0}
2014-09-25T13:21:44.2088592Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"query":"select Name, IP_Trend_Time[1] as ts, cast(IP_Trend_Value[1] as int) as Value from RHM_Discretedef where Name = [[TagName]];","parameters":{"dataShape":{"fieldDefinitions":{"TagName":{"baseType":"STRING","description":"TagName","name":"TagName","aspects":{},"ordinal":0}}},"rows":[{"TagName":"JC1003.CON_Beat_Val"}]},"maxItems":500.0}
2014-09-25T13:21:44.2401106Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"query":"select Name, IP_Trend_Time[1] as ts, cast(IP_Trend_Value[1] as int) as Value from RHM_Discretedef where Name = [[TagName]];","parameters":{"dataShape":{"fieldDefinitions":{"TagName":{"baseType":"STRING","description":"TagName","name":"TagName","aspects":{},"ordinal":0}}},"rows":[{"TagName":"JC1004.CON_STS_Val"}]},"maxItems":500.0}
2014-09-25T13:21:44.2713620Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"query":"select Name, IP_Trend_Time[1] as ts, cast(IP_Trend_Value[1] as int) as Value from RHM_Discretedef where Name = [[TagName]];","parameters":{"dataShape":{"fieldDefinitions":{"TagName":{"baseType":"STRING","description":"TagName","name":"TagName","aspects":{},"ordinal":0}}},"rows":[{"TagName":"JC1004.CON_Beat_Val"}]},"maxItems":500.0}
2014-09-25T13:22:09.5068675Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"tableNameMask":""}
2014-09-25T13:22:11.8819739Z Verbose 28 SYSTEM ThingworxRESTClient Request: {"columnNameMask":"","tableName":"APIInfoDef"}
2014-09-25T13:22:11.9132253Z Error 28 SYSTEM AdoEdgeThing.IP21B GetColumns Exception error : System.InvalidCastException: Specified cast is not valid. at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value) at System.Data.DataRowExtensions.Field(DataRow row, String columnName) at ThingworxNet.Core.Types.InfoTableExtensions.ColumnsToInfoTable(DataTable dataTable, Boolean isOdbc) at ThingworxNet.Things.AdoEdgeThing.AdoEdgeThing.GetColumns(String tableName, String columnNameMask)
Can you tell if there is something wrong with out edge server or odbc connection based on the error?
Thank You,
Greg Kolbow
