Error Message when exporting file

jmorri20's Avatar

jmorri20

18 Oct, 2021 02:02 AM

I am receiving an error message when attempting a file export. The message states: "Error exporting to file: Cannot invoke".com.infinitekind.moneydance.model.CurrencyTyper.format(long, char) because "this.fields. secFurr is null". The file is unexecutable when I try to open it. Creating a copy of my .qif file is what I am trying to ultimately accomplish. Thank you for any any assistance or direction.

  1. 1 Posted by Stuart Beesley ... on 18 Oct, 2021 06:38 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    What version of MD?
    Can you Window>Show Console and share the whole error stack trace....?

  2. 2 Posted by Jeffrey Morriso... on 19 Oct, 2021 12:11 AM

    Jeffrey Morrison's Avatar

    Thank you for your reply.  The MD version is 2021.1(3039). Not clear on second question. Please clarify.  
        On Monday, October 18, 2021, 01:39:03 AM CDT, Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’ <[email blocked]> wrote:
     
       
    |

  3. 3 Posted by Stuart Beesley ... on 19 Oct, 2021 09:21 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    Look in Moneydance, Menu, Help, Console Window... after you get the error... post the contents back here...

  4. 4 Posted by jmorri20 on 21 Oct, 2021 12:43 AM

    jmorri20's Avatar

    Is this what you are looking for? Thanks!

    Starting Moneydance 2021.1 (3039) at Wed Oct 20 19:37:28 CDT 2021
    Settings Folder: C:\Users\Jeff\.moneydance
    OS: Windows 10 10.0 amd64
    Java: 15.0.1 (AdoptOpenJDK)
    Is in sandbox: false; restricted file access: false
    Initializing fonts:
      default: [[Dialog]]
      monospaced: [[Calibri, Monospaced]]
      coding: [[Hack, Monospaced]]
    fonts resolved:
     default: Dialog:12.0:style0
     mono: Calibri:12.0:style0
     coding: Hack:12.0:style0
     print: Helvetica:12.0:style0
     header: Dialog:14.0:style0
     register: Dialog:11.0:style0
     reportTitle: Dialog:32.0:style0
     calendarTitle: Dialog:11.0:style0
     reportHeader: Dialog:10.0:style0
     detailTitle: Dialog:14.0:style0
    Setting look and feel class to com.sun.java.swing.plaf.windows.WindowsLookAndFeel
    opening last file: Personal Finances 5-20201025-1547
    loading dataset: C:\Users\Jeff\.moneydance\Documents\Personal Finances 5-20201025-1547.moneydance
    set antialiasing to HRGB
    creatingURLStreamHandler for protocol 'http'
    loading with 128 bit encryption key
    reading trunk data tiksync/trunk
    trunk data loaded (1.041 seconds), checking for incremental updates
    loading un-synced txn files...
    error loading txn file tiksync/out/20160824015254_959.txn; continuing. error: java.io.IOException: javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
    loading synced txn files...
    replacing root: null () with new root: Personal Finances (6ba3a43f-98fa-4cda-a9d7-1ee0196f1007
    Export error: java.lang.NullPointerException: Cannot invoke "com.infinitekind.moneydance.model.CurrencyType.format(long, char)" because "this.fields.secCurr" is null
    java.lang.NullPointerException: Cannot invoke "com.infinitekind.moneydance.model.CurrencyType.format(long, char)" because "this.fields.secCurr" is null
    at com.moneydance.apps.md.controller.io.QIFDataWriter.writeInvestTxn(QIFDataWriter.java:334)
    at com.moneydance.apps.md.controller.io.QIFDataWriter.writeAccountInfo(QIFDataWriter.java:249)
    at com.moneydance.apps.md.controller.io.QIFDataWriter.writeAccounts(QIFDataWriter.java:88)
    at com.moneydance.apps.md.controller.Main.exportAllAccountsIntoQIF(Main.java:1794)
    at com.moneydance.apps.md.view.gui.ExportWindow.doExport(ExportWindow.java:239)
    at com.moneydance.apps.md.view.gui.ExportWindow.buttonPressed(ExportWindow.java:257)
    at com.moneydance.apps.md.view.gui.OKButtonPanel.okButtonPressed(OKButtonPanel.java:222)
    at com.moneydance.apps.md.view.gui.OKButtonPanel$1.actionPerformed(OKButtonPanel.java:123)
    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.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    at java.desktop/java.awt.Component.processMouseEvent(Unknown Source)
    at java.desktop/javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.desktop/java.awt.Component.processEvent(Unknown Source)
    at java.desktop/java.awt.Container.processEvent(Unknown Source)
    at java.desktop/java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.Component.dispatchEvent(Unknown Source)
    at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.desktop/java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.desktop/java.awt.Component.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)

  5. 5 Posted by Stuart Beesley ... on 21 Oct, 2021 11:03 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    First thing you should do is to upgrade to 2021.1(3069) from here:
    https://infinitekind.com/download_2021

    This won't fix this issue tho' - see next message

  6. 6 Posted by Stuart Beesley ... on 21 Oct, 2021 11:37 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    OK, I think you have an Investment Account > Security Sub Record (this is a Security assigned into an Investment Account) which has lost it's Currency (the link to the Security Master record). It's failing on a SELLXFR. I can't quite reproduce your error, but I think I know the fix..

    Upgrade to 2021.1(3069)... Install Toolbox extension. Run Toolbox. Advanced Mode. Menu: Currency & Security Tools. Option
    "FIX: Detect and fix Investment Security records not properly linked to Security Master records"

    If I am right, then when you run this, you will see the errant security... You need to assign it... You may have to create a dummy Security first....

    Then, hopefully your extract will work...

    Let me know either way?

    (not support, just a fellow user)

  7. 7 Posted by Stuart Beesley ... on 21 Oct, 2021 01:02 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    PS - does the QIF file tell you where it bombed...? What does the last 20 lines contain?

  8. 8 Posted by Jeffrey Morriso... on 23 Oct, 2021 10:02 PM

    Jeffrey Morrison's Avatar

    Thank you again.   I was able to upgrade and  navigate my through your recommendations, but due to my own ignorance, I do not know exactly how to identify or "link" the errant security as I am just an end user type and not familiar with inner workings of MD.
    Below is the report that I think identifies the errant/non linked securities.   Any further guidance or wisdom greatly appreciated.

  9. 9 Posted by Stuart Beesley ... on 24 Oct, 2021 04:49 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    There was nothing attached? No report?

    You said you were able to navigate my through my recommendations. What exactly did you do and what did you see / not see...

  10. 10 Posted by Jeffrey Morriso... on 24 Oct, 2021 05:17 PM

    Jeffrey Morrison's Avatar

    I tried to attach the report on the last email.  For some reason it did not go through.   Please see below.

  11. 11 Posted by jmorri20 on 24 Oct, 2021 05:47 PM

    jmorri20's Avatar

    see attachment for findings from toolbox

  12. 12 Posted by Stuart Beesley ... on 24 Oct, 2021 06:13 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    You have currency errors.. You can either upgrade to 2022 (where this issue is fixed), or Toolbox can fix these. BACKUP FIRST. Turn on Advanced mode.. Then go back to this menu and select fix currencies / securities. Select fix both errors and warnings.

    BUT, I have no idea if this is the cause of the export issue......

    Did you try running this as suggested?
    "FIX: Detect and fix Investment Security records not properly linked to Security Master records"?

  13. 13 Posted by Stuart Beesley ... on 31 Oct, 2021 07:06 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    FYI - I have found the cause of your issue.....! The latest Toolbox extension can detect it and tell you where the error(s) are: Advanced mode. Menu Transaction Tools, then:

    "FIX: Non-Hierarchical Security Acct Txns (& detect Orphans)"

    It will popup and tell you the invalid record(s)..

    This is caused by you FORCE removing a security from an Investment Account where there were transactions (and then saying 'yes' to delete)... This causes data damage and in fact is now blocked in MD2022(4060)... This action causes txns like Buy/Sell/Xfr to be left behind with no security attachment... The txns are irreparable, but you can by pass the issue by deleting these damaged txns..

    Let me know if this helps?

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