PI SQL Commander throws an error when retrieving huge amount of query results data into file.
select tag, time, value from piarchive.picomp
where tag like 'tag_31000*' and Value <> ''
and time <='01/06/2017 00:00:00'
[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?