Store and Forward showing quarantined items

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.

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).”

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.

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)?

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.

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>

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>

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”**
** **