AnsweredAssumed Answered

RDBMS interface and duplicate values in PI

Question asked by larsoleruben on May 9, 2017
Latest reply on Nov 19, 2018 by GPolyak

Hi

We have a few RDBMS interfaces getting data from an SQL-Server once a day. Recently we have experienced duplicate entries in PI for points where the database value is null.

We have other data users, which purposedly crash when they encounter duplicate values as this should not be the case.

Is this behavior intended.

Se setting etc below:

 

Data in PI

 

duplicateAfExp.PNG

 

Data in the table from which we take the values

 

duplicateSqlExp.PNG

 

Interface setting, NOTE read before owerwrite. This should never happen, or?

 

duplicateRDBMSInterface.PNG

 

Thanks in advance

Outcomes