tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/6251-securitiesInfinite Kind: Discussion 2022-02-09T22:10:19Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-09T09:11:19Z2021-11-09T09:11:19ZSecurities<div><p>Stuart</p>
<p>I have left this a few days and upon opening today the duplicates have disappear from the Edit Securities screen but when I run the merge securities in Toolbox I get the attached pop up indicating all is not right.</p>
<p>How do I correct this.</p>
<p>Kevin</p></div>kariggtag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-09T09:26:26Z2021-11-09T09:26:26ZSecurities<div><p>It’s saying you have no duplicate securities that it can detect and you are also saying that you have no duplicates in tools/securities. Thus, why do you think you have a problem? Have you checked your portfolios; are they correct?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-09T15:23:17Z2021-11-09T15:23:17ZSecurities<div><p>Stuart</p>
<p>I have just reopened MD and all the duplicates securities reappear. Furthermore the Security ID despite having amend this reappears and shows as the name of the security.</p>
<p>What more can I do to get this sorted</p>
<p>Kevin</p></div>kariggtag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-09T16:12:22Z2021-11-09T16:12:22ZSecurities<div><p>It sounds to me as if the MD Sync (change management) system is reapplying old data at restart, hence your erratic results... Therefore, if this was me, I would purge the change files (.txn and .mdtxn).... They really are not needed</p>
<p>Are you using Sync to synchronise between datasets? If you are using Sync, then please make sure each sync copy has opened its dataset and restarted MD (and wait 2 mins) at least twice, before doing this....</p>
<p>An easy method to purge is this....<br>
BACKUP<br>
Toolbox.. Hacker mode.... Option: Hack: Shrink Dataset... Acknowledge. If the option appears, select PURGE-OUT, then type 1 at the days to keep box.. Let it do it's thing...</p>
<p>Then restart MD, wait 2 mins, restart MD......</p>
<p>At this point what state are the Securities in?</p>
<p>If needed, then rename the HSBC security and then Toolbox Merge again... Restart MD twice.... Where are we at?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-09T19:38:26Z2021-11-09T19:38:26ZSecurities<div><p>Stuart</p>
<p>I have done this but it does not sort out the issue.</p>
<p>When I reopen after waiting at least 2 mins and then go to securities in the edit box comes up a number of duplicate securities. I can remove these when I press the – button at the bottom left of the screen but this does not take effect because when I close down and reopen the duplicates remain.</p>
<p>Kevin</p></div>kariggtag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-10T09:48:10Z2021-11-10T09:48:10ZSecurities<div><p>When you ran the Shrink Dataset option, did it do anything?<br>
- Did you get the 'PURGE-OUT' option? - How many files did it say it was removing?</p>
<p>OK, please launch File Explorer and navigate to both these folders.... Can you take a screenshot of both folders....</p>
<p>C:\Users\Kevin Rigg.moneydance\Documents\Kevin Personal Finances.moneydance\safe\tiksync\in</p>
<p>C:\Users\Kevin Rigg.moneydance\Documents\Kevin Personal Finances.moneydance\safe\tiksync\out</p>
<p>Then restart MD. Wait 2 mins... Take a screen shot of Tools>Securities (call this before deletion) .... Then use the - button. Does it give a warning, or just allow you to delete it? Make the deletion... Now screenshot again with it gone (call it after deletion)...</p>
<p>Then get a copy of console (call it after deletion, before restart)..</p>
<p>Then restart, wait 2 mins.... Go back to Tools/Securities... Screen shot that screen again (call it after restart)...</p>
<p>Take another copy of console (call it after restart).</p>
<p>post all the above</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-10T14:36:01Z2021-11-10T14:36:01ZSecurities<div><p>Stuart</p>
<p>Answers to your question:-</p>
<p>Shrink database. Did it do anything. Yes</p>
<p>Purge Option Yes</p>
<p>No of files deleted. I believe around 90 but when I run it again later their were no files to purge.</p>
<p>There is no file tiksync\in</p>
<p>Tools>securities. Warning Yes Screen shot attached.</p>
<p>I have shown two screen shot for two securities</p>
<p>After a wit of a couple of hours I have just reopened MD and find the amendments have not been actioned. I attach two further screen shots both label Final re3start and Final console</p>
<p>Hope this is useful</p>
<p>Kevin</p></div>kariggtag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-10T15:59:22Z2021-11-10T16:22:07ZSecurities<div><p>Ok. Something very odd is occurring. I cannot help you further without seeing your actual dataset. So you have three choices.</p>
<p>1/ just ignore the duplicates</p>
<p>2/ if you are willing to share your dataset with me to take a look at, then email me and I will send you instructions.</p>
<p>3/ ask for support to dial in and look at your dataset</p>
<p>(not support, just a fellow user)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-10T16:10:06Z2021-11-10T16:10:06ZSecurities<div><p>Stuart</p>
<p>I shall email you.</p>
<p>Kevin</p></div>kariggtag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-10T19:53:18Z2021-11-10T19:53:18ZSecurities<div><p>To anyone watching this thread... The issue is fixed.. The 'odd' behaviour was caused by two very old .txn files that were being reported as corrupt, but in actual fact were restoring certain Security records, hence when you restarted, they reappeared. The Dataset has now been fixed...</p>
<p>I guess I'll be building another Toolbox fix to look for these and take appropriate action...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/494472062021-11-10T22:08:06Z2021-11-10T22:08:06ZSecurities<div><p>UPDATE. I’ve spoken to the developer (Sean) and he’s applying a fix so that old (damaged) .txn files that throw the bad padding exception will be added to the processed log so that they do not reprocess and cause this type of issue. This also means they will also get auto archived.</p></div>Stuart Beesley (Mr Toolbox)