Odoo 11 is not printing PDF report with 20.000 lines of issued invoices, but it does with 10.000

Question

Odoo v11 on my dev machine is not printing a custom pdf report with 20.000 lines of issued invoices.

I tested the printing with different amount of invoices from 1.000 to
10.000 lines with success. In fact, 10.000 lines of invoices takes
about 2-3 minutes to print.
Any of the subsequent tests from 11.000 to 20.000 lines of invoices
doesn't print (only appears the loading message for a long time, even
hours with no results).

Report has not images. Only has a table with lines, a header and
foot

faOtools · Answer

Hi,
it is not about increasing performance, but about finishing long processes.
Try to increase time-outs for Odoo operations. For example, add In the configuration file:
limit_time_real = 6000
Have a look at quite old, but in the most cases topical, explanations of conf params: https://www.vionblog.com/openerp-server-conf-for-openerp-7-explained/. Here are other limits which by default might block certain operations

Diego B. · Answer

Thanks a lot. I'm giving it a try, but for the moment is not working. May be, is needed to set another additional parameters?
Your answer makes a lot of sense, because 10.000 lines works and takes around 2 minutes for printing. I have the feeling that with higher number of lines takes more than 2 minutes and Odoo is blocked.

関連投稿	返信	ビュー
Where to specify the parameter of wkhtmltopdf in Odoo? wkhtmltopdf odoo	4 12月 19	16580
LC_CTYPE to default locale: No such file or directory ? 解決済 ubuntu wkhtmltopdf odoo	1 6月 25	6289
odoo.exceptions.UserError: Wkhtmltopdf failed (error code: -9). Message: b'' wkhtmltopdf odoo v14	2 2月 24	6832
Warning: "Unable to find Wkhtmltopdf on this system. The report will be shown in html." How do I resolve it? 解決済 wkhtmltopdf odoo 12.0	3 10月 21	19976
How do I go about this error? I am trying to uninstall a module odoo	0 11月 25	3360

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！