Issues with 'Portfolio View' - refreshes on its own to inaccurate figures

David Greene's Avatar

David Greene

09 Dec, 2022 12:18 AM

I am running 2022.5 (4091). Data files size is 193,552,000 as I have 17 years of data on here. I can get fairly accurate portfolio reports using 'Reports and Graphs', but the default 'Portfolio View' keeps changing 'like a screen saver' to goofy figures as if it has a mind of its own'. Is my file size causing an issue, should I wipe down to maybe 1 year of information and manually reload my investment balances?. NOTE: I am primarily using MD for cashflow and tracking future expenditures, the art of trying to keep it in balance with my broker is very difficult, plus when I sell a bond, I just have to manually go in and wipe the purchase and sale, MD just cannot handle the bookkeeping or the reporting of the portfolio part of it. At any rate, I wondered if a fresh restart might help. your advice appreciated.
Thanks

  1. 1 Posted by dtd on 09 Dec, 2022 12:57 AM

    dtd's Avatar

    just a user - you don't really need a fresh restart, as the file size won't be causing any of these issues.

    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.

    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...

    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.

    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.

    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.

    1) Your file size should not be causing the issues you describe.
    2) Shrink your dataset in this order:
        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.
    4) Your other issues can be dealt with once you remove your concern about file size.

    Hope that helps.

  2. 2 Posted by Stuart Beesley ... on 09 Dec, 2022 07:20 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Exactly as dtd says. In addition,

    1. Send help/console
    2. Run toolbox, analyse dataset and objects first and upload the output here. Would be interesting to see this before you start.
  3. 3 Posted by David Greene on 09 Dec, 2022 05:59 PM

    David Greene's Avatar

      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.

  4. 4 Posted by Stuart Beesley ... on 09 Dec, 2022 06:15 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I’m guessing you haven’t clicked top left, toolbox options, enable advanced mode first?

  5. 5 Posted by David Greene on 10 Dec, 2022 12:00 AM

    David Greene's Avatar

      From 193,978 to 72,011, that's quite an improvement, thank you.  Left
    setting on there for 30 days.

    David

       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).

  6. 6 Posted by dwg on 10 Dec, 2022 12:57 AM

    dwg's Avatar

    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.

    Depending on what operating system and version you are using the error log should be in one of the following locations

    1. macOS

    If you are using a Mac, it should be located at one of these locations within your Home folder:

    macOS Big Sur and Monterey:
    ~/Library/Containers/Moneydance/Data/Library/Application Support/Moneydance/errlog.txt

    macOS X Lion until macOS X Catalina:
    ~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt

    macOS X Snow Leopard and earlier:
    ~/Library/Application Support/Moneydance/errlog.txt

    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:

    ~/Library

    This should pull up your local Library folder.

    2. Windows

    If you are using Windows, it should be located under your login directory at:

    Windows Vista and later:

    C:\Users\(yourusername)\.moneydance\errlog.txt

    or

    Before Windows Vista:

    C:\Documents and Settings\(yourusername)\.moneydance\errlog.txt

    3. Linux

    If you are using Linux it should be located in your home folder at:
    ~/.moneydance/errlog.txt

  7. 7 Posted by David L Greene on 10 Dec, 2022 01:22 AM

    David L Greene's Avatar

    I got it to work. Below is note I sent to support after shrink.

    From 193,978 to 72,011, that's quite an improvement, thank you. Left setting on there for 30 days.

    David

      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).

  8. 8 Posted by dtd on 10 Dec, 2022 01:34 AM

    dtd's Avatar

    just a user - I'm fairly certain that dwg was talking about your "Portfolio View" problem, not about shrinking the dataset.

  9. 9 Posted by Stuart Beesley ... on 10 Dec, 2022 08:03 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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.

  10. 10 Posted by David Greene on 10 Dec, 2022 03:39 PM

    David Greene's Avatar

    see attached.

  11. 11 Posted by Stuart Beesley ... on 10 Dec, 2022 04:27 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Nothing attached. You need to go online and attach it.

  12. 12 Posted by David Greene on 10 Dec, 2022 04:36 PM

    David Greene's Avatar

    see attached

  13. 13 Posted by Stuart Beesley ... on 11 Dec, 2022 08:56 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    This is the culprit:

    “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
    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)”

    You need to find and delete file: 49cae438-97f6-4c42-911f-be8d26c70cb9.txn

    Look in:
    dropbox/.moneydancesync/f830dab7-e909-4bf1-b524-2798395c7aea/v3
    (You might need to look in dropbox online)

    or

    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

    Then restart MD

    Try again.

    Any good?

    When you are done, run toolbox extension, update mode, rename dataset to a better.shorter name,… 😉

  14. 14 Posted by Stuart Beesley ... on 11 Dec, 2022 11:27 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    This is the culprit:

    “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
    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)”

    You need to find and delete file: 49cae438-97f6-4c42-911f-be8d26c70cb9.txn

    Look in:
    dropbox/.moneydancesync/f830dab7-e909-4bf1-b524-2798395c7aea/v3
    (You might need to look in dropbox online)

    or

    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

    Then restart MD

    Try again.

    Any good?

    When you are done, run toolbox extension, update mode, rename dataset to a better.shorter name,… :wink:

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac