AnsweredAssumed Answered

RDBMS Interface sending Duplicate values

Question asked by ebelaski on Nov 8, 2018
Latest reply on Nov 9, 2018 by shillman

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

Outcomes