# SQLite Setup Problem: Empty tables, Power Chart can't disply history

**URL:** <https://forum.inductiveautomation.com/t/sqlite-setup-problem-empty-tables-power-chart-cant-disply-history/49709>\
**Category:** Ignition\
**Tags:** database, ignition81\
**Created:** [August 9, 2021, 4:09pm UTC](https://forum.inductiveautomation.com/t/sqlite-setup-problem-empty-tables-power-chart-cant-disply-history/49709 "2021-08-09T16:09:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![daniele1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/daniele1/32/31531_2.png) [@daniele1](https://forum.inductiveautomation.com/u/daniele1)\
**Post date:** [August 9, 2021, 4:09pm UTC](https://forum.inductiveautomation.com/t/sqlite-setup-problem-empty-tables-power-chart-cant-disply-history/49709/1 "2021-08-09T16:09:26Z")

</div>

Hi,  
I’m trying to setup a DB connection to a SQLite DB as part of the Building in Perspective Course by Inductive University.  
In Database Connection I createdt the connection by just giving a name to the DBas the instructor says.  
After saving the status of the Connection is Faulted, after checking the Error it seems that during the DB creation I should have modified the path to the db file to and existing folder on the C drive.  
So I did it and now the connection is valid.  
So now I have enabled histoy on 15 tags and a table of the db is filling upo with records.

 ![Immagine 2021-08-09 180531](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/8/4862c8e47a5fd5e32919b42b8b0520a080404fc2.jpeg)  
I then tried to use the power chart to display the tags history but the browse tag is empty.  
 ![Immagine 2021-08-09 180516](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/8/b8f5dfbcfc94a9cdab832feba115dde20a8178a0.jpeg)

Looking at the DB tables I notided that only 6 tags are registering their history (from id 7 to id 12) and all the other tables outside of the one with the values are empty, for example there’s no definition for the tags that are getting their history registered.

 ![Immagine 2021-08-09 180543](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d6e1f3831ca888983067d2fae8f5286ad25500b.jpeg)

It seems that I 'm having some problems with the SQLite DB I have created, any guess what it is?

---

<div class="post-metadata">

**Author:** ![rpavlicek](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rpavlicek/32/55868_2.png) [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\
**Post date:** [October 13, 2021, 1:33pm UTC](https://forum.inductiveautomation.com/t/sqlite-setup-problem-empty-tables-power-chart-cant-disply-history/49709/2 "2021-10-13T13:33:35Z")

</div>

I’m experiencing something similar. However, even though all 15 tags are in the sqlth\_te table and it’s data values being registered, the Easy Chart in Vision or PowerChart in Perspective, with showing the last whatever minutes (10 min, 1 hour, etc…) is not showing a trend, it showing a straight line live value. Any idea what’s happening?

---

<div class="post-metadata">

**Author:** ![Rodrigo\_Bernardes](https://avatars.discourse-cdn.com/v4/letter/r/9de0a6/32.png) [@Rodrigo\_Bernardes](https://forum.inductiveautomation.com/u/Rodrigo_Bernardes)\
**Post date:** [March 13, 2025, 4:33pm UTC](https://forum.inductiveautomation.com/t/sqlite-setup-problem-empty-tables-power-chart-cant-disply-history/49709/3 "2025-03-13T16:33:08Z")

</div>

Hi, do you remember how you fixed that?  
I'm having exactly the same problem.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/d/6d8a7f4ba2cb1f3944995e946d041a5c4e55e395.png)