5 Replies Latest reply on Nov 9, 2018 10:10 PM by shillman

    RDBMS Interface sending Duplicate values

    ebelaski

      Hello PI Square community.
      I have yet another RDBMS interface duplicates issue to post. This is the latest version of the interface.
      The PI Server is collecting duplicate values for many points and I am not sure how or why. The duplication is not consistent and the duplicate values repeats about 50 times in 5 minutes and then not again for a while.

       

      I have the following settings for all points:
      Location 2=1 and Location 5=0;
      Exception and compression are both set to zero.
      Read Before Overwrite is checked.

      Scan setting is set to 1 minute and there are approximately 1000 points.

       

      Can anyone advice on a why the duplicates are occurring?

      Thanks!

       

      InkedImage 001_LI.jpg

       

      Here is the query:

      SELECT TagDateTimeStamp, TagName, PiValue, 0 FROM [MyReportDB].[dbo].[vRTValues]
      WHERE DATEADD(HOUR, 1, TagDateTimeStamp) > ? ORDER BY TagDateTimeStamp ASC; P1=TS
      

       

      I receive the following messages in the log file:

      I 08-Nov-18 08:41:00 pibufss:pisnapmgr[MYPICOLLECTIVE] (18004)
       >> Cannot coerce or compress an event. Will send the event to the server with its original data type and mode: [-109]
       Value at This Time Already Exists
       ptid: 39384, time: 8-Nov-18 07:45:00, type: 13, value: S,O,A,S,Q [0,0,0,0,0]: 5938.95, 5938.95
      I 08-Nov-18 08:41:00 pibufss:pisnapmgr[MYPICOLLECTIVE] (18004)
       >> Cannot coerce or compress an event. Will send the event to the server with its original data type and mode: [-109]
       Value at This Time Already Exists
       ptid: 39755, time: 8-Nov-18 07:45:00, type: 13, value: S,O,A,S,Q [0,0,0,0,0]: 1051.93, 1051.93
      I 08-Nov-18 08:41:00 pibufss:pisnapmgr[MYPICOLLECTIVE] (18004)
       >> Cannot coerce or compress an event. Will send the event to the server with its original data type and mode: [-109]
       Value at This Time Already Exists
       ptid: 40143, time: 8-Nov-18 07:45:00, type: 13, value: S,O,A,S,Q [0,0,0,0,0]: 120742, 120742
      I 08-Nov-18 08:41:00 pibufss:pisnapmgr[MYPICOLLECTIVE] (18004)
       >> Cannot coerce or compress an event. Will send the event to the server with its original data type and mode: [-109]
       Value at This Time Already Exists
       ptid: 39123, time: 8-Nov-18 07:45:00, type: 13, value: S,O,A,S,Q [0,0,0,0,0]: 622.133, 622.133
      I 08-Nov-18 08:41:00 pibufss:pisnapmgr[MYPICOLLECTIVE] (18004)
       >> Cannot coerce or compress an event. Will send the event to the server with its original data type and mode: [-109]
       Value at This Time Already Exists
       ptid: 39386, time: 8-Nov-18 07:45:00, type: 13, value: S,O,A,S,Q [0,0,0,0,0]: 5373.46, 5373.46