# Remove Historical Tag Providers

**URL:** <https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426>\
**Category:** Ignition\
**Created:** [May 30, 2017, 9:41pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426 "2017-05-30T21:41:38Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![richard040693](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@richard040693](https://forum.inductiveautomation.com/u/richard040693)\
**Post date:** [May 30, 2017, 9:41pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/1 "2017-05-30T21:41:38Z")

</div>

I’m working on a new application, but I was working on a old gateway. I need to Debug all things for the previous gateway. I deleted almost all configurations. But I can’t remove “Historical Tag Providers”.

This is my problem I need to remove this configuration. Is there any solution?

Thanks

---

<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:** [May 30, 2017, 10:32pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/2 "2017-05-30T22:32:23Z")

</div>

Historical providers are automatically created for each database connection. If you remove the database connection with the same name, the history provider will be deleted.

---

<div class="post-metadata">

**Author:** ![zackscriven](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zackscriven/32/7213_2.png) [@zackscriven](https://forum.inductiveautomation.com/u/zackscriven)\
**Post date:** [May 30, 2017, 10:43pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/3 "2017-05-30T22:43:17Z")

</div>

you can (and should) disable historical tag providers for any database connections you don’t want to store tag history to.

Personally I create a schema called historian, and use that explicitly for storing tag history.

---

<div class="post-metadata">

**Author:** ![richard040693](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@richard040693](https://forum.inductiveautomation.com/u/richard040693)\
**Post date:** [May 31, 2017, 2:12pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/4 "2017-05-31T14:12:48Z")

</div>

Thanks

I already delete the database conections tha I don’t need, but still don’t delete.

---

<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:** [May 31, 2017, 3:17pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/5 "2017-05-31T15:17:05Z")

</div>

If the relevant historical connections have already been deleted, then it’s possible the internal database hasn’t been updated. Send an email to [support@inductiveautomation.com](mailto:support@inductiveautomation.com) and we’ll be able to take a look.

---

<div class="post-metadata">

**Author:** ![john.eichler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.eichler/32/24632_2.png) [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\
**Post date:** [August 2, 2019, 4:31am UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/6 "2019-08-02T04:31:14Z")

</div>

Hi.

I have the same problem. See attached. I deleted the old MySQL database connection but the datasource history provider remains. Please can you show me how to delete it?

Thanks!

ignition 8

 ![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b25746ba920d7675928df78c2045e51f0993d086.png)

---

<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:** [August 2, 2019, 3:08pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/7 "2019-08-02T15:08:37Z")

</div>

The easy fix is just to create a non-working database connection with the same name as the one you want to delete, and then delete that new database connection. That should automatically remove the history provider as well.

---

<div class="post-metadata">

**Author:** ![john.eichler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.eichler/32/24632_2.png) [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\
**Post date:** [August 4, 2019, 7:41pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/8 "2019-08-04T19:41:55Z")

</div>

Thanks for the reply. I tried your suggestion. Unfortunately, this created a new history provider with the same name. At this point I had two history providers called “delete\_me”. I then deleted the database connection of the same name and I was left with one history provider called “delete\_me”.

Any other ideas?

Thanks

---

<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:** [August 5, 2019, 4:19pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/9 "2019-08-05T16:19:24Z")

</div>

The other avenue involves going into the internal database, which is inherently risky. If you’re not comfortable, or not willing to take the risk, then I would suggest contacting support.  
If you do just want to do it, then:

1. Get a gateway backup. This should always be your first step when doing any significant modification, but especially when directly affecting the internal database.
2. Navigate to the “Status” section of the gateway web interface. Then add `sys.internaldb` to the path in the URL bar, so you’re navigating to something like `http://localhost:8088/web/status/sys.internaldb`
3. Run a query to find the ID of the provider record you need to delete, in the query box:  
`select TAGHISTORYPROVIDEREP_ID, NAME, ENABLED, TYPE, DESCRIPTION from TAGHISTORYPROVIDEREP;`
4. Run the appropriate delete query to remove that record.

---

<div class="post-metadata">

**Author:** ![john.eichler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/john.eichler/32/24632_2.png) [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\
**Post date:** [August 5, 2019, 7:35pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/10 "2019-08-05T19:35:04Z")

</div>

Perfect! Easy fix. Thanks for your help.

---

<div class="post-metadata">

**Author:** ![dkeith](https://avatars.discourse-cdn.com/v4/letter/d/91b2a8/32.png) [@dkeith](https://forum.inductiveautomation.com/u/dkeith)\
**Post date:** [June 25, 2020, 1:48pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/11 "2020-06-25T13:48:11Z")

</div>

The status/sys.internaldb looks like a (nice) undocumented feature. Are there other sys.% functions? Any way to have this database query use a different db connection?

---

<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 25, 2020, 2:46pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/12 "2020-06-25T14:46:18Z")

</div>

Nothing else that’s hidden. The internal DB access point is mostly there for support; it’s a lot easier to use that than try to install SQLite binaries onto customer’s systems.

And no way to retarget it to a different connection, although recent versions of 8.0 have a bundled SQLite database connection type and driver that you could use to talk to other SQLite dbs. I would definitely not recommend trying to point it at any active Ignition system’s `config.idb` file, though.

---

<div class="post-metadata">

**Author:** ![Fades3d](https://avatars.discourse-cdn.com/v4/letter/f/f6c823/32.png) [@Fades3d](https://forum.inductiveautomation.com/u/Fades3d)\
**Post date:** [April 27, 2021, 9:07pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/13 "2021-04-27T21:07:36Z")

</div>

> [@paul-griffith](#):
>
> Run the appropriate delete query to remove that record

What would be the appropriate delete query? Or what might that look like?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 27, 2021, 9:19pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/14 "2021-04-27T21:19:43Z")

</div>

> [@Fades3d](#):
>
> What would be the appropriate delete query?

You cut off Paul's warning:

> [@paul-griffith](#):
>
> f you’re not comfortable, or not willing to take the risk, then I would suggest contacting support.

If you aren't comfortable looking at the data in the the config DB and cannot construct a relevant delete query, you _ **really** _ need to work through support.

---

<div class="post-metadata">

**Author:** ![Fades3d](https://avatars.discourse-cdn.com/v4/letter/f/f6c823/32.png) [@Fades3d](https://forum.inductiveautomation.com/u/Fades3d)\
**Post date:** [April 27, 2021, 9:45pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/15 "2021-04-27T21:45:15Z")

</div>

Thanks, but I am not worried about my local project. I have a backup of it. Just looking for some help. Appreciate your input.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [April 28, 2021, 12:12am UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/16 "2021-04-28T00:12:50Z")

</div>

> **[Let Me Google That](https://letmegooglethat.com/?q=delete%2Bquery%2Bexample)**
>
> For all those people that find it more convenient to bother you with their question than to google it for themselves.

On a serious note, if you can’t come up with the delete statement on your own you should call support. Which is what was stated to you above.

---

<div class="post-metadata">

**Author:** ![Fades3d](https://avatars.discourse-cdn.com/v4/letter/f/f6c823/32.png) [@Fades3d](https://forum.inductiveautomation.com/u/Fades3d)\
**Post date:** [April 28, 2021, 11:43am UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/17 "2021-04-28T11:43:10Z")

</div>

So sorry. Did not mean to “bother” you all.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [April 28, 2021, 1:34pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/18 "2021-04-28T13:34:32Z")

</div>

That was a joke. @paul-griffith was warning you if you don’t know call IA support. Since you asked how to write the query that means you don’t know. Please call IA support. Or, use my link to find help on writing a delete query. Example:

```auto
DELETE FROM table_name WHERE condition;

```

---

<div class="post-metadata">

**Author:** ![Ivan\_H](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ivan_h/32/28186_2.png) [@Ivan\_H](https://forum.inductiveautomation.com/u/Ivan_H)\
**Post date:** [September 29, 2021, 4:34am UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/20 "2021-09-29T04:34:01Z")

</div>

Works fine, thank you very much.

---

<div class="post-metadata">

**Author:** ![curtisfennell](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/curtisfennell/32/39017_2.png) [@curtisfennell](https://forum.inductiveautomation.com/u/curtisfennell)\
**Post date:** [May 26, 2022, 7:49pm UTC](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426/21 "2022-05-26T19:49:38Z")

</div>

I appear to be having a similar issue.

Showing up in store and forward as “Tag History Data”.

I deleted the tag history provider as you described “OKBoilerData”, but still see theses coming in:

```auto
-<cachedata creationTime="Thu May 26 14:46:44 CDT 2022" sourceStore="OKBoilerData">

-<data subtype="" flavor=" __datasourcedata__">

<base64> ETC...../base64>

</data>

</cachedata>

```

[Next page](https://forum.inductiveautomation.com/t/remove-historical-tag-providers/14426.md?page=2)