Transaction Import - Something went wrong. Please, try again.

[Canz2]

Hi,

When I tried to import my transaction I got this error :

But only if I send more than 1036 lines from the CSV, with 1035 it works fines but after that I always get the error even if I changed the data

I don't have any problem with step one, it's only with I validate the data to go to step two

[afaneca]

Hi @Canz2,
The issue might be related to the amount of data you're trying to import.
I'll try to replicate it and keep you updated on this thread.
Thanks for your report!

[afaneca]

Hi once again @Canz2,
Like I suspected, this is related to the sheer size of the payload you're trying to import. Will make changes in the API so that it can support larger payloads. You can track progress on that issue here: afaneca/myfin-api#141

[Canz2]

Hi, thx for the update.
I was thinking of that too but I was not sure.

I will look forward for the tracking of the issues
Thanks again

[vap0r1]

I had same issue, max seems about 100 before prisma timesout. I was able to do 250? by pumping timeout to 100000

[gswscreagle]

Hi once again @Canz2, Like I suspected, this is related to the sheer size of the payload you're trying to import. Will make changes in the API so that it can support larger payloads. You can track progress on that issue here: afaneca/myfin-api#141

I just got myfin setup a few days ago and I'm severely struggling with getting data into myfin via the import. 95% of the time it'll fail on the final adjustments part. the error I'm seeing in the api logs is below. and it doesn't seem to matter on how much data it is, it can be 50 rows, 20 rows...and only 3 columns.

PrismaClientKnownRequestError:

Invalid prisma.transactions.create() invocation:

Transaction API error: Transaction not found. Transaction ID is invalid, refers to an old closed transaction Prisma doesn't have information about anymore, or was obtained before disconnecting.

at ei.handleRequestError (/app/node_modules/@prisma/client/src/runtime/RequestHandler.ts:228:13)

at ei.handleAndLogRequestError (/app/node_modules/@prisma/client/src/runtime/RequestHandler.ts:174:12)

at ei.request (/app/node_modules/@prisma/client/src/runtime/RequestHandler.ts:143:12)

at async a (/app/node_modules/@prisma/client/src/runtime/getPrismaClient.ts:833:24)

at async <anonymous> (/app/src/services/transactionService.ts:254:22)

at async <anonymous> (/app/src/services/transactionService.ts:374:7)

at async Proxy._transactionWithCallback (/app/node_modules/@prisma/client/src/runtime/getPrismaClient.ts:722:18)

at async importTransactionsStep2 (/app/src/controllers/transactionController.ts:287:25) {

code: 'P2028',

�

{

modelName: 'transactions',

error: "Transaction not found. Transaction ID is invalid, refers to an old closed transaction Prisma doesn't have information about anymore, or was obtained before disconnecting."

},

clientVersion: '6.19.2'

}

code=P2028 meta={"modelName":"transactions","error":"Transaction not found. Transaction ID is invalid, refers to an old closed transaction Prisma doesn't have information about anymore, or was obtained before disconnecting."} clientVersion=6.19.2 name=PrismaClientKnownRequestError

[afaneca]

Hi @gswscreagle,
I haven't encountered that error before. Have you modified the source code in any way?