Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
datebank_statementrecursionEEv14
1 Odpowiedz
16281 Widoki
Awatar
rehan

hello guys, i want to know if there bugs by odoo in bank statement, so i want to import bank statement data with date 2021-01-31 (today date is 2021-09-08) but i get this error

RecursionError: maximum recursion depth exceeded while calling a Python object

when i check further log it said this error:
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_bank_statement.py", line 152, in _compute_ending_balance
    statement.balance_end_real = statement.previous_statement_id.balance_end_real + total_entry_encoding

even after i create a bank statement then change the date it will also show this error

anyone know what is it? thank you

Awatar
Odrzuć
Awatar
Alexandr
Najlepsza odpowiedź

Yes, there is a problem in algorithm. When you create a statement with date earlier than several existing statements, is required to recompute starting and ending balances of these statements. And here we gets the RecursionError if there is a large enough statements amount to recompute.

When i tried to import into Odoo a large amount of statements, i got the same issue. And the only workaround i found was to sort data before import for avoiding this recomputing.

In your case, seems, you can export statements, newer than one to create, to xlsx, delete them from the system, create your statement and then import exported statements back and reconcile them with payments again.
---

upd: Python recursion check is based on interpreter stack length, and when Odoo trying to recompute large statements amount, it just exceed this limit,  which  is 1000 by default. So you can try to increase  python recursion limit setting in your code using `sys.setrecursionlimit(some_limit_value)` that will be enough to perform all statements recomputing.

Awatar
Odrzuć
rehan
Autor

thanks for replying me.. but how can i delete it, when i delete it on the system it also throws the same error..

Alexandr

Records should be deleted from last to first. In this case there is nothing to recompute.
Also If you have a problem with RecursionError, it means you have a lot statements to delete. It will be better to do this from shell.

Or you can try to increase python recursion limit.

rehan
Autor

yes yes, yesterday i just delete the datas with sql query but still got the error and i think the second solution might solve the problem, is the thing that i need to do is import module sys from python and directly edit sys.setrecursionlimit from python file in models directory in module odoo?? did you have any reference? thanks..

Alexandr

To modify Odoo data with raw SQL request it is bad idea. You should use model methods to change model data.

To change interpreter stack limit you should in any your odoo module, in any python file (for example "__init__.py")) insert 2 strings:
```
from sys import setrecursionlimit
setrecursionlimit(some_value_more_than_1000)
```

rehan
Autor

alright, it works! but i want to know is there a consequence if we extend the limit of recursion in odoo? thanks a lot man, really appreciate it

Alexandr

If your new limit will be more than your system can handle, you can get C's StackOverflowException.

rehan
Autor

do you have any reference for me to calculate things between max limit recursion and my system capabilities?

Alexandr

I haven't, sorry.
I just can to recomend set this parameter at lowest value allowing to solve your problem. It should be far away from system limits.

rehan
Autor

it's okay.. thanks again anyway mate, i will pray for your success for helping me

Obay Abdelgadir

Someone I know encountered the same issue when closing pos session, with really big database (~60 GB). I think it is worth mentioning that if you increase the recursion limit, you must also increase the stack memory size, to avoid stackoverflow errors. see this https://stackoverflow.com/a/16248113/3557761

Powiązane posty Odpowiedzi Widoki Czynność
Timing Automatic Bank synchronizastion Rozwiązane
accounting bank_statement v14
Awatar
Awatar
1
lut 25
3527
customize date filter odoo 14
filter date v14
Awatar
Awatar
1
lip 22
4120
Where is the Odoo14 reconcile bank statement button? Rozwiązane
bank_statement reconcile v14
Awatar
Awatar
2
kwi 21
3199
How to change first day of the week Rozwiązane
date listview v14
Awatar
1
gru 20
8418
Where exactly is the date format filled from for a language? Rozwiązane
date odoo8.0 v14
Awatar
Awatar
1
mar 15
9707