vashavijay

Values are showing up in the "Status Column" while retrieving data from PI OLEDB

Discussion created by vashavijay Champion on Apr 19, 2014
Latest reply on Apr 21, 2014 by Elizabeth McErlean

Hi All,
I am observing a weird problem while retrieving data of a PE tag from PI server using PI OLEDB (MMC & SQL Commander), the values of tag are showing up in the "Status Column" and I observed this only for few tags . Here I am using the picomp table to read data from PI server.

If I execute this query for other tags production tags or PE tag then I see the data  "value column" only.

 

Please see the attachments for more understanding .

 

Thanks in advance.

PI OLEDB Query- PE Tag .pngPI OLEDB Query- Sinusoid Tag .png

Outcomes