# Trend sqlth\_scinfo and sqlth\_drv table duplicates added every x months **URL:** \ **Category:** Ignition\ **Created:** [July 10, 2020, 12:11am UTC](https://forum.inductiveautomation.com/t/trend-sqlth-scinfo-and-sqlth-drv-table-duplicates-added-every-x-months/36559 "2020-07-10T00:11:26Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 10, 2020, 12:11am UTC](https://forum.inductiveautomation.com/t/trend-sqlth-scinfo-and-sqlth-drv-table-duplicates-added-every-x-months/36559/1 "2020-07-10T00:11:26Z")
I seem to run into this issue every few months on a particular site, where they will suddenly lose visibility of all trend data. Adding an x-trace will show the trace in the far left of the chart and the date 1/1/1970. When I look in the `sqlth_scinfo` table, I then see additional rows now with multiple rows for the same `scname`s, and multiple of the same `provider` in the `sqlth_drv` table: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/e/deb922853959bdf9e85a3697edc60426417a492c.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/b/7bc3b29f756aa6c54816524795ac0fb12d0ffb7a.png) I used to be able to fix this by changing the drvid in the scinfo table to the latest in the drv table, but this doesn’t seem to work anymore… I also noticed that now I have a new “system” provider, so I tried adding a tag from the system provider, and this _does_ show the trend data now, even back months ago… I have a lot of trends scattered throughout the project though and don’t want a have to update every single tag path to use `[/.system]tag/path` instead of `tag/path` or `[~]tag/path`. Not sure how to diagnose this one! Edit: this time, changing the drvid’s in the sqlth\_scinfo table all to 4 (i.e. the latest drvid, excluding the ‘system’ provider). This is what I updated the table to, and now trend data is working correctly… Still want to get to the bottom of why it keeps destroying itself? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/3/a37dcb20361e78579587a8661c1071ef9775f32d.png) ---
**Author:** ![Tim.Johnson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim.johnson/32/10597_2.png) [@Tim.Johnson](https://forum.inductiveautomation.com/u/Tim.Johnson)\ **Post date:** [December 8, 2022, 6:53pm UTC](https://forum.inductiveautomation.com/t/trend-sqlth-scinfo-and-sqlth-drv-table-duplicates-added-every-x-months/36559/2 "2022-12-08T18:53:51Z")
@nminchin did you ever get an answer on this? I'm having the same issue on 8.1.7 and I'm wondering if upgrading to the current version (8.1.22) would prevent this from happening. I see you've had similar issues regarding this [here](https://forum.inductiveautomation.com/t/easychart-stops-displaying-data-periodically-new-entries-randomly-added-into-sqlth-scinfo/43280). Anyone from IA want to weigh in on this one? @paul-griffith ? ---
**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:** [December 9, 2022, 4:09pm UTC](https://forum.inductiveautomation.com/t/trend-sqlth-scinfo-and-sqlth-drv-table-duplicates-added-every-x-months/36559/3 "2022-12-09T16:09:37Z")
My suspicion from Nick's original post is that someone in the facility is restoring a gateway backup enabled, it's connecting to the same DB, and it's thus registering a whole 'new' set of historian providers. I can't really speak to your situation. I _would_ recommend contacting support. ---
**Author:** ![Gaurav.Shitole](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gaurav.shitole/32/72050_2.png) [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\ **Post date:** [February 14, 2023, 10:45am UTC](https://forum.inductiveautomation.com/t/trend-sqlth-scinfo-and-sqlth-drv-table-duplicates-added-every-x-months/36559/4 "2023-02-14T10:45:37Z")
Hello @nminchin Did you got this figured out? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [February 14, 2023, 11:12am UTC](https://forum.inductiveautomation.com/t/trend-sqlth-scinfo-and-sqlth-drv-table-duplicates-added-every-x-months/36559/5 "2023-02-14T11:12:15Z")
Ha, I only just saw this, and this actually might make sense. I think potentially I might have been VPNd into the site network, and unknowingly had my local ignition gateway running which then connected to the site db. It's not often I have my local gateway actually running, and even more rare that I would have this site's gateway restored, but it's not completely unfeasible.. I only hear about the issue very occasionally, maybe once a year or so