AnsweredAssumed Answered

Data Timestamp are differents between OPC HDA and PI : DST

Question asked by Dubus on Jul 6, 2018
Latest reply on Jul 9, 2018 by Dubus



We need to load old data (from 2005 to2015) in PI from a Historian DB. This with OPC HDA.

All the servers are in GMT+1 but when I do a recovery with PI ICU, the timestamp of data that are not in daylight are delayed of 1 hour.

Example : I recovered data from 29 october 2017 00:00 to 29 october 2017 05:00,

     the data from 00:00 to 02:59 are good,

     the data from 03:00 to 03:59 are lost in PI,

     the data from 04:00 to 05:00 are put in PI from 03:00 to 04:00.


It seems that PI ICU or PI does a conversion : he sees a no Daylight time and he retreive one hour.

But in PI HDA Tool on the server where I load with PI ICU, the data timestamp are good. It's only in PI SMT.


Did someone meet this problem ?


May be I can load daylight data first and load no daylight data with one hour offset...