Store and Forward showing quarantined items

Ignition
1

Hi everyone,

I would just like to know whether if i enable the “Enterprise Tag History Synchronization” in Ignition Edge to point to a particular database and then additionally store history for tags under the MQTT Engine in the Central Ignition gateway to the same database , Would it cause Tags to be duplicated in the database?My store and Forward shows 6000 quarantined items.
Any help would be appreciated.

2

This seems to be the reason for the data being quarantined:

“Violation of PRIMARY KEY constraint ‘PK__sqlth_8___BE126DD1A7A8E16F’. Cannot insert duplicate key in object ‘dbo.sqlth_8_data’. The duplicate key value is (561, 1560863947713).”

3

This means you're trying to insert duplicate data, ie, values from the same tag at the exact same timestamp. It's not duplicating the actual tags - the opposite, in fact.

4

Ok , I understand what you are saying but I am still trying to figure out how values from the same tag are being inserted at the exact same timestamp. Could it be because of the reason I mentioned in my first post(regarding the enterprise tag history synchronization)?

5

Yes, I would say that’s most likely the cause. Choose a single mechanism you want to use to store history for those tags, or don’t have them store into the same database.

6

Ok Thanks, maybe i will try to disable the mechanism where i store history for the mqtt engine tags and just leave the enterprise tag history synchronization activated.

In the quarantine file that i imported long time back (on the 23rd April), i noticed that there are 3 providers in the quarantine file namely:
“MQTT Engine”
“edge”
“default”
Ideally there should only be one provider right?
I am pretty sure i have “MQTT engine” and “edge” as providers because i enabled history for both but i don’t understand “default” and why it is quarantined:

true 
  <scanclassset name="Default Historical" rate="2000" exectime="Tue Apr 23 11:16:04 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="default">
  </scanclassset>
  <scanclassset name="Default" rate="1000" exectime="Tue Apr 23 11:16:05 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="MQTT Engine">
     <value path="Edge Nodes/test/Witbank/trial001/001_MIXING_ERROR" datatype="1" mode="3" timesource="0" timestamp="2019-04-23 11:16:04" quality="192">123.03738</value>
  </scanclassset>
  <scanclassset name="Default Historical" rate="2000" exectime="Tue Apr 23 11:16:06 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="default">
  </scanclassset>
  <scanclassset name="Default" rate="1000" exectime="Tue Apr 23 11:16:06 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="MQTT Engine">
  </scanclassset>
  <scanclassset name="Default" rate="1000" exectime="Tue Apr 23 11:16:07 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="MQTT Engine">
  </scanclassset>
  <scanclassset name="Default Historical" rate="2000" exectime="Tue Apr 23 11:16:08 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="default">
  </scanclassset>
7

Also,i only see one tag out of many in the quarantine file that has similar values for the same timestamp and this only happened once.The same tag 001_MIXING_ERROR has different values for different timestamps elsewhere in the quarantine file( as do other tags).

            <scanclassset name="Default" rate="1000" exectime="Tue Apr 23 11:16:21 CAT 2019" gateway="Ignition-CSIVDIGNGATE01" provider="MQTT Engine">
                <value path="Edge Nodes/test/Witbank/trial001/001_MIXING_ERROR" datatype="1" mode="3" timesource="0" **timestamp="2019-04-23 11:16:20"** quality="192">152792.11</value>

             <scanclassset name="" rate="0" exectime="Tue Apr 23 11:16:23 CAT 2019" gateway="Ignition-CSIVDIGNGATE01 " provider="edge">
     <value path="Edge Nodes/test/Witbank/trial001/001_MIXING_ERROR" datatype="1" mode="3" timesource="1" **timestamp="2019-04-23 11:16:20"** quality="192">152792.109375</value>
  </scanclassset>
8

Also this is how the “default provider” was displayed at the beginning of the quarantine file:

<scanclassset name=“Default Historical” rate=“2000” exectime=“Tue Apr 23 11:16:02 CAT 2019” gateway=“Ignition-CSIVDIGNGATE01” provider="default"

value path=“CustomTags/System Pulse” datatype=“0” mode=“3” timesource=“1” timestamp=“2019-04-23 11:16:11” quality=“192”>true</value
** **

and then it displays with the following format for the rest of the quarantine file:
** <scanclassset name=“Default Historical” rate=“2000” exectime=“Tue Apr 23 11:16:04 CAT 2019” gateway=“Ignition-CSIVDIGNGATE01” provider=“default”**
** **