# \#database **URL:** https://forum.inductiveautomation.com/tag/database/11.md [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) --- ## [8.3.6 Perspective Alarms not displaying properly in UI](https://forum.inductiveautomation.com/t/8-3-6-perspective-alarms-not-displaying-properly-in-ui/117078)
**Author:** [@bpruitt](https://forum.inductiveautomation.com/u/bpruitt)\ **Replies:** 2\ **Last updated:** [September 29, 2026, 10:05pm UTC](https://forum.inductiveautomation.com/t/8-3-6-perspective-alarms-not-displaying-properly-in-ui/117078 "2026-09-29T22:05:37Z")
Currently having an issue with the "Alarm UI" (AlarmStatusTable & AlarmJournalTable). For the most part, our alarms have had no issues, but we've noticed two issues: The built-in filtering is having priority issues and… --- ## [Automation Professionals' Blob Server Module](https://forum.inductiveautomation.com/t/automation-professionals-blob-server-module/57970)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 134\ **Last updated:** [September 11, 2026, 3:12pm UTC](https://forum.inductiveautomation.com/t/automation-professionals-blob-server-module/57970 "2026-09-11T15:12:27Z")
Automation Professionals is pleased to announce an alpha release of its new Blob Server Module. Available only for Ignition v8.1, here. The Blob Server Module provides a simple way to deliver images, PDF files, or othe… --- ## [Historian Tag Group in Driven Mode Occasionally Missing One-Second Sample](https://forum.inductiveautomation.com/t/historian-tag-group-in-driven-mode-occasionally-missing-one-second-sample/117009)
**Author:** [@pramod\_thorat1](https://forum.inductiveautomation.com/u/pramod_thorat1)\ **Replies:** 1\ **Last updated:** [September 7, 2026, 1:02pm UTC](https://forum.inductiveautomation.com/t/historian-tag-group-in-driven-mode-occasionally-missing-one-second-sample/117009 "2026-09-07T13:02:24Z")
Currently, I am facing an intermittent issue with Ignition Tag Historian. I have configured a Driven Tag Group with a Boolean trigger tag that remains TRUE while the machine is running. The historian is configured to rec… --- ## [Time Series Database Cache Module](https://forum.inductiveautomation.com/t/time-series-database-cache-module/14110)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 3\ **Last updated:** [August 31, 2026, 4:07pm UTC](https://forum.inductiveautomation.com/t/time-series-database-cache-module/14110 "2026-08-31T16:07:11Z")
Ignition v7.9 introduced a few changes in the gateway module hook methods that broke the configuration pages for this module's cache tuning parameters. My module sales page has links to both new and legacy versions. Pl… --- ## [system.tag.storeTagHistory() appears to corrupt sqlth\_partitions metadata when backfilling historical data](https://forum.inductiveautomation.com/t/system-tag-storetaghistory-appears-to-corrupt-sqlth-partitions-metadata-when-backfilling-historical-data/116879)
**Author:** [@byar](https://forum.inductiveautomation.com/u/byar)\ **Replies:** 0\ **Last updated:** [August 24, 2026, 5:56pm UTC](https://forum.inductiveautomation.com/t/system-tag-storetaghistory-appears-to-corrupt-sqlth-partitions-metadata-when-backfilling-historical-data/116879 "2026-08-24T17:56:48Z")
I'm attempting to backfill history for a newly-created Dew Point tag. System Architecture Ignition 8.1.x (currently 8.1.53) HVAC system with Temperature and Relative Humidity historized for several months Dew Point was… --- ## [Impact of Scheduled Windows 11 Antivirus Scans on Ignition windows Temporary Files](https://forum.inductiveautomation.com/t/impact-of-scheduled-windows-11-antivirus-scans-on-ignition-windows-temporary-files/116857)
**Author:** [@pramod\_thorat1](https://forum.inductiveautomation.com/u/pramod_thorat1)\ **Replies:** 3\ **Last updated:** [August 21, 2026, 1:46pm UTC](https://forum.inductiveautomation.com/t/impact-of-scheduled-windows-11-antivirus-scans-on-ignition-windows-temporary-files/116857 "2026-08-21T13:46:22Z")
I plan to schedule antivirus scans on a Windows 11 machine running an Ignition Gateway with multiple modules. The antivirus vendor is not finalized yet. My main concern is whether including Windows/Java/Ignition tempora… --- ## [Chart Data Disappearing after Data Migration](https://forum.inductiveautomation.com/t/chart-data-disappearing-after-data-migration/116381)
**Author:** [@jhavelka](https://forum.inductiveautomation.com/u/jhavelka)\ **Replies:** 1\ **Last updated:** [August 12, 2026, 2:39pm UTC](https://forum.inductiveautomation.com/t/chart-data-disappearing-after-data-migration/116381 "2026-08-12T14:39:53Z")
I'm working on migrating data in our database from a transaction group table to a historian table. The historian table already has data for roughly the 2nd half of the month in this example (starting November 11, 2025), … --- ## [Stored NULL values come back as 0.0 from history queries (SQL Historian and SDK historians)](https://forum.inductiveautomation.com/t/stored-null-values-come-back-as-0-0-from-history-queries-sql-historian-and-sdk-historians/116753)
**Author:** [@sam.donche](https://forum.inductiveautomation.com/u/sam.donche)\ **Replies:** 0\ **Last updated:** [August 11, 2026, 3:07pm UTC](https://forum.inductiveautomation.com/t/stored-null-values-come-back-as-0-0-from-history-queries-sql-historian-and-sdk-historians/116753 "2026-08-11T15:07:11Z")
We're building a custom historian module for timescaledb on the 8.3 Historian SDK (gateway 8.3.3) and got a bug report that NULL values in history read back as 0.0. After digging in, it turns out this isn't specific to o… --- ## [Gateway mySQL Connection](https://forum.inductiveautomation.com/t/gateway-mysql-connection/116486)
**Author:** [@gavinw0606](https://forum.inductiveautomation.com/u/gavinw0606)\ **Replies:** 1\ **Last updated:** [July 22, 2026, 7:16pm UTC](https://forum.inductiveautomation.com/t/gateway-mysql-connection/116486 "2026-07-22T19:16:48Z")
Hi all, I'm having some issues connecting my database to my gateway and was hoping someone could help. I'm using Ignition 8.3.0 and attempting to connect to an internal mySQL database in which I've previously connected t… --- ## [Ignition Machine Learning](https://forum.inductiveautomation.com/t/ignition-machine-learning/114992)
**Author:** [@kennethandradeom](https://forum.inductiveautomation.com/u/kennethandradeom)\ **Replies:** 2\ **Last updated:** [July 9, 2026, 12:32am UTC](https://forum.inductiveautomation.com/t/ignition-machine-learning/114992 "2026-07-09T00:32:24Z")
Hi, my name is Kenneth, I am working with Ignition Machine Learning Manager and I have historical tag data (temperature and humidity) collected over several months. My goal is to build a model that can predict future va… --- ## [readBlocking vs readValues](https://forum.inductiveautomation.com/t/readblocking-vs-readvalues/116232)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 4\ **Last updated:** [July 1, 2026, 3:32pm UTC](https://forum.inductiveautomation.com/t/readblocking-vs-readvalues/116232 "2026-07-01T15:32:18Z")
Looking for best practices advice and make sure I understand my options better. A PLC updates two specific registers and then latches a trigger bit telling Ignition data is ready to be stored in the database. I want to … --- ## [runPrepUpdate uses default database instead of the specified database](https://forum.inductiveautomation.com/t/runprepupdate-uses-default-database-instead-of-the-specified-database/115992)
**Author:** [@ddam](https://forum.inductiveautomation.com/u/ddam)\ **Replies:** 3\ **Last updated:** [June 16, 2026, 3:28pm UTC](https://forum.inductiveautomation.com/t/runprepupdate-uses-default-database-instead-of-the-specified-database/115992 "2026-06-16T15:28:46Z")
Context: I'm running Ignition v8.3.3 I have two database connections defined in the Gateway: "TA\_Recipes" and "Ignition\_DB" "TA Recipes" is set as default database in the project. In one of the button script, I need to… --- ## [Storing and Retrieving UTC from Database](https://forum.inductiveautomation.com/t/storing-and-retrieving-utc-from-database/115885)
**Author:** [@Zachary\_Kacel1](https://forum.inductiveautomation.com/u/Zachary_Kacel1)\ **Replies:** 18\ **Last updated:** [June 9, 2026, 12:32pm UTC](https://forum.inductiveautomation.com/t/storing-and-retrieving-utc-from-database/115885 "2026-06-09T12:32:32Z")
I have a system than where the Ignition Server is setup in Eastern Time and the Database MSSQL is setup in Eastern Time. I have a project that will run where clients will be in more than one time zone. Due to how many p… --- ## [Store and forward - old data from 2014](https://forum.inductiveautomation.com/t/store-and-forward-old-data-from-2014/115878)
**Author:** [@vahelduvool](https://forum.inductiveautomation.com/u/vahelduvool)\ **Replies:** 4\ **Last updated:** [June 8, 2026, 6:27pm UTC](https://forum.inductiveautomation.com/t/store-and-forward-old-data-from-2014/115878 "2026-06-08T18:27:32Z")
I have problem where old data is popping up in database table. I think tag values are right but time stamps are way in the past. I have managed to pinpoint issue in database, table with name "sqlt\_data\_1\_20140407". In th… --- ## [Log a datapoint in data](https://forum.inductiveautomation.com/t/log-a-datapoint-in-data/115847)
**Author:** [@olefredrik.kvalnes](https://forum.inductiveautomation.com/u/olefredrik.kvalnes)\ **Replies:** 0\ **Last updated:** [June 4, 2026, 12:33pm UTC](https://forum.inductiveautomation.com/t/log-a-datapoint-in-data/115847 "2026-06-04T12:33:26Z")
Hi. I was upgrading from ignition 8.1 to 8.3 and read in the Upgrade Manual (link) that should replace some history functions due to deprecation. I was using system.tag.storeTagHistory(histProv, tagProv, paths, values) … --- ## [Gatway tag change script, getting id from db best practice](https://forum.inductiveautomation.com/t/gatway-tag-change-script-getting-id-from-db-best-practice/115677)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 5\ **Last updated:** [May 23, 2026, 7:55pm UTC](https://forum.inductiveautomation.com/t/gatway-tag-change-script-getting-id-from-db-best-practice/115677 "2026-05-23T19:55:57Z")
I have a bunch of variable names in a database by id, then I read the database and create the tags in a folder. no udt, its just singular values, they only change once a week so not high frequency of change. I have a ta… --- ## [Copy sql table data](https://forum.inductiveautomation.com/t/copy-sql-table-data/115589)
**Author:** [@ricardo.linares](https://forum.inductiveautomation.com/u/ricardo.linares)\ **Replies:** 11\ **Last updated:** [May 22, 2026, 5:00pm UTC](https://forum.inductiveautomation.com/t/copy-sql-table-data/115589 "2026-05-22T17:00:50Z")
Hello, new to this forum and to ignition but learning my way around. Need advice on or guidance to documentation to accomplish the following: I have a SQL table called recipenames and three other tables recipe1, recipe… --- ## [Phantom Alarm showing up after being deleted](https://forum.inductiveautomation.com/t/phantom-alarm-showing-up-after-being-deleted/115621)
**Author:** [@Jacob\_N](https://forum.inductiveautomation.com/u/Jacob_N)\ **Replies:** 1\ **Last updated:** [May 20, 2026, 5:09pm UTC](https://forum.inductiveautomation.com/t/phantom-alarm-showing-up-after-being-deleted/115621 "2026-05-20T17:09:22Z")
Hello I have some tags that have alarms that show up when they are fired. If I fire that tag to trigger the alarm I get the alarm. However for some reason I get the alarm again 10-11 seconds later. Heres what I tried to … --- ## [End Tag Historian table and start new one](https://forum.inductiveautomation.com/t/end-tag-historian-table-and-start-new-one/115491)
**Author:** [@joshua.edwards.navy](https://forum.inductiveautomation.com/u/joshua.edwards.navy)\ **Replies:** 6\ **Last updated:** [May 15, 2026, 12:09pm UTC](https://forum.inductiveautomation.com/t/end-tag-historian-table-and-start-new-one/115491 "2026-05-15T12:09:40Z")
I am currently planning out how to best handle separating out client data. The most obvious answer is to pay for several databases, but I was curious if there was some way to have one database and somehow have different … --- ## [How to Improve MSSQL Historian Query Performance?](https://forum.inductiveautomation.com/t/how-to-improve-mssql-historian-query-performance/106426)
**Author:** [@r123](https://forum.inductiveautomation.com/u/r123)\ **Replies:** 36\ **Last updated:** [May 15, 2026, 12:11am UTC](https://forum.inductiveautomation.com/t/how-to-improve-mssql-historian-query-performance/106426 "2026-05-15T00:11:35Z")
The application currently has about 8,000 tags and that number could increase significantly. Using the system.tag.queryTagHistory() function, retrieving all available samples from just the previous minute takes approxim… --- ## [Migrate history database from MySQL to PostgreSQL with timescaleDB extention](https://forum.inductiveautomation.com/t/migrate-history-database-from-mysql-to-postgresql-with-timescaledb-extention/115510)
**Author:** [@olefredrik.kvalnes](https://forum.inductiveautomation.com/u/olefredrik.kvalnes)\ **Replies:** 0\ **Last updated:** [May 13, 2026, 1:24pm UTC](https://forum.inductiveautomation.com/t/migrate-history-database-from-mysql-to-postgresql-with-timescaledb-extention/115510 "2026-05-13T13:24:27Z")
Hello everyone, I’m working on a project where we originally used MySQL 8.4 as the history database on the same host as Ignition. However, after some changes in scope, the customer now wants to move the history storage … --- ## [Whats best practice for multiple connections to the same database](https://forum.inductiveautomation.com/t/whats-best-practice-for-multiple-connections-to-the-same-database/115498)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 4\ **Last updated:** [May 13, 2026, 12:05pm UTC](https://forum.inductiveautomation.com/t/whats-best-practice-for-multiple-connections-to-the-same-database/115498 "2026-05-13T12:05:51Z")
One of our sites is running 8.1.44, has one database and a multiple connections to that database. One connection per project for a total of about 30+ ish. Going back to my 7.7 days, I recall this being an issue with the… --- ## [Slow Loading of Reports After Historical Data Migration](https://forum.inductiveautomation.com/t/slow-loading-of-reports-after-historical-data-migration/115440)
**Author:** [@abae](https://forum.inductiveautomation.com/u/abae)\ **Replies:** 0\ **Last updated:** [May 7, 2026, 5:14pm UTC](https://forum.inductiveautomation.com/t/slow-loading-of-reports-after-historical-data-migration/115440 "2026-05-07T17:14:32Z")
Ignition v8.1.36 I have a report that takes several minutes to load for all days before a certain date. The report looks at historical data for 1 day at 15-minute intervals (so query should return 96 data points per day… --- ## [SQL Server OLTP for sqlth\_sce Table?](https://forum.inductiveautomation.com/t/sql-server-oltp-for-sqlth-sce-table/115290)
**Author:** [@Ahiero](https://forum.inductiveautomation.com/u/Ahiero)\ **Replies:** 1\ **Last updated:** [May 4, 2026, 4:54pm UTC](https://forum.inductiveautomation.com/t/sql-server-oltp-for-sqlth-sce-table/115290 "2026-05-04T16:54:54Z")
We have failed transactions in the sqlth\_sce table regularly and I am looking for a solution. There are about 1000 rows in the SCE table. We use some driven scan classes that execute at 100ms so I expect it to grow slo… --- ## [Perspective SCADA database](https://forum.inductiveautomation.com/t/perspective-scada-database/113982)
**Author:** [@Arr](https://forum.inductiveautomation.com/u/Arr)\ **Replies:** 19\ **Last updated:** [April 21, 2026, 8:45am UTC](https://forum.inductiveautomation.com/t/perspective-scada-database/113982 "2026-04-21T08:45:31Z")
Hi, I am developing a SCADA system for up to 4000 tags in total to show the trends of and about 400 parameters for recipes in total. My question is which type of database (e.g. Postgre, MSSQL) is the best? SCADA will no… --- ## [Forwarding historian data across gateway network](https://forum.inductiveautomation.com/t/forwarding-historian-data-across-gateway-network/115032)
**Author:** [@will\_schreiner](https://forum.inductiveautomation.com/u/will_schreiner)\ **Replies:** 2\ **Last updated:** [April 13, 2026, 1:34pm UTC](https://forum.inductiveautomation.com/t/forwarding-historian-data-across-gateway-network/115032 "2026-04-13T13:34:37Z")
Hello, I am in the process of trying to see how to best utilize the gateway network to move data from individual gateways to a central gateway and to SQL database connected to it. This is still early testing, so this is… --- ## [Serial Number checks](https://forum.inductiveautomation.com/t/serial-number-checks/114787)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 16\ **Last updated:** [March 31, 2026, 11:52pm UTC](https://forum.inductiveautomation.com/t/serial-number-checks/114787 "2026-03-31T23:52:20Z")
I have a system that goes through about 30 serial numbers per batch, at the current time the operator is scanning in the serial numbers into the system. To prevent duplicate serial numbers from being scanned, I want to t… --- ## [Saving user configuration property object to SQL nvarchar and retrieving it again](https://forum.inductiveautomation.com/t/saving-user-configuration-property-object-to-sql-nvarchar-and-retrieving-it-again/114444)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 16\ **Last updated:** [March 19, 2026, 1:22pm UTC](https://forum.inductiveautomation.com/t/saving-user-configuration-property-object-to-sql-nvarchar-and-retrieving-it-again/114444 "2026-03-19T13:22:07Z")
I'm suffering from Engineer's Block. (Well, if writer's can suffer their version then why can't we. Try it on your boss.) My application has some user configuration checkboxes linked to a \`view.custom.mainTableShowColum… --- ## [Extremely Slow Queries with TimescaleDB with Many Chunks](https://forum.inductiveautomation.com/t/extremely-slow-queries-with-timescaledb-with-many-chunks/106233)
**Author:** [@osdcastillo02](https://forum.inductiveautomation.com/u/osdcastillo02)\ **Replies:** 3\ **Last updated:** [March 17, 2026, 12:35pm UTC](https://forum.inductiveautomation.com/t/extremely-slow-queries-with-timescaledb-with-many-chunks/106233 "2026-03-17T12:35:50Z")
I've been working extensively over the past month to optimize the performance of TimescaleDB with Ignition's historical queries, but I'm encountering significant performance bottlenecks with one particular query. The pr… --- ## [Power Chart not showing loss of connection to Remote Tag Provider](https://forum.inductiveautomation.com/t/power-chart-not-showing-loss-of-connection-to-remote-tag-provider/114483)
**Author:** [@jimin.mathew](https://forum.inductiveautomation.com/u/jimin.mathew)\ **Replies:** 4\ **Last updated:** [March 16, 2026, 2:06pm UTC](https://forum.inductiveautomation.com/t/power-chart-not-showing-loss-of-connection-to-remote-tag-provider/114483 "2026-03-16T14:06:45Z")
Hi everyone, I’m currently troubleshooting a behavior in a distributed Ignition architecture and want to see if there’s a way for handling the powerchart when a data source goes offline. The Setup: Central Gateway: … [Next page](https://forum.inductiveautomation.com/tag/database/11.md?match_all_tags=true&page=1&tags%5B%5D=database)