1. Mailing Lists
  2. Accounting
  3. Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)

Accounting mailing list archives

accounting@odoo-community.org

Browse archives

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

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

Avatar

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

by
Camptocamp France SAS, Alexandre Fayolle
- 10/10/2016 11:06:09 
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

Reference