Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import: NotFound: account_transaction 0 - 20200112-Bj5yxq79 #502

Closed
iffy opened this issue Sep 4, 2020 · 6 comments
Closed

Import: NotFound: account_transaction 0 - 20200112-Bj5yxq79 #502

iffy opened this issue Sep 4, 2020 · 6 comments
Labels
bug Things that prevent or seriously impede people from doing their budget. can't reproduce included in next release The work is done, it's just waiting to be released.

Comments

@iffy
Copy link
Contributor

iffy commented Sep 4, 2020

Version: 0.55.3 (node: v10.2.0)
OS: darwin 19.2.0 x64
Lang: de Deutsch
Loc: buckets://c931d2b5-f299-4ba8-8ddd-44f951a3e9f4/budget/index.html#/y2020m1/import

[2020-01-12 20:13:38.379] [info] (csv) csv2importable 4606
[2020-01-12 20:13:38.391] [info] (csv) fingerprint xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
[2020-01-12 20:13:38.391] [info] (csv) Using existing mapping
[2020-01-12 20:13:38.392] [info] (csv) mapping { fields:
   { Betrag: 'amount',
     Name: 'memo',
     Verwendungszweck: 'fi_id',
     Wertstellung: 'posted' },
  noheader: false,
  posted_format: 'DD/MM/YYYY' }
[2020-01-12 20:13:38.393] [info] (csv) transactions 19
[2020-01-12 20:13:38.394] [info] (csv) csv_needs_account_assigned eeb1727e-2cfe-4761-89c6-9f4abcdb9660
[2020-01-12 20:13:42.084] [info] (csv) csv_account_response 2 undefined
[2020-01-12 20:13:43.762] [error] (files) Error importing file: /Users/SOMEUSER/Downloads/SOMEFILE.csv
[2020-01-12 20:13:43.763] [error] (files) NotFound: account_transaction 0
    at SQLiteStore.getObject (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-core/src/dbstore.ts:105:13)
@iffy iffy added the bug Things that prevent or seriously impede people from doing their budget. label Sep 4, 2020
@iffy
Copy link
Contributor Author

iffy commented Sep 4, 2020

Another report - 20200218-8cvNJcC8

Version: 0.55.3 (node: v10.2.0)
OS: win32 10.0.17763 x64
Lang: fr Français
Loc: buckets://40aaba6f-c460-4386-ba49-5c0af0bb8a5f/budget/index.html#/y2020m2/import

[2020-02-18 10:30:28.720] [info] (importing) Trying OFX/QFX parser
[2020-02-18 10:30:28.721] [info] (ofx) Parsing OFX data 7998
[2020-02-18 10:30:29.288] [error] (files) Error importing file: C:\Temp\Test\Buckets\SOMEFILE.ofx
[2020-02-18 10:30:29.295] [error] (files) NotFound: account 1
    at SQLiteStore.getObject (C:\Program Files\Buckets\resources\app.asar\node_modules\buckets-core\src\dbstore.ts:105:13)

@iffy
Copy link
Contributor Author

iffy commented Sep 4, 2020

Another report - 20200226-9Y7zVGQ4

Version: 0.55.3 (node: v10.2.0)
OS: darwin 19.3.0 x64
Lang: en English
Loc: buckets://aa6b7985-0724-4c62-a5fa-0b3c27181505/budget/index.html#/y2020m1/import

[2020-02-25 20:10:15.283] [info] (importing) data length: 37774
[2020-02-25 20:10:15.284] [info] (importing) Trying OFX/QFX parser
[2020-02-25 20:10:15.284] [info] (ofx) Parsing OFX data 37774
[2020-02-25 20:10:22.791] [error] (files) Error importing file: /Users/SOMEUSER/Downloads/ExportedTransactions.qfx
[2020-02-25 20:10:22.800] [error] (files) NotFound: account 5
    at SQLiteStore.getObject (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-core/src/dbstore.ts:105:13)

@iffy
Copy link
Contributor Author

iffy commented Sep 4, 2020

Another report - 20200710-k4w7Y6dq

Version: 0.55.3 (node: v10.2.0)
OS: win32 10.0.19041 x64
Lang: en English
Loc: buckets://8955bd93-f20e-48c3-8c3c-e1230c1258ca/budget/index.html#/y2020m7/import

[2020-07-10 12:42:09.290] [info] (csv) csv_needs_account_assigned 34198450-7a3d-43a5-a740-2eba33e3780a
[2020-07-10 12:42:12.388] [info] (csv) csv_account_response 6 undefined
[2020-07-10 12:42:19.143] [error] (files) Error importing file: Y:\SOMEDIR\SOMEUSER\Bank\2020\iks.csv
[2020-07-10 12:42:19.151] [error] (files) NotFound: account_transaction 0
    at SQLiteStore.getObject (C:\Program Files\Buckets\resources\app.asar\node_modules\buckets-core\src\dbstore.ts:105:13)

@iffy
Copy link
Contributor Author

iffy commented Nov 11, 2020

I've added better logging into the next version to hopefully catch the reason for this bug. I'm having a difficult time duplicating it.

@iffy iffy added the included in next release The work is done, it's just waiting to be released. label Jan 28, 2022
@iffy
Copy link
Contributor Author

iffy commented Feb 10, 2022

This is likely caused by importing some transactions, which involves mapping to accounts, deleting an account, then trying to reuse a mapping to import again. So it's trying to map to a no-longer-existing account.

@iffy
Copy link
Contributor Author

iffy commented Feb 17, 2022

Included in v0.65.0 release (AUTOMATED COMMENT)

@iffy iffy closed this as completed Feb 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Things that prevent or seriously impede people from doing their budget. can't reproduce included in next release The work is done, it's just waiting to be released.
Projects
None yet
Development

No branches or pull requests

1 participant