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.

Related Posts	Replies	Views
Where to specify the parameter of wkhtmltopdf in Odoo? wkhtmltopdf odoo	4 दिस॰ 19	16780
LC_CTYPE to default locale: No such file or directory ? Solved ubuntu wkhtmltopdf odoo	1 जून 25	6400
odoo.exceptions.UserError: Wkhtmltopdf failed (error code: -9). Message: b'' wkhtmltopdf odoo v14	2 फ़र॰ 24	6962
Warning: "Unable to find Wkhtmltopdf on this system. The report will be shown in html." How do I resolve it? Solved wkhtmltopdf odoo 12.0	3 अक्तू॰ 21	20153
SOC 1 Report odoo	2 नव॰ 25	353

This question has been flagged

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