github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-07-16 07:04:23 -05:00
Code Issues 3.0k Packages Projects Releases 58 Wiki Activity

[Bug]: API intermittently fails to open budget with automated transaction imports #917

New Issue
Closed
opened 2026-02-28 19:24:56 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-02-28 19:24:56 -06:00
Owner
Copy Link

Originally created by @spenco100 on GitHub (Feb 7, 2024).

Verified issue does not already exist?

  • I have searched and found no existing issue

Is this related to GoCardless, Simplefin or another bank-sync provider?

  • I have checked my server logs and could not see any errors there
  • I will be attaching my server logs to this issue
  • I will be attaching my client-side (browser) logs to this issue
  • I understand that this issue will be automatically closed if insufficient information is provided

What happened?

I have a system where all my cards / bank accounts send transaction alerts to a single mailbox, and a server to monitor that mailbox. I parse details from the emails, add the transactions to a google sheet, and then to my new Actual server (hosted on Fly.io)

Intermittently I see transactions that appear in my Google sheet but not in Actual - and my error logging shows the following error coinciding with the times that transactions were processed in my server.

Server running imports with the Actual API logs show:
Error: We had an unknown problem opening “My-Finances-7172b03”.

Has anyone else had this issue? Is there a better method I am not seeing in the docs, to import transactions? Here is my server config and code.

Node version: 18.12.0
Actual API version (running on my 3rd party server):
"@actual-app/api": "^6.4.0"

Actual server version:
"@actual-app/crdt": "2.1.0"
"@actual-app/web": "24.1.0"

Function calling the Actual API from my server:

const api = require('@actual-app/api');
// Write 1+ transaction to the Actual server
async function writeTransactions(transactions) {
    let result = { error: null, response: null };
    try {
        const actualTransactions = transactions.map(convertTransaction);

        await api.init({
            serverURL: host,
            password: password,
        });

        // load the budget
        await api.downloadBudget(actual_sync_id);

        // sort transactions by card into a larger object
        const transactionsByCard = {};
        actualTransactions.forEach(transaction => {
            const { account } = transaction;
            if (!transactionsByCard[account]) transactionsByCard[account] = [];
            transactionsByCard[account].push(transaction);
        });

        Object.keys(transactionsByCard).forEach(account => {
            api.importTransactions(account, transactionsByCard[account]);
        });

    } catch (e) {
        console.error(e);
        result.error = (typeof e != "string") ? JSON.stringify(e) : e;
    } finally {
        await api.shutdown();
        return result;
    }
};

What error did you receive?

Exception from a finished function: Error: We had an unknown problem opening “My-Finances-7172b03”.

Where are you hosting Actual?

Fly.io

What browsers are you seeing the problem on?

No response

Operating System

Linux

Originally created by @spenco100 on GitHub (Feb 7, 2024). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### Is this related to GoCardless, Simplefin or another bank-sync provider? - [ ] I have checked my server logs and could not see any errors there - [X] I will be attaching my server logs to this issue - [ ] I will be attaching my client-side (browser) logs to this issue - [X] I understand that this issue will be automatically closed if insufficient information is provided ### What happened? I have a system where all my cards / bank accounts send transaction alerts to a single mailbox, and a server to monitor that mailbox. I parse details from the emails, add the transactions to a google sheet, and then to my new Actual server (hosted on Fly.io) Intermittently I see transactions that appear in my Google sheet but not in Actual - and my error logging shows the following error coinciding with the times that transactions were processed in my server. Server running imports with the Actual API logs show: `Error: We had an unknown problem opening “My-Finances-7172b03”.` Has anyone else had this issue? Is there a better method I am not seeing in the docs, to import transactions? Here is my server config and code. Node version: 18.12.0 Actual API version (running on my 3rd party server): "@actual-app/api": "^6.4.0" Actual server version: "@actual-app/crdt": "2.1.0" "@actual-app/web": "24.1.0" Function calling the Actual API from my server: ``` const api = require('@actual-app/api'); // Write 1+ transaction to the Actual server async function writeTransactions(transactions) { let result = { error: null, response: null }; try { const actualTransactions = transactions.map(convertTransaction); await api.init({ serverURL: host, password: password, }); // load the budget await api.downloadBudget(actual_sync_id); // sort transactions by card into a larger object const transactionsByCard = {}; actualTransactions.forEach(transaction => { const { account } = transaction; if (!transactionsByCard[account]) transactionsByCard[account] = []; transactionsByCard[account].push(transaction); }); Object.keys(transactionsByCard).forEach(account => { api.importTransactions(account, transactionsByCard[account]); }); } catch (e) { console.error(e); result.error = (typeof e != "string") ? JSON.stringify(e) : e; } finally { await api.shutdown(); return result; } }; ``` ### What error did you receive? Exception from a finished function: Error: We had an unknown problem opening “My-Finances-7172b03”. ### Where are you hosting Actual? Fly.io ### What browsers are you seeing the problem on? _No response_ ### Operating System Linux
GiteaMirror added the bug label 2026-02-28 19:24:56 -06:00
GiteaMirror commented 2026-02-28 19:24:56 -06:00
Author
Owner
Copy Link

@youngcw commented on GitHub (Feb 8, 2024):

The api can be really finicky about node versions. Im on 18.19 and it works fine.

@youngcw commented on GitHub (Feb 8, 2024): The api can be really finicky about node versions. Im on 18.19 and it works fine.
GiteaMirror commented 2026-02-28 19:24:57 -06:00
Author
Owner
Copy Link

@youngcw commented on GitHub (Feb 26, 2024):

Closing for now unless something else comes up. If you are still having issues I recommend trying a few node versions and see what works.

@youngcw commented on GitHub (Feb 26, 2024): Closing for now unless something else comes up. If you are still having issues I recommend trying a few node versions and see what works.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
tech-support
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#917
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?