Workaround for Character to Double conversion error ?

[Former Member]

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?

[jcgood25 · Accepted solution]

Fore.....

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.

Regards,

Jeremy

[Former Member · Accepted solution]

That worked!

Happy Gilmore, Ridin' the bull, doing the happy dance

[jcgood25]

Another thought to consider would be that the TagInfoTable data server property by default is "all_records".

If "all_records" is a view maybe you could adjust it to do this sort of logic (or create one like it with a new name) then the server params could remain much simpler.

Regards,

Jeremy

[salvatore_castro]

Not that I can think of without doing this on the BLS side or applying a transform to the data to string replace the ">>>>>>>" with a value.

-Sam