Accounting mailing list archives

accounting@odoo-community.org

Avatar

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

by
LasLabs, Dave Lasley
- 02/10/2016 20:46:44
Eliminating a variable - Are you able to generate the report in HTML?


-Dave Lasley

On Oct 2, 2016, at 17:53, Jean-Marc Dupont <jmd@6it.fr> 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

Reference