search

buckets / application

Buckets Desktop Application
https://www.budgetwithbuckets.com
183 stars 2 forks source link

YNAB import: command 'db_all' failed: DbError datatype mismatch (20) #1013

Open iffy opened 1 month ago

iffy commented 1 month ago 
ERROR (rpclib) command 'db_all' failed: DbError datatype mismatch (20) msg={"c":"db_all","i":7453,"a":{"_db":1,"query":"\n      INSERT OR REPLACE INTO ynab_leftover_trans\n      (transaction_id, ynab_trans_json)\n      VALUES ($trans_id, $ynab_trans_json)","params":{"$trans_id":"c158f0f05305-c3f3351bb89a8ed1e6db","$ynab_trans_json":"{\"payeeId\":\"C5CFC2FB-ABEF-C23A-7E61-86BF9C11C2CA\",\"entityType\":\"transaction\",\"accountId\":\"856D8252-F6CC-A11A-426B-8681E1FD8B4D\",\"importedPayee\":\"SOMEPLACE\",\"matchedTransactions\":[],\"YNABID\":\"YNAB:3,500.00:2013-12-27:1\",\"cleared\":\"Reconciled\",\"amount\":3500,\"date\":\"2013-12-27\",\"accepted\":true,\"categoryId\":\"Category/__Split__\",\"subTransactions\":[{\"categoryId\":\"Category/__DeferredIncome__\",\"parentTransactionId\":\"Transaction/YNAB:3,500.00:2013-12-27:1\",\"memo\":\"Salary\",\"entityVersion\":\"A-556\",\"entityId\":\"DA0F8FFA-D434-3BAA-95D8-A1721467E5DF\",\"entityType\":\"subTransaction\",\"amount\":700},{\"categoryId\":\"Category/__DeferredIncome__\",\"parentTransactionId\":\"Transaction/YNAB:3,500.00:2013-12-27:1\",\"memo\":\"Dividend\",\"entityVersion\":\"A-558\",\"entityId\":\"AE82DD7C-90FA-0498-B818-A17214688EA2\",\"entityType\":\"subTransaction\",\"amount\":2800},{\"categoryId\":\"6D0412A4-0203-D470-E3DB-86BCAC97DA08\",\"parentTransactionId\":\"Transaction/YNAB:3,500.00:2013-12-27:1\",\"entityVersion\":\"A-560\",\"entityId\":\"A64D4FB8-C894-E693-3F48-A1721468EF81\",\"entityType\":\"subTransaction\",\"amount\":0},{\"categoryId\":\"7D13601B-0A91-2A40-419D-86BCDDD5E1EE\",\"parentTransactionId\":\"Transaction/YNAB:3,500.00:2013-12-27:1\",\"entityVersion\":\"A-562\",\"entityId\":\"CB3F5D77-B20A-85EE-D682-A17214684DBD\",\"entityType\":\"subTransaction\",\"amount\":0}],\"entityVersion\":\"A-738\",\"source\":\"Imported\",\"entityId\":\"Transaction/YNAB:3,500.00:2013-12-27:1\"}"}}}
[2024-07-14 19:59:24.588] [error] (m.core/ynab) Error: Unexpected error
    at BucketsBackendRPCWrap.<anonymous> (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:137:40)
    at step (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.rpcResultReceived (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:128:16)
    at BucketsBackendRPCWrap.<anonymous> (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:121:26)
    at step (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.handleSingleBackendMessage (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:113:16)
    at BucketsBackendRPCWrap.<anonymous> (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:106:56)
    at step (/Applications/Buckets.app/Contents/Resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
iffy commented 1 month ago

0.75.0-20241514-gwHSwDB