AnsweredAssumed Answered

Problem with backfilling from SQL table with old data

Question asked by Tomas Stark Champion on Oct 11, 2018
Latest reply on Oct 25, 2018 by Tomas Stark

Hi,

 

we try to backfill data to PI tags from a SQL database. It works fine, but some of the SQL data has timestamps older than 1970-01-01 00:00:00.

 

We can live with that, but when we try to backfill (or preview), PI SE will not accept the backfill even though we state the Start time to be 1970-01-01.

 

PI SE should check the Start Time, and if it is 1970-01-01 or later, backfilling should be possible even though there are older data in the SQL database.

 

181011 Backfill - Skärmklipp.JPG

 

Regards,

Tomas

Outcomes