AnsweredAssumed Answered

PI SQL Commander throws an error when retrieving huge amount of query results data into file

Question asked by BalajiK on Jun 7, 2017
Latest reply on Jun 12, 2017 by gachen

PI SQL Commander throws an error when retrieving huge amount of query results data into file.

Query:

select tag, time, value from piarchive.picomp

where tag like 'tag_31000*' and Value <> ''

 

and time <='01/06/2017 00:00:00'

 

 

 

 

 

 

Error: 

[PI SDK] [Tag_310004558_Reading] Unable to create SAFEARRAY.<PIEVENTSTOSAFEARRAYS>

 

There are around 5000 tags having hourly data for the past one year.  Is there a way to overcome this?

Outcomes