Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

1

Is there a setting that would cause this error?

By
Jeff Beidler
on 2/5/15, 4:23 PM 986 views

I am unable to print the picking report for a delivery order.  I get the following error:

Traceback (most recent call last): File "/home/openerp/odoo-8.0-20150128/openerp/addons/report/controllers/main.py", line 121, in report_download response = self.report_routes(reportname, docids=docids, converter='pdf') File "/home/openerp/odoo-8.0-20150128/openerp/http.py", line 396, in response_wrap response = f(*args, **kw) File "/home/openerp/odoo-8.0-20150128/openerp/addons/report/controllers/main.py", line 65, in report_routes pdf = report_obj.get_pdf(cr, uid, docids, reportname, data=options_data, context=context) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/report/models/report.py", line 186, in get_pdf html = self.get_html(cr, uid, ids, report_name, data=data, context=context) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/report/models/report.py", line 171, in get_html return self.render(cr, uid, [], report.report_name, docargs, context=context) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/report/models/report.py", line 147, in render return view_obj.render(cr, uid, template, values, context=context) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/website/models/ir_ui_view.py", line 172, in render return super(view, self).render(cr, uid, id_or_xml_id, values=values, engine=engine, context=context) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_ui_view.py", line 1014, in render return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 253, in render return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 294, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 292, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 426, in render_tag_call d[0] = self.render_element(element, template_attributes, generated_attributes, d) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 292, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 416, in render_tag_foreach ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 292, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 435, in render_tag_call return self.render(cr, uid, template, d) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 253, in render return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 294, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 292, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 435, in render_tag_call return self.render(cr, uid, template, d) File "/home/openerp/odoo-8.0-20150128/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 253, in render return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 294, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 294, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 294, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 294, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 320, in render_element raise_qweb_exception(message="Could not render element %r" % element.tag, node=element, template=template) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 315, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 292, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/openerp/odoo-8.0-20150128/openerp/addons/base/ir/ir_qweb.py", line 473, in render_tag_field field = record._fields[field_name] QWebException: 'date_order'

I have already tried creating a new database, and I am able to print from there.  So, I tried running a "-u all -d dbname" from the command line, but I still get the above error.  I haven't seen any settings that look like they might be causing the error, and I'm unable to find the string "date_order" in the Qweb report XML file, so I don't know what's causing it.  Any ideas?

Anybody got any ideas? The only place I have found "date_order" is in the sales order view, which shouldn't have any bearing on the stock picking report, as far as I can tell.

Jeff Beidler
on 2/6/15, 2:24 PM

"date_order" I found in modules: sale, point_of_sale, sale_order_dates, sale_stock,purchase, portal_sale, purchase_requisition,

zbik
on 2/6/15, 2:43 PM

PS. You enable debug_sql and see, in log, searched report name (in sql query) at error moment

zbik
on 2/6/15, 3:27 PM

I know the field "date_order" exists in other modules, but if it isn't in the picking report template, how does it cause an error? I'll try your suggestion about debug_sql -- how do you enable that? Do you mean the "--debug" flag when starting the server from the command line?

Jeff Beidler
on 2/6/15, 4:16 PM

I found the "--log-level='debug_sql'" option, but it didn't tell me anything when the error happened. :(

Jeff Beidler
on 2/6/15, 5:10 PM

log_level = debug_sql in openerp-server.conf

zbik
on 2/6/15, 5:11 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 2/5/15, 4:23 PM
Seen: 986 times
Last updated: 3/16/15, 8:10 AM