# HsqlDataStore - Error storing to data cache

**URL:** <https://forum.inductiveautomation.com/t/hsqldatastore-error-storing-to-data-cache/23912>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [April 8, 2019, 9:41am UTC](https://forum.inductiveautomation.com/t/hsqldatastore-error-storing-to-data-cache/23912 "2019-04-08T09:41:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mik977](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mik977](https://forum.inductiveautomation.com/u/mik977)\
**Post date:** [April 8, 2019, 9:41am UTC](https://forum.inductiveautomation.com/t/hsqldatastore-error-storing-to-data-cache/23912/1 "2019-04-08T09:41:31Z")

</div>

Getting a lot of this in the logs!

java.sql.BatchUpdateException: data exception: **sequence generator limit exceeded**  
at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)  
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)  
at com.inductiveautomation.ignition.gateway.localdb.DelegatingDataSource$DelegatingConnection$DelegatingStatement.executeBatch(DelegatingDataSource.java:389)  
at com.inductiveautomation.ignition.gateway.history.stores.AbstractDatasourceStore.syncdStoreData(AbstractDatasourceStore.java:330)  
at com.inductiveautomation.ignition.gateway.history.stores.AbstractDatasourceStore.syncdStoreData(AbstractDatasourceStore.java:272)  
at com.inductiveautomation.ignition.gateway.history.stores.AbstractStore.storeData(AbstractStore.java:225)  
at com.inductiveautomation.ignition.gateway.history.forwarders.ForwarderThread.run(ForwarderThread.java:155)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 8, 2019, 3:49pm UTC](https://forum.inductiveautomation.com/t/hsqldatastore-error-storing-to-data-cache/23912/2 "2019-04-08T15:49:13Z")

</div>

Could you get in contact with support? It would be good to collect some information from your system. If you don’t care about your quarantined data, you could also try deleting the `Ignition/data/datacache/<databaseConnectionName>/` folder, then either edit -\> save the database connection or restart the Ignition gateway.

---

<div class="post-metadata">

**Author:** ![mik977](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mik977](https://forum.inductiveautomation.com/u/mik977)\
**Post date:** [April 9, 2019, 6:38am UTC](https://forum.inductiveautomation.com/t/hsqldatastore-error-storing-to-data-cache/23912/3 "2019-04-09T06:38:12Z")

</div>

Thanks. I was able to solve this problem per your description above. Maybe you can include this fix in a 7.9 bugfix release. Hence a 64 bit generator for the cache.