Accounting mailing list archives
accounting@odoo-community.org
Browse archives
Account.voucher in v9/v10
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)
by
LasLabs, Dave Lasley
Eliminating a variable - Are you able to generate the report in HTML?
-Dave Lasley
Hello everybody,We encounter a performance / timeout issue when generating general ledger reportFor 6 months : 8.000 invoices, 20.000 account moves et 100.000 account move linesAfter 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/web kit_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_sx w.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_finan cial_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_finan cial_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 generatedServer 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 advanceJean-Marc DUPONT
Agence Web, e-Commerce et Systèmes d'entreprise
68, rue du Refuge - 84200 Carpentras
_______________________________________________
Mailing-List: http://odoo-community.org/groups/accounting-28
Post to: mailto:accounting@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe
Reference
-
Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by6it, Jean-Marc Dupont-
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
byCarlos Liébana Anero. -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by6it, Jean-Marc Dupont -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
byCarlos Liébana Anero. -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by6it, Jean-Marc Dupont -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by6it, Jean-Marc Dupont -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
byCamptocamp France SAS, Alexandre Fayolle -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
byCamptocamp France SAS, Alexandre Fayolle -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by6it, Jean-Marc Dupont -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by6it, Jean-Marc Dupont -
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
byCarlos Liébana Anero.
-