# Store and Forward showing quarantined items

**URL:** <https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901>\
**Category:** Ignition\
**Created:** [June 18, 2019, 7:14am UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901 "2019-06-18T07:14:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![annr](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@annr](https://forum.inductiveautomation.com/u/annr)\
**Post date:** [June 18, 2019, 7:14am UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/1 "2019-06-18T07:14:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![annr](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@annr](https://forum.inductiveautomation.com/u/annr)\
**Post date:** [June 18, 2019, 1:29pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/2 "2019-06-18T13:29:02Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 18, 2019, 3:22pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/3 "2019-06-18T15:22:37Z")

</div>

> [@annr](#):
>
> “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.

---

<div class="post-metadata">

**Author:** ![annr](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@annr](https://forum.inductiveautomation.com/u/annr)\
**Post date:** [June 18, 2019, 3:35pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/4 "2019-06-18T15:35:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 18, 2019, 3:41pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/5 "2019-06-18T15:41:47Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![annr](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@annr](https://forum.inductiveautomation.com/u/annr)\
**Post date:** [June 19, 2019, 5:58am UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/6 "2019-06-19T05:58:59Z")

</div>

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>
```

---

<div class="post-metadata">

**Author:** ![annr](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@annr](https://forum.inductiveautomation.com/u/annr)\
**Post date:** [June 19, 2019, 11:13am UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/7 "2019-06-19T11:13:53Z")

</div>

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>
```

---

<div class="post-metadata">

**Author:** ![annr](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@annr](https://forum.inductiveautomation.com/u/annr)\
**Post date:** [June 19, 2019, 11:30am UTC](https://forum.inductiveautomation.com/t/store-and-forward-showing-quarantined-items/25901/8 "2019-06-19T11:30:11Z")

</div>

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