# Duplicate driver entries in sqlth\_drv — partitions registered under old drvid, boundary value lookup returns empty (8.1.44)

**URL:** <https://forum.inductiveautomation.com/t/duplicate-driver-entries-in-sqlth-drv-partitions-registered-under-old-drvid-boundary-value-lookup-returns-empty-8-1-44/116451>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 18, 2026, 12:22am UTC](https://forum.inductiveautomation.com/t/duplicate-driver-entries-in-sqlth-drv-partitions-registered-under-old-drvid-boundary-value-lookup-returns-empty-8-1-44/116451 "2026-07-18T00:22:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![marlonf04](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@marlonf04](https://forum.inductiveautomation.com/u/marlonf04)\
**Post date:** [July 18, 2026, 12:22am UTC](https://forum.inductiveautomation.com/t/duplicate-driver-entries-in-sqlth-drv-partitions-registered-under-old-drvid-boundary-value-lookup-returns-empty-8-1-44/116451/1 "2026-07-18T00:22:11Z")

</div>

Hi all,

Running Ignition 8.1.44 with a SQL Server historian. Tag history queries return 0 rows with no error whenever the queried range doesn't contain an actual value change — the boundary/bounding value lookup isn't happening. In the Power Chart this shows up as Bad\_NotFound. Widening the range until it touches a real stored row makes the query work, so writes are fine.

Root cause found so far:

• sqlth\_drv has two entries for the same tag provider (ignition-pcmxpdwrpt01): id=1 with provider=NULL, and id=2 with provider=default. Presumably created when the provider identity string changed at some point. (Screenshot 1)

• All active tags are associated (via sqlth\_scinfo) with drvid=2 — 78 sts\_running tags, all under drvid=2, none under drvid=1. (Screenshot 2)

• sqlth\_partitions only contains partition records for drvid=1 — and those are current, up to today's partition (July 17). Zero rows for drvid=2. (Screenshots 3 and 4)

• Reproducible in the Script Console: a 2-hour queryTagHistory on a tag that has stored history returns with no exception. (Screenshot 5)

So the partition manager keeps registering daily partitions under the old driver id, while queries for the tags filter partitions by the new driver id, find none, and skip the boundary lookup entirely. Data is physically present in the sqlt\_data\_1\_\* tables.

Questions:

1. Is there a supported procedure to consolidate the duplicated driver rows in sqlth\_drv (or repoint sqlth\_scinfo / partition records) without corrupting existing history?

2. As a stopgap, is it safe to duplicate the partition rows into drvid=2 (INSERT copies of the drvid=1 rows)? It seems purely additive, but I'd rather confirm before touching historian metadata.

3. Any known trigger for the duplicate driver creation (gateway rename, backup restore, upgrade) so we can prevent recurrence?

Happy to share more queries/screenshots. Thanks!

 ![3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/1/c1eef12901b3c8a85cd3d8e30dc220e3e7cbe769.jpeg)

 ![1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/d/6d2414d1f5e1c460d787a96836327edfc6cbe1f4.jpeg)

 ![2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fb36ddcec303fa228513826a368255b655f299ba.jpeg)

 ![4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/4/04ed50ad195c0f27aa3d3d77afa7af2a1c72e41c.jpeg)

 ![5](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/d/ede0828b88612402dea91137bd8c26ad637b208d.jpeg)