Successful sync mismatch, logs show Exception: Unsupported action:88038912065

icycle's Avatar

icycle

11 Sep, 2023 04:46 PM

I have 3 devices that I sync using Dropbox Folder (2 macbooks and 1 android). I see a mismatch in one account (only) where the users on each macbook were both working. The issue is specifically missing transactions, one side thinks there are 8 unconfirmed transactions and the other side 1, and the ledger balances mismatch by hundreds of dollars. Looking into the console logs on each side, I see an exception repeating, which seems like a contributing factor:

Error reading synced transactions from file 49ae57af-28d9-49a6-bdb8-6a9073bb0579.txn: java.lang.Exception: Unsupported action:88038912065: from file 49ae57af-28d9-49a6-bdb8-6a9073bb0579.txn
java.lang.Exception: Unsupported action:88038912065: from file 49ae57af-28d9-49a6-bdb8-6a9073bb0579.txn
at com.moneydance.apps.md.controller.sync.SyncTxnReaderX.run(SyncTxnReaderX.java:167) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.applyTransactionFile(DocumentFolderSyncer.java:170) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.syncBetweenFolders(DocumentFolderSyncer.java:128) at com.moneydance.apps.md.controller.sync.DocumentFolderSyncer.performSyncing(DocumentFolderSyncer.java:66) at com.moneydance.apps.md.controller.AccountBookWrapper$DesktopBookSyncer.performPostSyncProcessing(AccountBookWrapper.java:145) at com.infinitekind.tiksync.Syncer$SyncThread.run(Syncer.kt:907)

I didn't make this private as I don't think there's any PII here, but it may be specific to my environment. At one point in the recent past the laptops were not both running the same MD version, but they have been for at least a month.

Let me know if this could be recoverable through the system, or if I should manually go through the account on each side to find the gaps.

thank you

  1. 1 Posted by icycle on 11 Sep, 2023 05:06 PM

    icycle's Avatar

    Update: I multi-selected transaction ranges within the mismatched account for each month July-Sept on each side and found that the issues were isolated to August. It was, in fact, the unconfirmed transactions on one side. So to fix, I edited each transaction on the laptop that had confirmed them (usually adding a character to the memo field) and that caused them to re-sync and, in most cases, automatically merge and disappear from the unconfirmed list.

    Now the accounts match but the exception still occurs. I can use the heavy hammer approach and disable sync on each side, clean out the sync dir, and re-configure the clients to sync. But I will wait before doing so in case you need more info on this issue from my side.

  2. 2 Posted by Stuart Beesley ... on 11 Sep, 2023 05:09 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    You simply need to delete the file:
    49ae57af-28d9-49a6-bdb8-6a9073bb0579.txn
    From the root of the sync folder

    Or use latest toolbox preview from:
    https://yogi1967.github.io/MoneydancePythonScripts/
    It can do it for you.

    Out of interest, you can use toolbox to first decrypt and peek at the file to see why it’s duff (general tools menu).

  3. 3 Posted by icycle on 12 Sep, 2023 04:22 PM

    icycle's Avatar

    Stuart, thanks much for the informative reply. I've installed your latest (preview) toolbox, what an incredible set of functionality! I used it to decrypt the broken .txn file and found a few missing or incomplete transactions that were on MD mobile but nowhere else. It's all fixed now--I removed the broken file and restarted MD for a clean console log and that's what I got.

  4. icycle closed this discussion on 12 Sep, 2023 04:23 PM.

  5. Stuart Beesley (Mr Toolbox) re-opened this discussion on 12 Sep, 2023 04:38 PM

  6. 4 Posted by Stuart Beesley ... on 12 Sep, 2023 04:38 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Toolbox 🧰 +1 😃

  7. Maddy closed this discussion on 12 Sep, 2023 05:11 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