# SQL Lite Archive Historian

**URL:** <https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791>\
**Category:** Maker\
**Tags:** perspective, database, ignition80\
**Created:** [October 19, 2020, 10:55am UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791 "2020-10-19T10:55:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![folgore](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@folgore](https://forum.inductiveautomation.com/u/folgore)\
**Post date:** [October 19, 2020, 10:55am UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791/1 "2020-10-19T10:55:47Z")

</div>

Hi, I have tried to use a SQLite DB for my application. I have the problem with a Historian Tag on version 8.0.16 version on Windows 10 enterprise 64 bit.  
My tag is stored even 30s. If I open the DB I view a correct data . But in table and chart no. There is a problem with SQLite?

---

<div class="post-metadata">

**Author:** ![folgore](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@folgore](https://forum.inductiveautomation.com/u/folgore)\
**Post date:** [October 26, 2020, 6:08pm UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791/2 "2020-10-26T18:08:17Z")

</div>

If I open the sqlt\_data\_1\_2020\_10 create automaticcally from Hystorian from Database browser the value of t\_stamp is negative. This is the error that does not possible view the chart?

I attach the screenshot.

Thank’s.

 ![error](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/7/6753698aadf30cf1d94445c06c17d46fa2298330.jpeg)

---

<div class="post-metadata">

**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:** [October 26, 2020, 6:15pm UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791/3 "2020-10-26T18:15:49Z")

</div>

Something strange going on:

```auto
>>> print system.date.fromMillis(-519269173L)
Thu Dec 25 18:45:30 EST 1969

```

---

<div class="post-metadata">

**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\
**Post date:** [October 26, 2020, 7:17pm UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791/4 "2020-10-26T19:17:18Z")

</div>

If you look at the settings for the SQLite JDBC Driver (Gateway \> Config \> Databases \> Drivers \> edit “SQLite”, is the **Driver Type** set to something other than **SQLITE**?

 ![Screenshot 2020-10-26 121956](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/4/64c7f24264b3d0a15607ccf4a25ef8d601f2678f.png)

For transparency, we found an issue where the Driver Type was incorrectly set to **GENERIC**. New installations shouldn’t run into this anymore, but it seems possible to upgrade into this state (as you found). If this is the case, then switching the Driver Type to SQLITE and saving should take care of the issue.

---

<div class="post-metadata">

**Author:** ![folgore](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@folgore](https://forum.inductiveautomation.com/u/folgore)\
**Post date:** [October 27, 2020, 6:14am UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791/5 "2020-10-27T06:14:47Z")

</div>

No, i have the settings in generic. I try. Thank,s

---

<div class="post-metadata">

**Author:** ![folgore](https://avatars.discourse-cdn.com/v4/letter/f/edb3f5/32.png) [@folgore](https://forum.inductiveautomation.com/u/folgore)\
**Post date:** [November 5, 2020, 12:05pm UTC](https://forum.inductiveautomation.com/t/sql-lite-archive-historian/39791/6 "2020-11-05T12:05:59Z")

</div>

Ok, to view a graph. But now I have noticed this message. What does this mean ?

But I have view only now this.

 ![cattura1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/f/efab690d60029785ccae5f8c689c3360da3e6cb9.jpeg)