Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 11, 2007 at 03:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2007 at 03:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2007 at 03:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded