tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/7300-issues-with-portfolio-view-refreshes-on-its-own-to-inaccurate-figuresInfinite Kind: Discussion 2023-03-12T23:30:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-09T00:57:31Z2022-12-09T00:57:31ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>just a user - you don't really need a fresh restart, as the file size won't be causing any of these issues.</p>
<p>Can't help you on the issues specifically, but I can discuss your file size. Do you have lots of attachments? Those eat up space faster than data entries.</p>
<p>You can use the Toolbox extension to both examine where your file "sizage" is, as well as shrink your data set - without expunging data (I'd hate to lose any of my 35 years of data - as the older data is like a diary for us). BTW - after doing what I mention below (shrink and remove most attachments) 35 years of data for me is about 95 mb...</p>
<p>Install Toolbox, Go to Toolbox Options (Upper left), click Advanced Mode. Then click Advanced Mode, which should have turned Red, Find "Shrink Dataset Size" under Update Functions.</p>
<p>You will see many "BACKUP YOUR DATASET" - Heed at least one of these, or make an Export Backup manually. This is a precaution if something goes wrong, but it shouldn't go wrong, but you never know.</p>
<p>Once you shrink your dataset (it might be quite a bit), we can also discuss removing some attachments. Throwing away your actual transactions is a lot of work, and a lot of fixup work.</p>
<p>1) Your file size should not be causing the issues you describe.<br>
2) Shrink your dataset in this order:<br>
a) Toolbox Shrink b) Attachment removal c) Transaction removal - really the worst thing to do. 3) I don't know why your portfolio view changes, but some here can probably give some thoughts, as they've found weird bugs before.<br>
4) Your other issues can be dealt with once you remove your concern about file size.</p>
<p>Hope that helps.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-09T07:20:16Z2022-12-09T07:20:16ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>Exactly as dtd says. In addition,</p>
<ol>
<li>Send help/console<br></li>
<li>Run toolbox, analyse dataset and objects first and upload the output here. Would be interesting to see this before you start.</li>
</ol></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-09T17:59:24Z2022-12-09T17:59:24ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p> I updated tool box but it doesnt recognize my mouse. Cannot select 'Shrink Dataset size'. I tried exit then back to advanced and I tried to proceed, no luck either way.</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-09T18:15:45Z2022-12-09T18:15:45ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>I’m guessing you haven’t clicked top left, toolbox options, enable advanced mode first?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T00:00:30Z2022-12-10T00:00:31ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p> From 193,978 to 72,011, that's quite an improvement, thank you. Left setting on there for 30 days.</p>
<p>David</p>
<p> NOTE: The Reports and Graphs will generate portfolio that agrees to sidebar totals. But the default 'Portfolio View' display something<br>
reasonable when one first pulls it up, then changes to ludicrous numbers<br>
that don't agree to sidebar. this shrink did not fix that. But again,<br>
I am mainly using the system to track future transactions and cashflow,<br>
but still wondering why it has 'lost its mind'. lol I just try to get<br>
close on balancing portfolio anyway as I do most of my reporting out of<br>
online aggregators. At one time, that wasn't the case. Still like MD<br>
though, good for researching disbursements (except for late 2021 and<br>
early 2022 as I never quite built the Charles Schwab transactions back<br>
correctly, 2022 onward ok thanks to the aggregator I pay $2 a month for,<br>
that works great, just slow, so sometimes I just bring it up-to-date<br>
manually until system catches up).</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T00:57:14Z2022-12-10T00:57:14ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>Shrink data just removes redundant data from the data set nothing more nothing less so it is not expect to have any effect elsewhere. I would suggest you post your Moneydance error ls got see if it gives any insight as to the balance changes.</p>
<p>Depending on what operating system and version you are using the error log should be in one of the following locations</p>
<ol>
<li>macOS</li>
</ol>
<p>If you are using a Mac, it should be located at one of these locations within your Home folder:</p>
<p>macOS Big Sur and Monterey:<br>
~/Library/Containers/Moneydance/Data/Library/Application Support/Moneydance/errlog.txt</p>
<p>macOS X Lion until macOS X Catalina:<br>
~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt</p>
<p>macOS X Snow Leopard and earlier:<br>
~/Library/Application Support/Moneydance/errlog.txt</p>
<p>If you have any trouble finding your Home Library folder you can open Finder and hold down the option key while selecting the Go menu and the Library folder option should occur or you can open Finder and select Go -> Go to Folder and copy and paste in the following:</p>
<p>~/Library</p>
<p>This should pull up your local Library folder.</p>
<ol>
<li>Windows</li>
</ol>
<p>If you are using Windows, it should be located under your login directory at:</p>
<p>Windows Vista and later:</p>
<p>C:\Users(yourusername).moneydance\errlog.txt</p>
<p>or</p>
<p>Before Windows Vista:</p>
<p>C:\Documents and Settings(yourusername).moneydance\errlog.txt</p>
<ol>
<li>Linux</li>
</ol>
<p>If you are using Linux it should be located in your home folder at:<br>
~/.moneydance/errlog.txt</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T01:22:57Z2022-12-10T01:22:57ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>I got it to work. Below is note I sent to support after shrink.</p>
<p>From 193,978 to 72,011, that's quite an improvement, thank you. Left setting on there for 30 days.</p>
<p>David</p>
<p>NOTE: The Reports and Graphs will generate portfolio that agrees to sidebar totals. But the default 'Portfolio View' display something reasonable when one first pulls it up, then changes to ludicrous numbers that don't agree to sidebar. this shrink did not fix that. But again, I am mainly using the system to track future transactions and cashflow, but still wondering why it has 'lost its mind'. lol I just try to get close on balancing portfolio anyway as I do most of my reporting out of online aggregators. At one time, that wasn't the case. Still like MD though, good for researching disbursements (except for late 2021 and early 2022 as I never quite built the Charles Schwab transactions back correctly, 2022 onward ok thanks to the aggregator I pay $2 a month for, that works great, just slow, so sometimes I just bring it up-to-date manually until system catches up).</p></div>David L Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T01:34:14Z2022-12-10T01:34:14ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>just a user - I'm fairly certain that dwg was talking about your "Portfolio View" problem, not about shrinking the dataset.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T08:03:28Z2022-12-10T08:03:28ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>As I mentioned, please go to help/console, grab the contents, and upload it it here. I’m pretty sure I know why the numbers go silly, but I need to see the console log.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T15:39:01Z2022-12-10T15:39:01ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>see attached.</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T16:27:42Z2022-12-10T16:27:42ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>Nothing attached. You need to go online and attach it.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-10T16:36:33Z2022-12-10T16:36:35ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>see attached</p></div>David Greenetag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-11T20:56:19Z2022-12-11T20:56:19ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>This is the culprit:</p>
<p>“Error reading synced transactions from file 49cae438-97f6-4c42-911f-be8d26c70cb9.txn: java.lang.Exception: Unsupported action:-47af-8658-e8f8a3e82cfd%260.acct%3D165%26ts%3D1668809416345: from file 49cae438-97f6-4c42-911f-be8d26c70cb9.txn java.lang.Exception: Unsupported action:-47af-8658-e8f8a3e82cfd%260.acct%3D165%26ts%3D1668809416345: from file 49cae438-97f6-4c42-911f-be8d26c70cb9.txn<br>
at com.moneydance.apps.md.controller.sync.SyncTxnReaderX.run(SyncTxnReaderX.java:167) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.applyTransactionFile(DocumentFolderSyncer.java:165) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.syncBetweenFolders(DocumentFolderSyncer.java:123) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.performSyncing(DocumentFolderSyncer.java:65) at com.moneydance.apps.md.controller.AccountBookWrapper$DesktopBookSyncer.performPostSyncProcessing(AccountBookWrapper.java:143)”</p>
<p>You need to find and delete file: 49cae438-97f6-4c42-911f-be8d26c70cb9.txn</p>
<p>Look in:<br>
dropbox/.moneydancesync/f830dab7-e909-4bf1-b524-2798395c7aea/v3<br>
(You might need to look in dropbox online)</p>
<p>or</p>
<p>C:\Users\david.moneydance\Documents\David L_ Greene and Mary S_ Greene-20170616-1919 (2017_06_18 14_16_17 UTC)-20180730-1922-20200310-1519-20201204-1021-20201204-1231-20210521-1759-20210802-1832 2-20211230-0945.moneydance/safe/tiksync/in and out</p>
<p>Then restart MD</p>
<p>Try again.</p>
<p>Any good?</p>
<p>When you are done, run toolbox extension, update mode, rename dataset to a better.shorter name,… 😉</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/570933622022-12-11T23:27:22Z2022-12-11T23:27:22ZIssues with 'Portfolio View' - refreshes on its own to inaccurate figures<div><p>This is the culprit:</p>
<p>“Error reading synced transactions from file 49cae438-97f6-4c42-911f-be8d26c70cb9.txn: java.lang.Exception: Unsupported action:-47af-8658-e8f8a3e82cfd%260.acct%3D165%26ts%3D1668809416345: from file 49cae438-97f6-4c42-911f-be8d26c70cb9.txn java.lang.Exception: Unsupported action:-47af-8658-e8f8a3e82cfd%260.acct%3D165%26ts%3D1668809416345: from file 49cae438-97f6-4c42-911f-be8d26c70cb9.txn<br>
at com.moneydance.apps.md.controller.sync.SyncTxnReaderX.run(SyncTxnReaderX.java:167) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.applyTransactionFile(DocumentFolderSyncer.java:165) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.syncBetweenFolders(DocumentFolderSyncer.java:123) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.performSyncing(DocumentFolderSyncer.java:65) at com.moneydance.apps.md.controller.AccountBookWrapper$DesktopBookSyncer.performPostSyncProcessing(AccountBookWrapper.java:143)”</p>
<p>You need to find and delete file: 49cae438-97f6-4c42-911f-be8d26c70cb9.txn</p>
<p>Look in:<br>
dropbox/.moneydancesync/f830dab7-e909-4bf1-b524-2798395c7aea/v3<br>
(You might need to look in dropbox online)</p>
<p>or</p>
<p>C:\Users\david.moneydance\Documents\David L_ Greene and Mary S_ Greene-20170616-1919 (2017_06_18 14_16_17 UTC)-20180730-1922-20200310-1519-20201204-1021-20201204-1231-20210521-1759-20210802-1832 2-20211230-0945.moneydance/safe/tiksync/in and out</p>
<p>Then restart MD</p>
<p>Try again.</p>
<p>Any good?</p>
<p>When you are done, run toolbox extension, update mode, rename dataset to a better.shorter name,… 😉</p></div>Stuart Beesley (Mr Toolbox)