Accounting mailing list archives

accounting@odoo-community.org

Avatar

Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)

by
6it, Jean-Marc Dupont
- 10/10/2016 15:02:07
Yes, but we also have the error 

Sometimes, the Excel version succeeds and the PDF version fails, depending on number of months asked, but they both failed with 8 months or more as time filter
They both succeed with 6 months or less


Odoo support (Denis Ledoux) suggested me to modify the view, by cutting the HTML table into parts of 500 lines


That's what they did on the official report_generalledger view




2016-10-10 11:22 GMT+02:00 Alexandre Fayolle <alexandre.fayolle@camptocamp.com>:
Did you try generating the GL as a spreadsheet?

Alexandre

On 02/10/2016 17:53, Jean-Marc Dupont wrote:
> Hello everybody,
> 
> We encounter a performance / timeout issue when generating general
> ledger report 
> For 6 months : 8.000 invoices, 20.000 account moves et 100.000 account
> move lines
> After 5 to 10 minutes, there is an error :
> 
> 2016-09-30 13:27:11,872 25522 ERROR o80_odoo openerp.service.report:
> Exception: ('Webkit error', "The command 'wkhtmltopdf' failed with      
>                            error code = -9. Message: No diagnosis
> message was provided")
> Traceback (most recent call last):
>   File "/home/it-traceurdirect/aoe-80/base/openerp/service/report.py",
> line 93, in go
>     result, format = openerp.report.render_report(cr, uid, ids, object,
> datas, context)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/report/__init__.py",
> line 40, in render_report
>     return registry['ir.actions.report.xml'].render_report(cr, uid, ids,
> name, data, context)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/api.py", line 268, in
> wrapper
>     return old_api(self, *args, **kwargs)
>   File
> "/home/it-traceurdirect/aoe-80/base/openerp/addons/base/ir/ir_actions.py",
> line 156, in render_report
>     return new_report.create(cr, uid, res_ids, data, context)
>   File
> "/home/it-traceurdirect/aoe-80/base/addons/report_webkit/webkit_report.py",
> line 377, in create
>     result = self.create_source_pdf(cursor, uid, ids, data, report_xml,
> context)
>   File
> "/home/it-traceurdirect/aoe-80/base/openerp/report/report_sxw.py", line
> 462, in create_source_pdf
>     return self.create_single_pdf(cr, uid, ids, data, report_xml, context)
>   File
> "/home/it-traceurdirect/aoe-80/addons-partners/account_financial_report_webkit/report/webkit_parser_header_fix.py",
> line 277, in create_single_pdf
>     parser_instance=parser_instance)
>   File
> "/home/it-traceurdirect/aoe-80/addons-partners/account_financial_report_webkit/report/webkit_parser_header_fix.py",
> line 169, in generate_pdf
>     (status, error_message))
> except_orm: ('Webkit error', "The command 'wkhtmltopdf' failed with    
>                              error code = -9. Message: No diagnosis
> message was provided")
> 2016-09-30 13:27:12,023 25522 ERROR o80_odoo
> openerp.addons.web.controllers.main: An exception occured during an http
> request
> Traceback (most recent call last):
>   File
> "/home/it-traceurdirect/aoe-80/base/addons/web/controllers/main.py",
> line 70, in wrap
>     return f(*args, **kwargs)
>   File
> "/home/it-traceurdirect/aoe-80/base/addons/web/controllers/main.py",
> line 1575, in index
>     request.session.db, request.session.uid, request.session.password,
> report_id)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/http.py", line 881,
> in proxy_method
>     result = dispatch_rpc(self.service_name, method, args)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/http.py", line 115,
> in dispatch_rpc
>     result = dispatch(method, params)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/service/report.py",
> line 34, in dispatch
>     res = fn(db, uid, *params)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/service/report.py",
> line 141, in exp_report_get
>     return _check_report(report_id)
>   File "/home/it-traceurdirect/aoe-80/base/openerp/service/report.py",
> line 119, in _check_report
>     raise openerp.osv.orm.except_orm(exc.message, exc.traceback)
> except_orm: (u'Webkit error', u"The command 'wkhtmltopdf' failed with  
>                                error code = -9. Message: No diagnosis
> message was provided")
> 
> 
> HTML file is generated in /tmp directory, and wkhtmltopdf process is
> running on the server after we accept error message in Odoo, but it's
> too late, no PDF file is generated
> 
> Server parameters :: 
> 
> limit_memory_hard = 2684354560
> 
> limit_memory_soft = 2147483648
> 
> limit_request = 8192
> 
> limit_time_cpu = 1200
> 
> limit_time_real = 2700
> 
> 
> Can anybody help us ?
> 
> Thanks in advance
> 
> 
> *
> *
> 
> *Jean-Marc DUPONT *
> 
> *Agence Web, e-Commerce et Systèmes d'entreprise *
> 
> 68, rue du Refuge - 84200 Carpentras
> 
> T. 06.24.91.02.03  -  04 84 25 17 94
> 
> Éditeur de la marque *Provenc.io *
> 
> 1° marque e-Commerce 100% Provence
> 
> 
> 
> 
> _______________________________________________
> Mailing-List: http://odoo-community.org/groups/accounting-28
> Post to: mailto:accounting@odoo-community.org
> Unsubscribe: http://odoo-community.org/groups?unsubscribe
> 


-- 
Alexandre Fayolle
Chef de Projet
Tel : +33 4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com

_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


Reference