mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-16 07:04:23 -05:00
[GH-ISSUE #2457] [Bug]: Import of data with long numbers such as -0.30000000000000004 messes the server and we see internal error in multiple places. #7924
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#7924
Reference in New Issue
Block a user
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?
Originally created by @yeluripati-ha on GitHub (Mar 12, 2024).
Original GitHub issue: https://github.com/actualbudget/actual/issues/2457
Verified issue does not already exist?
Is this related to GoCardless, Simplefin or another bank-sync provider?
What happened?
If an imported file/data includes numbers with a long decimal, the server does not seem to be able to handle it. When you scroll the list of transactions to the errant transaction, the server throws an error and needs to be restarted. This cannot be fixed, there is no way to view the transaction so it can be deleted. Restarting the server does not help. I am not able to close the account/delete it, I get an internal error, other screens (like Custom Reports) display internal error after this. My only option is to close and delete the entire file and restart again.
Client version: v24.3.0
Server version: v24.3.0
What error did you receive?
This is the error in the client side browser:
Error: safeNumber: can’t safely perform arithmetic with number: 3000000000000000500 at N_ (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:58:92092) at _n (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:58:92257) at wt (https://192.168.25.175:5006/static/js/wide.Puo4nQYF.chunk.js:1:56913) at https://192.168.25.175:5006/static/js/wide.Puo4nQYF.chunk.js:1:64250 at Object.Ak [as useState] (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:56:22457) at Ee.useState (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:9:6382) at https://192.168.25.175:5006/static/js/wide.Puo4nQYF.chunk.js:1:64237 at J1 (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:56:19539) at yv (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:58:3139) at bD (https://192.168.25.175:5006/static/js/index.O6ABAWXP.js:58:2351)
Where are you hosting Actual?
Docker
What browsers are you seeing the problem on?
Chrome
Operating System
Linux
@youngcw commented on GitHub (Mar 12, 2024):
in the short term you could try to find the value in the db file and fix it there.
@youngcw commented on GitHub (Mar 12, 2024):
how was this bad value imported?
@slimslickner commented on GitHub (Mar 19, 2024):
I recreated this same issue a while back. I got to this point by aggregating a split transaction with pandas from a Quicken export to then import to Actual.
Imported using CSV import in Actual.
@MatissJanis commented on GitHub (Mar 21, 2024):
👋 Would you mind providing an example file to reproduce the issue? Without a clear reproduction path it will be very difficult to assist in fixing this.
@MatissJanis commented on GitHub (Mar 23, 2024):
Actually.. this is a duplicate of https://github.com/actualbudget/actual/issues/1811. And since we have reproduction steps in 1811 - I'll close this one.