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	15236
LC_CTYPE to default locale: No such file or directory ? 해결 완료 ubuntu wkhtmltopdf odoo	1 6월 25	5662
odoo.exceptions.UserError: Wkhtmltopdf failed (error code: -9). Message: b'' wkhtmltopdf odoo v14	2 2월 24	6048
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	19006
How to import product variants with my own external id when using dynamic creation mode 해결 완료 odoo	2 8월 25	2788

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!