2 of 2 people found this helpful
There were changes to the way the event frame IDs are determined for newer versions of AF, which breaks the PI OLEDB Enterprise's ability to run real time data queries against event frames in versions prior to 2017 R2. Since you have a newer AF server version and an older PI OLEDB Enterprise version, you're running into this incompatibility. It's restricted to just the event frames, though, so when you take that out of the query you no longer run into the error.
To work around this, you'll need to upgrade the PI OLEDB Enterprise verison to 2017 R2.
Hi Kelsey, Thanks for confirming that I need to upgrade and that it's not an issue with the query syntax.