AnsweredAssumed Answered

Problem when using table lookup reference in AF analyses

Question asked by Tomas Stark Champion on Aug 31, 2017
Latest reply on Sep 4, 2017 by Tomas Stark



we use PI AF and ran into problems when trying to use Table Lookup references in AF analyses, so I made a simple test template to try to figure out what the problem is.


In the test case below I have one attribute Value SQL, which is fetched from a SQL database using Table Lookup and this works fine and I get the latest value.


I also assign the value of Value SQL to an attribute Value attribute, which also works fine.


Then I try to assign the value of Value attribute to a PI Point tag reference attribute named Value tag, and this last step does not work. The correct values are shown when doing Evaluate, but when the analyses are executed, Value tag will have "Calc Failed".


I guess it all has to do with "references to references", but don't really know how the analytics Engine is working or if this is a bug.


170831 Skärmklipp 1.JPG


170831 Skärmklipp 2.JPG


170831 Skärmklipp 3.JPG