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.

İlgili Gönderiler	Cevaplar	Görünümler
Where to specify the parameter of wkhtmltopdf in Odoo? wkhtmltopdf odoo	4 Ara 19	16854
LC_CTYPE to default locale: No such file or directory ? Çözüldü ubuntu wkhtmltopdf odoo	1 Haz 25	6462
odoo.exceptions.UserError: Wkhtmltopdf failed (error code: -9). Message: b'' wkhtmltopdf odoo v14	2 Şub 24	7014
Warning: "Unable to find Wkhtmltopdf on this system. The report will be shown in html." How do I resolve it? Çözüldü wkhtmltopdf odoo 12.0	3 Eki 21	20232
How Odoo Help Businesses?? odoo	0 Ara 25	167

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!