Hi everyone,

for our quality control of datas, we develop a programm on Matlab which get the data from our PI server. But we found that in certain case, we get 600 raw data (1 data per second) but the server returns "Calculation Failed" for datas of10 minutes (min, max, std, and avg). So we would like recalculate datas. We know that on PI ACE we can easily recalculate datas, but do you know if there is a method to do it on matlab with a SQL request for example?

Thank you

Alex

Hello Antoine,

I am afraid, with regards to Matlab there's not much I can tell but I have the suspicion that you get "Calc failed" returned from the PI System when querying min, max, std and avg. If this is the case there is usually a good reason i.e. with a gap in raw data. I suggest reviewing raw data of tags involved before doing any recalculation.