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)
Re: Performance / Error / timeout ? issue in general ledger report (module account_financial_report_webkit)
by
6it, Jean-Marc Dupont
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.p y", > line 93, in go > result, format = openerp.report.render_report(c r, 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.xm l'].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/i r_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/webk it_parser_header_fix.py", > line 277, in create_single_pdf > parser_instance=parser_instanc e) > File > "/home/it-traceurdirect/aoe-80 /addons-partners/account_finan cial_report_webkit/report/webk it_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/m ain.py", > line 70, in wrap > return f(*args, **kwargs) > File > "/home/it-traceurdirect/aoe-80 /base/addons/web/controllers/m ain.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.p y", > line 34, in dispatch > res = fn(db, uid, *params) > File "/home/it-traceurdirect/aoe-80 /base/openerp/service/report.p y", > line 141, in exp_report_get > return _check_report(report_id) > File "/home/it-traceurdirect/aoe-80 /base/openerp/service/report.p y", > 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/grou ps/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
-
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.
-