# Gateway log flooded with StoreAndForward.Sink.HsqlDataStore Errors **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [September 30, 2020, 8:53pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234 "2020-09-30T20:53:16Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mitchell-ACS](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mitchell-acs/32/30062_2.png) [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Post date:** [September 30, 2020, 8:53pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/1 "2020-09-30T20:53:16Z")
My gateway log is flooded with these errors and I cannot find what is causing them. Error deserializing data from data store. ```auto java.lang.ClassCastException: cannot assign instance of com.inductiveautomation.ignition.common.sqltags.model.types.DataQuality to field com.inductiveautomation.ignition.common.model.values.BasicQualifiedValue.quality of type com.inductiveautomation.ignition.common.model.values.QualityCode in instance of com.inductiveautomation.ignition.common.model.values.BasicQualifiedValue at java.base/java.io.ObjectStreamClass$FieldReflector.setObjFieldValues(Unknown Source) at java.base/java.io.ObjectStreamClass$FieldReflector.checkObjectFieldValueTypes(Unknown Source) at java.base/java.io.ObjectStreamClass.checkObjFieldValueTypes(Unknown Source) at java.base/java.io.ObjectInputStream.defaultCheckFieldValues(Unknown Source) at java.base/java.io.ObjectInputStream.readSerialData(Unknown Source) at java.base/java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.base/java.io.ObjectInputStream.readObject0(Unknown Source) at java.base/java.io.ObjectInputStream.defaultReadFields(Unknown Source) at java.base/java.io.ObjectInputStream.readSerialData(Unknown Source) at java.base/java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.base/java.io.ObjectInputStream.readObject0(Unknown Source) at java.base/java.io.ObjectInputStream.readObject(Unknown Source) at java.base/java.io.ObjectInputStream.readObject(Unknown Source) at java.base/java.util.ArrayList.readObject(Unknown Source) at java.base/jdk.internal.reflect.GeneratedMethodAccessor14.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at java.base/java.io.ObjectStreamClass.invokeReadObject(Unknown Source) at java.base/java.io.ObjectInputStream.readSerialData(Unknown Source) at java.base/java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.base/java.io.ObjectInputStream.readObject0(Unknown Source) at java.base/java.io.ObjectInputStream.readObject(Unknown Source) at java.base/java.io.ObjectInputStream.readObject(Unknown Source) at com.inductiveautomation.ignition.gateway.cluster.ClusterUtil.deserializeObject(ClusterUtil.java:96) at com.inductiveautomation.ignition.gateway.cluster.ClusterUtil.deserializeObject(ClusterUtil.java:56) at com.inductiveautomation.ignition.gateway.cluster.ClusterUtil.unzipAndDeserializeObject(ClusterUtil.java:90) at com.inductiveautomation.ignition.gateway.history.stores.AbstractDatasourceStore.deserializeObject(AbstractDatasourceStore.java:497) at com.inductiveautomation.ignition.gateway.history.stores.AbstractDatasourceStore.loadTransactions(AbstractDatasourceStore.java:570) at com.inductiveautomation.ignition.gateway.history.stores.AbstractDatasourceStore.syncdTakeNext(AbstractDatasourceStore.java:513) at com.inductiveautomation.ignition.gateway.history.stores.AbstractStore.takeNext(AbstractStore.java:213) at com.inductiveautomation.ignition.gateway.history.stores.MultiStageStore.syncdTakeNext(MultiStageStore.java:165) at com.inductiveautomation.ignition.gateway.history.stores.AbstractStore.takeNext(AbstractStore.java:213) at com.inductiveautomation.ignition.gateway.history.forwarders.ForwarderThread.synchedTakeNext(ForwarderThread.java:200) at com.inductiveautomation.ignition.gateway.history.forwarders.RedundancyAwareForwarder.synchedTakeNext(RedundancyAwareForwarder.java:68) at com.inductiveautomation.ignition.gateway.history.forwarders.ForwarderThread.run(ForwarderThread.java:139) ``` ---
**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:** [September 30, 2020, 10:31pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/2 "2020-09-30T22:31:41Z")
Did you upgrade from v7.9 with data in the store & forward cache? ---
**Author:** ![mitchell-ACS](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mitchell-acs/32/30062_2.png) [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Post date:** [September 30, 2020, 10:33pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/3 "2020-09-30T22:33:28Z")
Yeah I bet there was a few sets in there, so dump it? ---
**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:** [September 30, 2020, 10:36pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/4 "2020-09-30T22:36:13Z")
Yeah, all kinds of data types were refactored, and serialization doesn’t like that. ---
**Author:** ![mitchell-ACS](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mitchell-acs/32/30062_2.png) [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Post date:** [September 30, 2020, 10:36pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/5 "2020-09-30T22:36:36Z")
I’ll give that a try, thanks @pturmel ---
**Author:** ![mitchell-ACS](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mitchell-acs/32/30062_2.png) [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Post date:** [October 1, 2020, 3:44pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/6 "2020-10-01T15:44:10Z")
So I deleted all the quarantine records but it didn’t make a difference in my logs, still 100s errors every minute. Is there a better way for dumping the store and forward cache? ---
**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 1, 2020, 4:53pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/7 "2020-10-01T16:53:06Z")
Not sure. Support could probably tell you which SQLite file to delete… ---
**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Post date:** [October 1, 2020, 6:29pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234/8 "2020-10-01T18:29:34Z")
I had a similar problem where deleting quarantine records didn’t work. The steps in [this post](http://forum.inductiveautomation.com/t/hsqldatastore-error-deserializing-data-from-data-store/35043/9) did fix the problem. It was a dev environment for me, so I wasn’t worried about loosing some data. That may be a consideration for you.