Need help: Graphs and Reports not showing up

frederick's Avatar

frederick

04 Jul, 2022 03:49 PM

When I navigate to Tools and click on Graphs and Reports, no window shows up.

I am running Moneydance 2022.4 on OSX Monterary 12. 4.

> To create a graph or report, navigate to Tools → Graphs and Reports. In the window that opens you can choose the graph/report you'd like to use and amend the report settings.

TIA Frederick

  1. 1 Posted by -Kevin N. on 04 Jul, 2022 05:51 PM

    -Kevin N.'s Avatar

    Hi Frederick,

    The Graphs and Reports window is likely rendering off-screen.

    This phenomenon is sometimes caused by connecting a second monitor to your machine and then subsequently removing it.

    If that is the case, you could try reconnecting the second monitor to retrieve the orphaned window.

    Or, if not installed already, install the Toolbox extension > Restart Moneydance.
    Open the Toolbox from Moneydance's Extensions Menu.
    From the Toolbox menu bar, go to 'Toolbox Options' > 'Update Mode' > Reply to the prompts.
    Click the 'MENU: General Tools' button.
    Select 'RESET Window Display Settings' > RESET Only Window Locations on their own. (Exclude Filters and Views)
    You may or may not need to restart Moneydance for the changes to take effect.

    -Kevin N. (not a member of MD support)

  2. 2 Posted by frederick on 05 Jul, 2022 08:18 PM

    frederick's Avatar

    @Kevin Thanks. I followed the routine outlined below twice with no change in the behavior. The other window options (Reminders, Budget Manager, etc) show up, just not Graphs and Reports.

    I hid all applications in case the window might be hiding behind another application, found nothing

    regards,

    Frederick Yocum

  3. 3 Posted by Stuart Beesley ... on 05 Jul, 2022 08:28 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    After trying the graph… Go to help/console and post the results here.

  4. 4 Posted by frederick on 06 Jul, 2022 01:39 AM

    frederick's Avatar

    Starting Moneydance 2022.4 (4087) at Tue Jul 05 21:35:08 EDT 2022
    Settings Folder: /Users/frederickyocum/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance
    OS: Mac OS X 12.4 x86_64
    Architecture: intel64
    Java: 18.0.1 (Eclipse Adoptium)
    Is in sandbox: true; restricted file access: false
    Library path: /Applications/Moneydance.app/Contents/MacOS:/Applications/Moneydance.app/Contents/PlugIns/vm.jdk/Contents/Home/lib:/Applications/Moneydance.app/Contents/MacOS:/Applications/Moneydance.app/Contents/PlugIns/vm.jdk/Contents/Home/Frameworks
    initialized extension moneyforesight in 0.246 seconds
    python.path: /Users/frederickyocum/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/python
    python.cachedir: /Users/frederickyocum/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/python/cache
    python.cachedir.skip: false
    net_account_balances: Startup conditions passed (and no other instances of this program detected). Now executing....
    net_account_balances.py(Extension):2022/07/05-21:35:12: net_account_balances.py(Extension) : Python Script Initialising....... Build: 1013
    net_account_balances.py(Extension):2022/07/05-21:35:12: HomePageView widget / extension is now running...
    net_account_balances.py(Extension):2022/07/05-21:35:12: ##########################################################################################
    net_account_balances.py(Extension):2022/07/05-21:35:12: Extension: net_account_balances:Custom Balances (HomePageView widget) initialising....
    net_account_balances.py(Extension):2022/07/05-21:35:12: ##########################################################################################
    net_account_balances.py(Extension):2022/07/05-21:35:12: StuWareSoftSystems - net_account_balances.py(Extension) initialisation routines ending......
    initialized extension net_account_balances in 2.328 seconds
    Font initialisation attempted from non-UI thread. Hopping over to dispatch thread...
    Initializing fonts:
      default: [[SF Pro Display, SF Display, Helvetica Neue, Helvetica, Lucida Grande, Dialog]]
      printing: [[SF Pro Display, SF Display, Helvetica Neue, Helvetica, Lucida Grande, Dialog]]
      monospaced: [[Gill Sans, Menlo, Monaco, Monospaced]]
      coding: [[Hack, Monospaced]]
    fonts resolved:
     default: SF Pro Display:13.0:style0
     mono: Gill Sans:13.0:style0
     coding: Hack:13.0:style0
     print: SF Pro Display:12.0:style0
     header: SF Pro Display:15.0:style0
     register: SF Pro Display:12.0:style0
     reportTitle: SF Pro Display:32.0:style0
     calendarTitle: SF Pro Display:12.0:style0
     reportHeader: SF Pro Display:11.0:style0
     detailTitle: SF Pro Display:15.0:style0
    detected system appearance: org.violetlib.vappearances.VAppearanceImpl@323e026d
    detected system appearance: org.violetlib.vappearances.VAppearanceImpl@323e026d
    Setting look and feel class to org.violetlib.aqua.AquaLookAndFeel
    Font initialisation attempted from non-UI thread. Hopping over to dispatch thread...
    ratios (0): 07-05 21:35:13.612|Initialized build Build 1034 ok
    initialized extension ratios in 0.845 seconds

    -----------------------------------------------------
    Toolbox - quick information:
    MD CONSOLE FILE LOCATION: '/Users/frederickyocum/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt'
    MD CONFIG/PREFERENCES LOCATION: '/Users/frederickyocum/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/config.dict'
    MD EXECUTION MODE: 2 (Normal)
    JVM - Available processor cores: 4
    JVM - Maximum memory possible: 14.4 GB
    JVM - Total memory allocated: 0.3 GB (used 0.1 GB / free 0.2 GB)
    -----------------------------------------------------

    #####################################################################
    toolbox: toolbox_init.py initializer script running - doing nothing - will exit....
    #####################################################################

    initialized extension toolbox in 0.012 seconds

    #####################################################################
    total_selected_transactions: total_selected_transactions_init.py initializer script running - doing nothing - will exit....
    #####################################################################

    initialized extension total_selected_transactions in 0.002 seconds
    opening last file: /Volumes/Data/Documents/Administration/Accounts_Records/MoneyDanceCurrent/US Finances.moneydance
    loading dataset: /Volumes/Data/Documents/Administration/Accounts_Records/MoneyDanceCurrent/US Finances.moneydance
    loading with 128 bit encryption key
    reading trunk data tiksync/trunk
    trunk data loaded (0.09 seconds), checking for incremental updates
    loading un-synced txn files...
    loading synced txn files...
    replacing root: null () with new root: Our Finances (03b4ed04-d685-4f64-8c7e-b55d99ae2d12
    ICloudContainer.isContainerAvailable(): nativeGetICloudPath: /Users/frederickyocum/Library/Mobile Documents/iCloud~com~infinitekind~moneydancesync
    net_account_balances.py(Extension):2022/07/05-21:35:14: Initialising PARAMETERS....
    VAQUA: system appearance did change
    detected system appearance: org.violetlib.vappearances.VAppearanceImpl@323e026d
    VAQUA: applying updated theme: default
    detected system appearance: org.violetlib.vappearances.VAppearanceImpl@323e026d
    Setting look and feel class to org.violetlib.aqua.AquaLookAndFeel
    Java version: 1800001
    Update info received with successful signature verification
    Version info retrieved; we are up to date!
    Exception in thread "AWT-EventQueue-0" java.lang.IllegalArgumentException: setSelectedIndex: 0 out of bounds
    at java.desktop/javax.swing.JComboBox.setSelectedIndex(Unknown Source)
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.getConfigPanel(CurrencyGraph.java:95)
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.setParameters(CurrencyGraph.java:41)
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.setInfo(GraphReportGenerator.java:169)
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.getGenerator(GraphReportGenerator.java:386)
    at com.moneydance.apps.md.view.gui.GraphReportWindow.<init>(GraphReportWindow.java:45)
    at com.moneydance.apps.md.view.gui.MoneydanceGUI.showReports(MoneydanceGUI.java:1444)
    at com.moneydance.apps.md.view.gui.MainMenu$ActionEventHandler.run(MainMenu.java:630)
    at com.moneydance.apps.md.view.gui.MainMenu.actionPerformed(MainMenu.java:686)
    at com.moneydance.apps.md.view.gui.MDAction.actionPerformed(MDAction.java:243)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    at java.desktop/javax.swing.AbstractButton.doClick(Unknown Source)
    at java.desktop/com.apple.laf.ScreenMenuItem.actionPerformed(Unknown Source)
    at java.desktop/java.awt.MenuItem.processActionEvent(Unknown Source)
    at java.desktop/java.awt.MenuItem.processEvent(Unknown Source)
    at java.desktop/java.awt.MenuComponent.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.MenuComponent.dispatchEvent(Unknown Source)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
    at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
    at java.base/java.security.AccessController.doPrivileged(Unknown Source)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
    at java.desktop/java.awt.EventQueue$5.run(Unknown Source)
    at java.base/java.security.AccessController.doPrivileged(Unknown Source)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
    at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)

    regards,

    Frederick Yocum

  5. 5 Posted by Stuart Beesley ... on 06 Jul, 2022 05:10 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Ok. That’s a new one. You have a Java crash.

    java.lang.IllegalArgumentException: setSelectedIndex: 0 out of bounds 
    at java.desktop/javax.swing.JComboBox.setSelectedIndex(Unknown Source) 
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.getConfigPanel(CurrencyGraph.java:95) 
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.setParameters(CurrencyGraph.java:41) 
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.setInfo(GraphReportGenerator.java:169) 
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.getGenerator(GraphReportGenerator.java:386) 
    at com.moneydance.apps.md.view.gui.GraphReportWindow.<init>(GraphReportWindow.java:45) 
    at com.moneydance.apps.md.view.gui.MoneydanceGUI.showReports(MoneydanceGUI.java:1444)
    

    So…
    - have you ever used reports and graphs before? Ie - do any exist? - is this a new dataset? - what steps are you following exactly, what do you see, before the crash?

  6. 6 Posted by Stuart Beesley ... on 06 Jul, 2022 05:44 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Also. Can you install/run toolbox extn. Click analyse dataset and objects. There is a section which lists objects/counts. Can you copy that and paste back here.

  7. 7 Posted by Stuart Beesley ... on 06 Jul, 2022 07:33 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK, it's very odd. It's failing trying to select the first currency in the list of currencies. I assume you do have currencies listed in Tools/Currencies?

    Can you try this..
    Menu, Window, Show Moneybot Console. Then in the Python Snippet area paste this command:

    moneydance.getUI().showReports(None)
    

    Then click Run Snippet..

    Does this work..? If not, can you go to Help / Console Window again and send a new console log....

  8. 8 Posted by Stuart Beesley ... on 06 Jul, 2022 11:33 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    In fact, can you then run this script too:

    from com.moneydance.apps.md.view.gui import CurrencyModel
    book = moneydance.getCurrentAccountBook()
    fcm = CurrencyModel(book.getCurrencies())
    print "-------"
    print "size:", fcm.getSize()
    for i in range(fcm.getSize()): print fcm.getElementAt(i)
    print "-------"
    

    and send results...

  9. 9 Posted by frederick on 06 Jul, 2022 09:06 PM

    frederick's Avatar

    @Stuart

    I am not sure I have used the Reports and Graphs dialog before. I have used reports and graphs. To create a new one I usually I have clicked on one in the sidebar and adapted it.
    > have you ever used reports and graphs before? Ie - do any exist?

    Nope
    > is this a new dataset?

    Let me count the ways. Open the app click on Tools>Reports and Graphs. Do some work in the register click on Tools>Reports and Graphs. Etc. Etc.
    > what steps are you following exactly.

    Nothing. No flash of activity, no windows appearing disappearing . . .

    > what do you see, before the crash?

    Should I uninstall and reinstall?

    regards,

    Frederick Yocum

  10. 10 Posted by Stuart Beesley ... on 07 Jul, 2022 05:18 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Your answers are confusing.

    I think you are saying that you do run reports successfully from the left sidebar and these are still OK? Yes? Have you ever clicked Memorize after running these?

    But you do not use the menu we are talking about. Correct?

    You should do the two things I’ve asked in posts 7 and 8…

    You should also restart md, then click each report/graph on the left and confirm the report displays. Make a note of which ones do not. At the end post a new console here and the list of which ones didn’t work.

  11. 11 Posted by frederick on 07 Jul, 2022 08:17 PM

    frederick's Avatar

    Reply to Stuart Beesley (Mr Toolbox)

    Yes, I have run reports from the sidebar. List of the reports that only show Error Generating Graph in the main window below. The rest display data.

    > I think you are saying that you do run reports successfully from the left sidebar and these are still OK? Yes?

    Error Generating Graph

    - Asset Allocation
    - Current History
    - Net Worth
    - Security Performance

    Yes. Confirmed by opening two reports from the sidebar and memorizing altered versions. No errors result as expected.

    > Have you ever clicked Memorize after running these? But you do not use the menu we are talking about. Correct?

    Done see below for the reports that generate and error in the window. Nothing shows up in the console.

    > You should also restart md, then click each report/graph on the left and confirm the report displays. Make a note of which ones do not. At the end post a new console here and the list of which ones didn’t work.

    Earlier requests. Sorry responding to email notifications. Posts 7 and 8 Never showed up.

    > You should do the two things I’ve asked in posts 7 and 8…

    > Click analyse dataset and objects. There is a section which lists objects/counts. Can you copy that and paste back here.

    ```bash
    DATABASE OBJECT COUNT (count) (est.size KBs):
    ------------------------------------------------------
    Object: mem_rpt 4 2.6
    Object: bdgt 1 0.1
    Object: reminder 42 30.2
    Object: txn 1866 826.3
    Object: olsvc 1 0.1
    Object: oltxns 44 4.0
    Object: bdgtitem 60 13.5
    Object: acct 82 31.1
    Object: misc 2 0.1
     ==========
     TOTAL: 2102 908.1

    ```

    > Menu, Window, Show Moneybot Console. Then in the Python Snippet area paste this command: `moneydance.getUI().showReports(None)`

    From Money Bot Console

    ```
    Beginning snippet at Thu Jul 07 15:53:56 EDT 2022
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
    at java.desktop/javax.swing.JComboBox.setSelectedIndex(Unknown Source)
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.getConfigPanel(CurrencyGraph.java:95)
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.setParameters(CurrencyGraph.java:41)
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.setInfo(GraphReportGenerator.java:169)
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.getGenerator(GraphReportGenerator.java:386)
    at com.moneydance.apps.md.view.gui.GraphReportWindow.<init>(GraphReportWindow.java:45)
    at com.moneydance.apps.md.view.gui.MoneydanceGUI.showReports(MoneydanceGUI.java:1444)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)
    at java.base/java.lang.reflect.Method.invoke(Unknown Source)
    java.lang.IllegalArgumentException: java.lang.IllegalArgumentException: setSelectedIndex: 0 out of bounds

    ```

    From Window Console

    ```
    initialising python interpreter
    Error running script: Traceback (most recent call last):
      File "<string>", line 1, in <module>
    at java.desktop/javax.swing.JComboBox.setSelectedIndex(Unknown Source)
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.getConfigPanel(CurrencyGraph.java:95)
    at com.moneydance.apps.md.view.gui.graphtool.CurrencyGraph.setParameters(CurrencyGraph.java:41)
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.setInfo(GraphReportGenerator.java:169)
    at com.moneydance.apps.md.view.gui.GraphReportGenerator.getGenerator(GraphReportGenerator.java:386)
    at com.moneydance.apps.md.view.gui.GraphReportWindow.<init>(GraphReportWindow.java:45)
    at com.moneydance.apps.md.view.gui.MoneydanceGUI.showReports(MoneydanceGUI.java:1444)
    at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source)
    at java.base/java.lang.reflect.Method.invoke(Unknown Source)
    java.lang.IllegalArgumentException: java.lang.IllegalArgumentException: setSelectedIndex: 0 out of bounds

    ```

    > In fact, can you then run this script too:

    ```
    from com.moneydance.apps.md.view.gui import CurrencyModel
    book = moneydance.getCurrentAccountBook()
    fcm = CurrencyModel(book.getCurrencies())
    print "-------"
    print "size:", fcm.getSize()
    for i in range(fcm.getSize()): print fcm.getElementAt(i)
    print "-------"

    ```

    From Money Bot Console

    ```bash
    Beginning snippet at Thu Jul 07 15:58:07 EDT 2022
    -------
    size: 0
    -------
    Finished running snippet normally at Thu Jul 07 15:58:07 EDT 2022
    ```

    TIA

  12. 12 Posted by Stuart Beesley ... on 07 Jul, 2022 09:44 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Size: 0 is the issue. Can you send a screenshot of tools/currencies?

  13. 13 Posted by Stuart Beesley ... on 07 Jul, 2022 10:02 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    In fact, unless I’m misreading the stats, you would appear to have no currencies at all. This would seem impossible. So, back to what does tools/currencies show? If it only shows one, can you edit that, save, restart, and then see what works?

  14. 14 Posted by frederick on 08 Jul, 2022 01:14 AM

    frederick's Avatar

    Here are screenshots of the the Tools>Currency dialog. There are no currencies defined and no base currency. I tried creating a base currency but the set base currency option remains grayed out. There is also a screenshot of an account (Financial details grayed out). There is a currency set on the account.

  15. 15 Posted by frederick on 08 Jul, 2022 01:16 AM

    frederick's Avatar

    Looks like the files were stripped, I try again

  16. 16 Posted by Stuart Beesley ... on 08 Jul, 2022 05:46 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I’m confused. One SS shows no currencies and the other shows USD. Did it start empty and then you clicked + and added USD? The reason set base is grey is that it’s already (now) base.

    If you just now added USD then I expect your graphs and reports will now work.

    ??

  17. 17 Posted by frederick on 08 Jul, 2022 11:59 AM

    frederick's Avatar

    @Stuart The second screen grab was taken after adding the currency. After I got through all the tests I and entering the currency, I did not think to check whether anything had changed. The grayed out "Set base currency threw me." I have checked now and Reports and Graphs is working!

    Thanks for your help and tenacity.

    Frederick

  18. 18 Posted by Stuart Beesley ... on 08 Jul, 2022 12:32 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Great! 👍 so the question is…. How did you end up with no currencies? Did you manually delete them all? Have they ever been there?

  19. 19 Posted by frederick on 09 Jul, 2022 12:03 PM

    frederick's Avatar

    I have looked at currencies earlier, because we have assets in two countries, but didn't make any conscious changes.

    I run two separate sets of accounts in MoneyDance, one for each country. In the other file, the correct currency is assigned, UK pound. The U.S. account is the one that gets the most activity and was the one I transferred to MoneyDance first. DIdn't occur to me to check the UK file until this morning.

    Is there a log that would record a change like that?

  20. 20 Posted by Stuart Beesley ... on 09 Jul, 2022 12:04 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    nothing easy you can find....

  21. System closed this discussion on 08 Oct, 2022 12:10 PM.

Comments are currently closed for this discussion. You can start a new one.

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