# MemoryForwardTransaction

**URL:** <https://forum.inductiveautomation.com/t/memoryforwardtransaction/32344>\
**Category:** Ignition\
**Created:** [February 17, 2020, 6:53pm UTC](https://forum.inductiveautomation.com/t/memoryforwardtransaction/32344 "2020-02-17T18:53:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![seth.hathcock](https://avatars.discourse-cdn.com/v4/letter/s/5fc32e/32.png) [@seth.hathcock](https://forum.inductiveautomation.com/u/seth.hathcock)\
**Post date:** [February 17, 2020, 6:53pm UTC](https://forum.inductiveautomation.com/t/memoryforwardtransaction/32344/1 "2020-02-17T18:53:11Z")

</div>

Hello, I am getting this error filling up my logs and I cannot seem to figure it out.

| 11:59:16 AM | MemoryForwardTransaction | Error forwarding data: Duplicate entry ‘34801-1581962350174’ for key ‘PRIMARY’ |
| --- | --- | --- |
| | java.sql.BatchUpdateException: Duplicate entry ‘34801-1581962350174’ for key ‘PRIMARY’ | |

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)  
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)  
at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)  
at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeBatch(DelegatingStatement.java:59)  
at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRStatement.executeBatch(SRConnectionWrapper.java:685)  
at com.inductiveautomation.gateway.tags.history.storage.TagHistoryDatasourceSink.insertTagValues(TagHistoryDatasourceSink.java:918)  
at com.inductiveautomation.gateway.tags.history.storage.TagHistoryDatasourceSink.storeScanClassSet(TagHistoryDatasourceSink.java:333)  
at com.inductiveautomation.gateway.tags.history.storage.TagHistoryDatasourceSink.storeDataToDatasource(TagHistoryDatasourceSink.java:313)  
at com.inductiveautomation.ignition.gateway.history.sf.sinks.AbstractDatasourceSink.storeToDatasource(AbstractDatasourceSink.java:125)  
at com.inductiveautomation.ignition.gateway.history.sf.sinks.AbstractDatasourceSink.storeData(AbstractDatasourceSink.java:101)  
at com.inductiveautomation.ignition.gateway.history.sf.sinks.AggregateSink.storeData(AggregateSink.java:142)  
at com.inductiveautomation.ignition.gateway.history.forwarders.ForwarderThread.run(ForwarderThread.java:138)  
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry ‘34801-1581962350174’ for key ‘PRIMARY’  
at sun.reflect.GeneratedConstructorAccessor458.newInstance(Unknown Source)  
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)  
at java.lang.reflect.Constructor.newInstance(Unknown Source)  
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)  
at com.mysql.jdbc.Util.getInstance(Util.java:386)  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)  
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)  
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)  
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)  
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)  
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)  
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)|

This is popping up every minute or two but most of the time the “Duplicate Entry” numbers are different. Any help is appreciated.

---

<div class="post-metadata">

**Author:** ![jacques\_za](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacques_za/32/5137_2.png) [@jacques\_za](https://forum.inductiveautomation.com/u/jacques_za)\
**Post date:** [February 4, 2022, 7:40am UTC](https://forum.inductiveautomation.com/t/memoryforwardtransaction/32344/2 "2022-02-04T07:40:38Z")

</div>

I have the same problem. I hope someone has a resolution.