AnsweredAssumed Answered

VBA routine using ipid1.summaries2 was working but is now retrieving only some of the data

Question asked by Raul_Das on Sep 3, 2019

I am using the following to retrieve hourly averages (i.e., duration = "1h"):

 ' calculate the average values for the tag name specified
    Set nvsAvg = ipid2.Summaries2(startTime, endTime, duration, asAverage, cbTimeWeighted)
' extract the pivalues for average from the result
    Set valAvg = nvsAvg("Average").Value

 This has been working without any issues for the past 12 months but started giving me the following results today.

 

Thoughts?

 

DATE                               UTIL.WWW.PV      UTIL.XXX.PV           UTIL.YYY.PV            UTIL.ZZZ.PV

01-Jan-19 00:00           2239.59                     216.77                       161.34                       933.66

01-Jan-19 01:00                                                                                                                      

01-Jan-19 02:00                                                                                                                      

01-Jan-19 03:00           2220.19                     215.77                       160.37                       952.04

01-Jan-19 04:00                                                                                                                      

01-Jan-19 05:00                                                                                                                      

01-Jan-19 06:00           2190.41                     216.12                       160.59                       932.17

01-Jan-19 07:00                                                                                                                      

01-Jan-19 08:00                                                                                                                      

01-Jan-19 09:00           2259.08                     216.31                       165.14                       775.91

01-Jan-19 10:00                                                                                                                      

01-Jan-19 11:00                                                                                                                      

01-Jan-19 12:00           2566.72                     192.09                       154.83                       870.45

01-Jan-19 13:00                                                                                                                      

01-Jan-19 14:00                                                                                                                      

01-Jan-19 15:00           2462.16                     211.79                       163.48                       903.63

01-Jan-19 16:00                                                                                                                      

01-Jan-19 17:00                                                                                                                      

01-Jan-19 18:00           2035.22                     215.70                       158.86                       881.34

01-Jan-19 19:00                                                                                                                      

01-Jan-19 20:00                                                                                                                      

01-Jan-19 21:00           2224.88                     214.71                       161.37                       849.19

01-Jan-19 22:00                                                                                                                      

01-Jan-19 23:00                                                                                                                      

02-Jan-19 00:00           2186.17                     212.73                       159.96                       875.55

02-Jan-19 01:00                                                                                                                      

02-Jan-19 02:00                                                                                                                      

02-Jan-19 03:00           2148.62                     216.17                       160.14                       907.23

Outcomes