# How to create sqlth\_te manualy **URL:** \ **Category:** Ignition\ **Created:** [November 3, 2025, 1:05pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891 "2025-11-03T13:05:59Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Jesus\_Mariano\_Moreno](https://avatars.discourse-cdn.com/v4/letter/j/57b2e6/32.png) [@Jesus\_Mariano\_Moreno](https://forum.inductiveautomation.com/u/Jesus_Mariano_Moreno)\ **Post date:** [November 3, 2025, 1:05pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/1 "2025-11-03T13:05:59Z")
Hi, I have a project with a remote tag provider ALB08ED with tags configured to use the history provider ALB08ED\_DB. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/5/959d498d685e2ac89310d436864a0dc7fc0bd080.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/1/918de05cb38f61f6997a91170e58111a673593ab.png) The database connection status is "Valid" and is named ALB08ED\_DB, but it has not automatically generated the Ignition Auto-Generated Tables (sqlth\_te, sqlth\_scinfo, ...). ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/8/386d8ed4231d5823b5de596bc3d52afe13924e32.png) Is there any way to force the creation of the tables? ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [November 3, 2025, 1:12pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/2 "2025-11-03T13:12:37Z")
Create a “seed” history tag pointed at it. When we are prepping new gateways and historians I create an expression tag tied to now() for its value and set it up as a history tag pointed at the newly created historian instance. That will trigger the creation of all of the history tables. ---
**Author:** ![Jesus\_Mariano\_Moreno](https://avatars.discourse-cdn.com/v4/letter/j/57b2e6/32.png) [@Jesus\_Mariano\_Moreno](https://forum.inductiveautomation.com/u/Jesus_Mariano_Moreno)\ **Post date:** [November 3, 2025, 3:00pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/3 "2025-11-03T15:00:54Z")
I have created It, but it doesn’t work, ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/c/4c80f19d38bacbe600de677fe3f966b26745112c.png) Any other idea? ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [November 3, 2025, 3:19pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/4 "2025-11-03T15:19:38Z")
Try setting Deadband Style = Discreet. > **[Configuring Tag History | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.3/ignition-modules/tag-historian/configuring-tag-history#deadband-discrete-style-and-analog-compression)** > > You can log historical data by enabling history on individual tags. Once enabled, tag values are stored using a configured historian provider. Depending on the provider, data may be routed through the Store and Forward system or written directly to... ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [November 3, 2025, 3:31pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/5 "2025-11-03T15:31:17Z")
Change the expression on the tag to be `getSecond(now(1000))` It needs to see a tag value change I believe. If it still doesn’t work, go to the gateway web page, status, logs and see if there are any database errors? ---
**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:** [November 3, 2025, 3:31pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/6 "2025-11-03T15:31:44Z")
> [@Transistor](#): > > Discreet Oooo! New security option in v8.3? 🤪 /me runs away... ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [November 3, 2025, 4:08pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/7 "2025-11-03T16:08:54Z")
> [@Transistor](#): > > Discreet Ha! My spill chick wouldn't even have picked that up. Believe it or not, I know the difference! Discrete! ---
**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:** [November 3, 2025, 9:23pm UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/8 "2025-11-03T21:23:32Z")
> [@Transistor](#): > > My spill chick She’s obviously not telling you some things on purpose. Time to get a new spill chick I think. Unless it’s the New Zealand or maybe Irish pronunciation spelling? ---
**Author:** ![Jesus\_Mariano\_Moreno](https://avatars.discourse-cdn.com/v4/letter/j/57b2e6/32.png) [@Jesus\_Mariano\_Moreno](https://forum.inductiveautomation.com/u/Jesus_Mariano_Moreno)\ **Post date:** [November 4, 2025, 11:23am UTC](https://forum.inductiveautomation.com/t/how-to-create-sqlth-te-manualy/111891/9 "2025-11-04T11:23:33Z")
Thank you for your help, Finally, it was a configuration problem in the remote gateway where the datasync was unconfigured and tag writing was not allowed in the service security.