tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/56515-moneydance-upgrade-results-in-progressively-inaccurate-balancesInfinite Kind: Discussion 2020-01-26T13:20:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-22T13:53:07Z2019-09-22T13:53:07ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I am not support staff, just a user.</p>
<p>Have you tried updating 2017.6 to 2017.10 first?<br>
Make sure your data set is no your hard drive not external say in the cloud.<br>
2017.10 can be downloaded from <a href="https://infinitekind.com/download_2017">https://infinitekind.com/download_2017</a><br>
Then FILE (MONEYDANCE on Mac) – EXPORT BACKUP.</p>
<p>Then upgrade to 2019.3.</p>
<p>Hope this help.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-22T14:14:27Z2019-09-22T14:14:28ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi, thanks for your response.</p>
<p>When I upgrade to 2017.10 from 2017.6, same result with ballooning checking<br>
balance.</p>
<p>Kyle</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-22T14:33:00Z2019-09-22T14:33:00ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I am not support staff, just a user.</p>
<p>And you data set is on your hard drive?<br>
Are you syncing to another device, mobile phone?<br>
What is you computer operating system?<br>
Can you post your Moneydance errlog.txt file.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-22T21:46:16Z2019-09-22T21:46:17ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Thanks for helping here Derek. Some answers here:</p>
<p>-The data set resides on my HDD. -I'm not syncing to anything (although I want to!) - MacOS Mojave 10.14.6 - Error log attached (I had to Time Machine back since the error log is overwritten when I reverted back to 2017.6.</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-23T07:37:29Z2019-09-23T07:37:29ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I am not support staff, just a user.<br>
Hi Kyle</p>
<p>To be of any help the error log needs to be for 2017.10 or 2019 when the problem occurs.<br>
Make sure you have a backup of your data set sullivan2015.moneydance in a safe place before you update to 2019.<br>
Open Moneydance 2019. Check the problem has occurred. Make sure you shut down Moneydance normally before you copy the errlog.txt file to post.</p>
<p>By the way can you determine what transaction get added each time you open Moneydance that would explain the account totals increasing? Are they duplicates of existing transactions or something else? Are you using Direct Connect set to update automatically on Moneydance opening?</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-23T08:39:03Z2019-09-23T08:39:03ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I'm a fellow user.</p>
<p>The posted error log in incomplete but it does highlight that an attempt has at least been made to set up syncing:</p>
<p>dropbox folder should be at /Users/kylesullivan/Dropbox and<br>
exists=true<br>
base sync folder: /Users/kylesullivan/Dropbox/.moneydancesync<br>
dropbox folder should be at /Users/kylesullivan/Dropbox and exists=true<br>
base sync folder: /Users/kylesullivan/Dropbox/.moneydancesync<br>
base sync folder: /Users/Kyle/Dropbox/Kyle's Files Dropbox/Financial/Moneydance</p>
<p>I would be inclined to make sure syncing is disabled and that any Moneydance data in the Dropbox folder is removed.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-23T09:26:13Z2019-09-23T09:26:13ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi dwg</p>
<p>When I create a completely new data set on a windows computer I get the following lines in the console log.</p>
<p>dropbox folder should be at C:\Users\derek\Dropbox and exists=true<br>
base sync folder: C:\Users\derek\Dropbox.moneydancesync<br>
dropbox folder should be at C:\Users\derek\Dropbox and exists=true<br>
base sync folder: C:\Users\derek\Dropbox.moneydancesync</p>
<p>They don’t indicate that the data set has ever been synced, just that Dropbox client is installed.<br>
I think the only was to be sure is to see if the folder “.moneydancesync” has been created in Dropbox that contains an alphanumeric folder which has a text file mdsyncinfo.txt in which the data set is named.</p>
<p>Am I missing something?</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-23T11:36:25Z2019-09-23T11:36:25ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>hi Derek,</p>
<p>You are probably not missing anything.</p>
<p>Over the time I have been working with Moneydance there have been many changes including what is logged so I may be mistaken here on what the log file is saying.</p>
<p>I'm of the mindset that if syncing is not being used then Dropbox should not be checked at all, I suspect Sean would disagree with me :)</p>
<p>Des</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-23T17:44:11Z2019-09-23T17:44:13ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Thanks guys. I'll try some things when I get home. Regarding derekkent23's question to which transactions may be causing the difference: I don't know. What I do know is that there are many more uncleared transactions from much earlier dates. No particular trend noticed.</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-27T20:20:04Z2019-09-27T20:20:05ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>If finally got a chance to try this again derekkent23, I think this is more interesting err log.txt file.</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-27T21:14:23Z2019-09-27T21:14:23ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I am not support staff, just a user.<br>
Hi Kyle</p>
<p>I assume you are still seeing the problem, each time you open 2019 the checking balance greatly increases? Please confirm.</p>
<p>This one going to need supports help, maybe they can see something in the errlog.txt that I can’t.</p>
<p>The section starting “java.util.ConcurrentModificationException” may be an issues.</p>
<p>The section starting “Compressing 242 txn file(s) to 'archive/201811.mdtxnarchive'” is probably part of the process introduced in 2019 to reduce the data set size by compressing the individual “.tnx” files into a single “mdtxnarchive” file and then deleting the individual “tnx” files.</p>
<p>This happens at regular interval but the first time you close 2019 there a lot of “tnx” files to deal with.</p>
<p>If support don’t pick this one up, I will post a link to your thread to Sean the Moneydance Software developer in the hope he will take a look, no guarantees.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-27T22:26:54Z2019-09-27T22:26:55ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Derek,<br>
Thanks for looking at it. Yes, the issue still exists with the ballooning checking account balance.</p>
<p>I reverted back to 2017.6 and all's good again.</p>
<p>Do you recommend I submit a support ticket?</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-27T22:51:26Z2019-09-27T22:51:26ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I'm a fellow user.</p>
<p>I do not see anything standing out in the log file, as Derek says the cleaning up of archive files is not something that stands out.</p>
<p>Having tested upgrading from MD2017 to MD2019 many times I have not seen anything inherently wrong in the process - and in any case the low level data structures are fundamentally the same which says to me the probability of an issue should be low.</p>
<p>I'm more inclined to think there is something in the data that is triggering a problem for the latter version and that is an issue that support will need to pick up.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-09-28T06:39:13Z2019-09-28T06:39:13ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I am not support staff, just a user.<br>
Hi Kyle</p>
<p>By posting on this site you are requesting help and help comes via other users or support whoever reads the post first. If the user can’t help then support should step in.</p>
<p>SUPPORT PLEASE TAKE A LOOK AT THIS THREAD, THANKS.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-02T08:30:33Z2019-10-02T08:30:33ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Kyle,</p>
<p>I'm sorry about the lack of official response on this problem so far. I think this may be an issue that we've seen with a few others. I've created a script that will fix this if it turns out to be the same problem. Could you perform the following steps?</p>
<ol>
<li>Open your data file in Moneydance 2019<br></li>
<li>Select the Window -> Show MoneyBot Console menu<br></li>
<li>Click the Open Script button and select the downloaded script file (reset_relative_currencies.py)<br></li>
<li>Click the Run Script (or just Run) button<br></li>
<li>Give it a few seconds to load and run<br></li>
<li>Copy and paste the results into a response to this thread?</li>
</ol>
<p>Thanks!<br>
Sean</p>
<p>--<br>
Sean Reilly<br>
Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-02T11:59:20Z2019-10-02T11:59:20ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Thanks Sean. I'l give it a try (likely this weekend) and respond with feedback/results. Appreciate it.</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-06T23:50:54Z2019-10-06T23:53:31ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Sean,<br>
Here's the text file after running the script. Let me know if there's some next steps here. Checking and savings still show inaccurate balances.</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-09T08:42:59Z2019-10-09T08:42:59ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Kyle,</p>
<p>Thanks for your message and I'm sorry for taking so long to follow-up with this. The output of the script looks fine and doesn't reveal any errors. One long shot possibility is that maybe the "balance type" preference setting has changed? That would likely cause some balances to be displayed exactly the same as in 2017 but others to be different in 2019 even with no changes to the actual data. Can you check the setting for "Side Bar Balance Type" in your Moneydance preferences? Or you could click the underlined balance number at the bottom of any of your registers to show all of the different kinds of balances (cleared, current, total, online, etc) to see if any of them match up with what you were seeing in 2017.</p>
<p>Thanks,<br>
Sean</p>
<p>--<br>
Sean Reilly<br>
Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-09T09:00:25Z2019-10-09T09:00:25ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Kyle,</p>
<p>I'm sorry, I missed the part from your message where you mention the balances are continuing to change on subsequent runs of MD2019. In this case I think it's probably necessary to do a screen sharing session so that we can get to the bottom of this as quickly as possible.</p>
<p>If you're ok with doing a screen sharing session can you let me know what dates/times you might be available as well as your time zone?</p>
<p>Thanks,<br>
Sean</p>
<p>--<br>
Sean Reilly<br>
Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-09T10:42:17Z2019-10-09T18:59:11ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Sean, I'm on ET time here outside of Boston, MA.</p>
<p>Screensharing works for me. Can we work this out privately? (I'm not sure if this is public or not). Emailing me at the kyle-at-kylesullivan.com works. Or another recommended way to communicate, e.g. private message?</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-26T23:02:44Z2019-10-26T23:02:44ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Just want to publicly thank Sean who got on the phone with me for over 2 hours to drive home a resolution to the complex problem I was having. Thank you Sean. It's rare to see the personal support and dedication in products today. I liked Moneydance before, but now I love it!</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-27T01:57:35Z2019-10-27T01:57:35ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I'm a fellow user.</p>
<p>It may prove to be useful to post what the problem was and what the solution is in case it should come up again with another user. This sort of knowledge builds up the base of information that is out there.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-27T08:24:51Z2019-10-27T08:24:51ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Hi Kyle</p>
<p>As a participant to this thread I would also be interested.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-27T12:26:06Z2019-10-27T12:26:06ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>Absolutely, I'll try my best. Sean Reilly may have to come in and explain better. Here's a summary of the situation: After upgrading from 2017, some old deleted reminders returned. The ones that had "auto-commit" enabled, created transactions from years past into my checking account, throwing off the balance. Sean acknowledged that he's never seen it before, and I'll let him comment on the software functionality issue that caused this, but it's clearly limited since I may be the only user to have seen this.</p>
<p>The resolution was to wipe out these zombie reminders and their associated new transactions (easy to find since they were uncleared). Now I'm on MD 2019 and all's good.</p></div>Kyle Sullivantag:infinitekind.tenderapp.com,2009-01-14:Comment/476477642019-10-27T13:17:55Z2019-10-27T13:17:55ZMoneydance Upgrade Results in Progressively Inaccurate Balances<div><p>I am not support staff, just a user.<br>
Hi Kyle</p>
<p>Interesting.<br>
Thanks for the explanation.</p>
<p>Hope this helps.</p></div>derekkent23