tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/71042-deleting-and-re-importing-transactions-results-in-duplicate-copiesInfinite Kind: Discussion 2021-09-23T05:40:18Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/492601812021-06-23T20:53:10Z2021-06-23T20:53:11ZDeleting and re-importing transactions results in duplicate copies<div><p>An observation: if I delete the transactions and then re-import them into a <em>different</em> account, the "undead" versions appear in the <em>original</em> account.</p>
<p>I'm importing from a .qfx file, for the record.</p></div>Andrewtag:infinitekind.tenderapp.com,2009-01-14:Comment/492601812021-06-23T20:59:25Z2021-06-23T20:59:25ZDeleting and re-importing transactions results in duplicate copies<div><p>MD remembers the account to import into to. Are you sure it’s not just importing to the old account?</p>
<p>Toolbox. Advanced mode. OFX tools can reset the link for you.</p>
<p>(Not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/492601812021-06-23T21:43:08Z2021-06-23T21:43:10ZDeleting and re-importing transactions results in duplicate copies<div><p><strong>(tl;dr: my problem is fixed, but there is likely still a bug)</strong></p>
<p>Yes, I'm sure. I get one copy of the transactions in the new account (named Test), and N copies in the old account, where N is the number of previous attempts to delete and re-import.</p>
<p>That said...I did manage to fix it with the toolbox (which I didn't know existed until just now, thank you!). Not by resetting the link, but by deleting cached OnlineTxnList records. I noticed that both the delete and view features stated that there should be no cached records -- yet the viewer indicated several hundred for the account in question.</p>
<p>Clearing that cache (via <em>toolbox -> advanced -> Online banking tools -> Delete all cached onlinetxnlist records</em>) stopped the ghost records from reappearing...at least on the next import. I notice that, having done so, there's once again 38 items in the cache, matching the 38 transactions I'm importing. I have a sinking feeling that something is still wrong.</p>
<p>I noticed an exception in the console log. I don't know if it's relevant, but I guess I could see an exception bypassing some sort of post-import cache-cleanup?</p>
<pre>
<code>ratios (1): 06-23 17:13:45.543|Error computing ratios: null
java.util.ConcurrentModificationException
at java.base/java.util.HashMap$HashIterator.nextNode(Unknown Source)
at java.base/java.util.HashMap$ValueIterator.next(Unknown Source)
at com.infinitekind.moneydance.model.TxnIterator.fetchNextSplit(TxnIterator.java:53)
at com.infinitekind.moneydance.model.TxnIterator.hasNext(TxnIterator.java:42)
at com.moneydance.modules.features.ratios.RatioCompute.computeTxnBasedValues(RatioCompute.java:298)
at com.moneydance.modules.features.ratios.RatioCompute.computeRatios(RatioCompute.java:46)
at com.moneydance.modules.features.ratios.RatiosExtensionModel$BackgroundRecalculateTask.run(RatiosExtensionModel.java:377)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)</code>
</pre></div>Andrewtag:infinitekind.tenderapp.com,2009-01-14:Comment/492601812021-06-24T05:31:08Z2021-06-24T05:31:08ZDeleting and re-importing transactions results in duplicate copies<div><p>There is a problem with the ratios extension and build 3069. We need the author to fix it. If you’re not using it, remove that.</p>
<p>Deleting the cached OnlineTxnList records is a good and safe fix. There should be none. You are correct, there is a bug somewhere that leaves these behind. Hence the toolbox fix.</p>
<p>Toolbox 🧰 +1 😃</p></div>Stuart Beesley (Mr Toolbox)