0 Replies Latest reply on Oct 15, 2015 8:45 AM by gregko RSS
    gregko Explorer

    AdoEdgeThing Invalid Cast

    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[T](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