Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Former Member
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question