6 Replies Latest reply on Oct 25, 2018 11:42 AM by Tomas Stark

    Problem with backfilling from SQL table with old data

    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