HsqlDataStore - Error storing to data cache

Ignition
1

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)

2

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.

3

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.