3 Replies Latest reply on Jul 1, 2016 8:36 AM by larsoleruben

    Deleting Archive Values from PI SQL Commander



      I am trying to delete some archive values from PI using the PI SQL Commander from my local PC.

      I have the Buffer SubSystem running but I still get this error message when I try to delete:

      [PI SDK] Write failed.  Unbuffered write would desynchronize archive data. osi2720

      My delete is straigh forward:


      Delete FROM [piarchive].[picomp2] WHERE tag like '%WTUR.PwrAt.Tot' AND time BETWEEN '2016-06-23' AND '2016-06-28'


      Thanks Lars