View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
000504910000-013: AggregatesSpecpublic2019-09-17 13:112022-03-10 16:08
ReporterMatthias Isele Assigned ToRod Stein  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionreopened 
Fixed in Version1.05.02 RC1 
Summary0005049: Sample Data missing for DurationInStateZero and DurationInStateNonZero
Description

The tables in Annex A.20 and A.21 only contain Data for historian 4 and state "The Aggregate only applies to Historian 4".

However chapter 5.4.2.3 DataType - Table 13 states that the aggregates DurationInStateZero and DurationInStateNonZero can be used with bool or any numeric datatype.
Please clarify.

TagsNo tags attached.
Commit Version

Relationships

has duplicate 0005388 closedRod Stein Wrong Values in Test data for DurationInStateZero and DurationInStateNonZero aggregates (0005049) 
related to 0006205 closedRod Stein DurationInStateZero:Historian1 requires updates as per Get Time Weighted Status 
related to 0006246 closedRod Stein DurationInStateNonZero:Historian1 requires updates as per Get Time Weighted Status 

Activities

Archie Miller

2019-10-25 16:51

administrator   ~0011174

Test data for the desired Aggregates that should be added to the spec.

DurationInStateZero

Historian 1

Timestamp: '00:00:00.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated, Partial'
Timestamp: '00:00:16.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:00:32.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:00:48.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:04.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:20.000',Value: '0',Quality: 'Good, Calculated, Partial'
Timestamp: '00:01:36.000',Value: '',Quality: 'BadNoData'

Historian 2

Timestamp: '00:00:00.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated, Partial'
Timestamp: '00:00:16.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:00:32.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:00:48.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:01:04.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:20.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated, Partial'
Timestamp: '00:01:36.000',Value: '',Quality: 'BadNoData'

Historian 3

Timestamp: '00:00:00.000',Value: '0',Quality: 'Good, Calculated, Partial'
Timestamp: '00:00:16.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:00:32.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:00:48.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:01:04.000',Value: '0',Quality: 'Good, Calculated'
Timestamp: '00:01:20.000',Value: '0',Quality: 'Good, Calculated, Partial'
Timestamp: '00:01:36.000',Value: '',Quality: 'BadNoData'

DurationInStateNonZero

Historian 1

Timestamp: '00:00:00.000',Value: '6000',Quality: 'UncertainDataSubNormal, Calculated, Partial'
Timestamp: '00:00:16.000',Value: '16000',Quality: 'Good, Calculated'
Timestamp: '00:00:32.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:00:48.000',Value: '14000',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:04.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:20.000',Value: '10001',Quality: 'Good, Calculated, Partial'
Timestamp: '00:01:36.000',Value: '',Quality: 'BadNoData'

Historian 2

Timestamp: '00:00:00.000',Value: '14000',Quality: 'UncertainDataSubNormal, Calculated, Partial'
Timestamp: '00:00:16.000',Value: '16000',Quality: 'Good, Calculated'
Timestamp: '00:00:32.000',Value: '10000',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:00:48.000',Value: '16000',Quality: 'Good, Calculated'
Timestamp: '00:01:04.000',Value: '13000',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:20.000',Value: '7001',Quality: 'UncertainDataSubNormal, Calculated, Partial'
Timestamp: '00:01:36.000',Value: '',Quality: 'BadNoData'

Historian 3

Timestamp: '00:00:00.000',Value: '14000',Quality: 'Good, Calculated, Partial'
Timestamp: '00:00:16.000',Value: '16000',Quality: 'Good, Calculated'
Timestamp: '00:00:32.000',Value: '10000',Quality: 'Good, Calculated'
Timestamp: '00:00:48.000',Value: '16000',Quality: 'Good, Calculated'
Timestamp: '00:01:04.000',Value: '13000',Quality: 'Good, Calculated'
Timestamp: '00:01:20.000',Value: '7001',Quality: 'Good, Calculated, Partial'
Timestamp: '00:01:36.000',Value: '',Quality: 'BadNoData'

Srinivasu Jitta

2019-11-11 13:14

reporter   ~0011213

I have done unit test for the above added Test data for DurationInStateZero and DurationInStateNonZero aggregates. I came across couple of issues. I think some statusCodes are wrong, should be (have a look at the below changes)

DurationInStateZero

Historian 1

Timestamp: '00:00:16.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:20.000',Value: '0',Quality: 'UncertainDataSubNormal, Calculated, Partial'

DurationInStateNonZero

Historian 1

Timestamp: '00:00:16.000',Value: '16000',Quality: 'UncertainDataSubNormal, Calculated'
Timestamp: '00:01:20.000',Value: '10001',Quality: 'UncertainDataSubNormal, Calculated, Partial'

Rod Stein

2020-09-14 01:35

developer   ~0012794

Fixed in Part 13 1.05.2

Missing tables added and one existing value revised.

Errata added in 1.04.8

Rod Stein

2020-09-15 18:14

developer   ~0012836

Errata will wait till other changes are done to make sure errata is done on final changes.
Change for this issue was approved in Sept 2020 F2F.

Rod Stein

2020-09-15 18:15

developer   ~0012837

Errata will wait till other changes are done to make sure errata is done on final changes.
Change for this issue was approved in Sept 2020 F2F.

Rod Stein

2021-09-17 00:20

developer   ~0014871

Added errata to 1.04.11 and 1.03.9

Jim Luth

2021-12-09 14:38

administrator   ~0015536

Archie needs to verify his generated values.

Archie Miller

2022-01-04 22:57

administrator   ~0015672

  • DurationInStateZero is Validated
  • DurationInStateNonZero is Validated for Historian1, Historian2, Historian4

Keep in mind that Intervals allow for durations of 1.

5.4.2.4 Time calculation issues - If there is one data point in the Interval and it falls on the StartTime the time duration used in calculations is one unit of the time resolution of the Server.

DurationInStateNonZero use SimpleBounds to determine Values for each interval

Historian Three

12:01:20.000 Calculation

GetSimpleValues

  • Value = Data Value status BadNoData timestamp 2022-01-01 12:01:20 AM value (null)
  • Value = Data Value status Good timestamp 2022-01-01 12:01:23 AM value 70
  • Value = Data Value status Good timestamp 2022-01-01 12:01:26 AM value 80
  • Value = Data Value status Good timestamp 2022-01-01 12:01:30 AM value 90
  • Value = Data Value status BadNoData timestamp 2022-01-01 12:01:36 AM value (null)

Time Regions

  • Duration 3000 StartValue 0 EndValue 0 start time 12:01:20 AM status BadNoData
  • Duration 3000 StartValue 70 EndValue 70 start time 12:01:23 AM status Good
  • Duration 4000 StartValue 80 EndValue 80 start time 12:01:26 AM status Good
  • Duration 1 StartValue 90 EndValue 90 start time 12:01:30 AM status Good

Last Raw value of 90 at 12:01:30 meets the criteria of If there is one data point in the Interval and it falls on the StartTime the time duration used in calculations is one unit of the time resolution of the Server.

DurationInStateNonZero = 7001

Timestamp Value StatusCode
12:01:20.000 7001 Good, Calculated, Partial

Both the Original test tool and the CTT follow these calculations.
If desired, more data can be provided for the remaining datasets, but this should be enough to provide a conversation about how to calculate these values.

Rod Stein

2022-03-08 00:08

developer   ~0016240

Fixed in Part 13 1.05 draft 7.
Accepting Archie's review of the calculation for Historian 3. Using value 7001.

Added to Errata part 13 1.04 draft 11.
Added to Errata part 13 1.03 draft 9.

Jim Luth

2022-03-10 16:08

administrator   ~0016303

Agreed to changes in VirtualF2F.

Issue History

Date Modified Username Field Change
2019-09-17 13:11 Matthias Isele New Issue
2019-10-25 16:51 Archie Miller Note Added: 0011174
2019-11-11 13:14 Srinivasu Jitta Note Added: 0011213
2019-11-26 16:50 Rod Stein Status new => assigned
2019-11-26 16:50 Rod Stein Assigned To => Rod Stein
2020-09-14 01:35 Rod Stein Status assigned => resolved
2020-09-14 01:35 Rod Stein Resolution open => fixed
2020-09-14 01:35 Rod Stein Fixed in Version => 1.05
2020-09-14 01:35 Rod Stein Note Added: 0012794
2020-09-14 18:24 Rod Stein Relationship added has duplicate 0005388
2020-09-15 18:14 Rod Stein Status resolved => feedback
2020-09-15 18:14 Rod Stein Resolution fixed => reopened
2020-09-15 18:14 Rod Stein Note Added: 0012836
2020-09-15 18:15 Rod Stein Status feedback => resolved
2020-09-15 18:15 Rod Stein Resolution reopened => fixed
2020-09-15 18:15 Rod Stein Note Added: 0012837
2020-11-02 17:17 Archie Miller Relationship added related to 0006205
2020-11-10 23:00 Archie Miller Relationship added related to 0006246
2021-09-17 00:19 Rod Stein Status resolved => feedback
2021-09-17 00:19 Rod Stein Resolution fixed => reopened
2021-09-17 00:20 Rod Stein Status feedback => resolved
2021-09-17 00:20 Rod Stein Note Added: 0014871
2021-12-09 14:38 Jim Luth Assigned To Rod Stein => Archie Miller
2021-12-09 14:38 Jim Luth Status resolved => assigned
2021-12-09 14:38 Jim Luth Note Added: 0015536
2022-01-04 22:57 Archie Miller Note Added: 0015672
2022-03-08 00:08 Rod Stein Assigned To Archie Miller => Rod Stein
2022-03-08 00:08 Rod Stein Status assigned => resolved
2022-03-08 00:08 Rod Stein Fixed in Version => 1.05
2022-03-08 00:08 Rod Stein Note Added: 0016240
2022-03-10 16:08 Jim Luth Status resolved => closed
2022-03-10 16:08 Jim Luth Fixed in Version 1.05 => 1.05.02 RC1
2022-03-10 16:08 Jim Luth Note Added: 0016303