Workaround for Character to Double conversion error ?
Referring to a previous post and Ranga's solution, https://forums.sdn.sap.com/click.jspa?searchID=4859156&messageID=3834199
Is there any other way around the ">>>>>>>" within the Graph Maximum and Minimum? Our IP21 team is telling us that the plant has it configured this way as a "design feature" of IP21 - thus we cant go in and set the tag's max or min to solve our problem? Any thoughts?
Jeremy Good replied
Try adding this extra bit of syntax in the Data Server configuration settings:
TagInfoMinRangeColumn is normally just "name->graphminimum"
TagInfoMaxRangeColumn is normally just "name->graphmaximum"
Change Min to:
(Case when CAST(name->IP_GRAPH_MINIMUM AS CHAR) = '>>>>>>>' THEN 0 ELSE name->IP_GRAPH_MINIMUM END)
Change Max to:
(Case when CAST(name->IP_GRAPH_MAXIMUM AS CHAR) = '>>>>>>>' THEN 99999 ELSE name->IP_GRAPH_MAXIMUM END)
This way the query for tag meta-data handles the incomplete configuration on the IP21 server.