← Back to team overview

openerp-india team mailing list archive

  1. openerp-india team
  2. Mailing list archive
  3. Message #07063

[Bug 928169] Re: error when "printing invoce"

  Thread Previous • Date Previous • • Thread Next 
Hello

I've started new database from scratch and the problem is no-more (using
nightly builds with debian/testing).

Anyway, when reproducing the error from old database I've got this (it
starts with "database column missing")

2012-02-14 09:41:04,734 2764 ERROR ? openerp.sql_db: Programming error: ERROR:  column account_tax_code.sequence doesnt exist
LINE 1: ...",account_tax_code."code",account_tax_code."name",account_ta...
                                                             ^
, in query SELECT account_tax_code."info",account_tax_code."code",account_tax_code."name",account_tax_code."sequence",account_tax_code."company_id",account_tax_code."sign",account_tax_code."notprintable",account_tax_code."parent_id",account_tax_code.id FROM "account_tax_code" WHERE account_tax_code.id IN %s ORDER BY code
2012-02-14 09:41:04,735 2764 WARNING ? openerp.report.render.rml2pdf.utils: rml_except: " (t.tax_code_id and t.tax_code_id.notprintable) and removeParentNode('blockTable') or '' "
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/utils.py", line 92, in _child_get
    eval(n.get('rml_except'), {}, self.localcontext)
  File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 476, in __getattr__
    return self[name]
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 391, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3376, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3435, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
ProgrammingError: BŁĄD:  kolumna account_tax_code.sequence nie istnieje
LINE 1: ...",account_tax_code."code",account_tax_code."name",account_ta...
                                                             ^

2012-02-14 09:41:04,765 2764 ERROR ? openerp.sql_db: bad query: SELECT account_tax_code."info",account_tax_code."code",account_tax_code."name",account_tax_code."sequence",account_tax_code."company_id",account_tax_code."sign",account_tax_code."notprintable",account_tax_code."parent_id",account_tax_code.id FROM "account_tax_code" WHERE account_tax_code.id IN (3, 6) ORDER BY code
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

2012-02-14 09:41:04,766 2764 WARNING ? openerp.report.render.rml2pdf.utils: rml_except: " (t.tax_code_id and t.tax_code_id.notprintable) and removeParentNode('blockTable') or '' "
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/utils.py", line 92, in _child_get
    eval(n.get('rml_except'), {}, self.localcontext)
  File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 476, in __getattr__
    return self[name]
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 391, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3376, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3435, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

2012-02-14 09:41:04,806 2764 ERROR ? openerp.sql_db: bad query: SELECT "res_partner_address".id FROM "res_partner_address" WHERE ((res_partner_address."active" = 'True')  AND  (res_partner_address."partner_id" in (1,2))) ORDER BY type, name 
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

2012-02-14 09:41:04,809 2764 ERROR ? openerp.sql_db: bad query: SELECT "res_partner_address".id FROM "res_partner_address" WHERE ((res_partner_address."active" = 'True')  AND  (res_partner_address."partner_id" in (1,2))) ORDER BY type, name 
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

2012-02-14 09:41:04,812 2764 ERROR ? openerp.sql_db: bad query: SELECT "res_partner_address".id FROM "res_partner_address" WHERE ((res_partner_address."active" = 'True')  AND  (res_partner_address."partner_id" in (1,2))) ORDER BY type, name 
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

2012-02-14 09:41:04,813 2764 ERROR ? openerp.sql_db: bad query: SELECT value 
                       FROM ir_translation 
                       WHERE lang='pl_PL' 
                        AND type in ('report', 'rml') 
                        AND src='-' AND name='account.invoice'
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

2012-02-14 09:41:04,814 2764 ERROR ? openerp.service.web_services:
Exception: BŁĄD:  bieşąca transakcja została przerwana, polecenia
ignorowane do końca bloku transakcji

   handle_pageBegin args=()
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 710, in go
    (result, format) = obj.create(cr, uid, ids, datas, context)
  File "/usr/lib/pymodules/python2.7/openerp/report/report_sxw.py", line 437, in create
    fnct_ret = fnct(cr, uid, ids, data, report_xml, context)
  File "/usr/lib/pymodules/python2.7/openerp/report/report_sxw.py", line 471, in create_source_pdf
    result = self.create_single_pdf(cr, uid, [obj.id], data, report_xml, context)
  File "/usr/lib/pymodules/python2.7/openerp/report/report_sxw.py", line 528, in create_single_pdf
    pdf = create_doc(etree.tostring(processed_rml),rml_parser.localcontext,logo,title.encode('utf8'))
  File "/usr/lib/pymodules/python2.7/openerp/report/interface.py", line 192, in create_pdf
    obj.render()
  File "/usr/lib/pymodules/python2.7/openerp/report/render/render.py", line 59, in render
    self._result = self._render()
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml.py", line 41, in _render
    return rml2pdf.parseNode(self.rml, self.localcontext, images=self.bin_datas, path=self.path,title=self.title)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 985, in parseNode
    r.render(fp)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 310, in render
    pt_obj.render(el)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 969, in render
    self.doc_tmpl.build(fis)
  File "/usr/lib/python2.7/dist-packages/reportlab/platypus/doctemplate.py", line 877, in build
    self.clean_hanging()
  File "/usr/lib/python2.7/dist-packages/reportlab/platypus/doctemplate.py", line 510, in clean_hanging
    self.handle_flowable(self._hanging)
  File "/usr/lib/python2.7/dist-packages/reportlab/platypus/doctemplate.py", line 757, in handle_flowable
    f.apply(self)
  File "/usr/lib/python2.7/dist-packages/reportlab/platypus/doctemplate.py", line 140, in apply
    getattr(doc,arn)(*args)
  File "/usr/lib/python2.7/dist-packages/reportlab/platypus/doctemplate.py", line 535, in handle_pageBegin
    self.pageTemplate.onPage(self.canv,self)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 589, in render
    cnv.render(self.node)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 572, in render
    tags[n.tag](n)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 356, in _drawString
    text=self._textual(node, **v)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/trml2pdf.py", line 337, in _textual
    rc = utils._process_text(self, text)
  File "/usr/lib/pymodules/python2.7/openerp/report/render/rml2pdf/utils.py", line 132, in _process_text
    result += tools.ustr(self.localcontext.get('translate', lambda x:x)(to_translate))
  File "/usr/lib/pymodules/python2.7/openerp/report/report_sxw.py", line 336, in _translate
    translated_string = transl_obj._get_source(self.cr, self.uid, self.name, ('report', 'rml'), lang, source_string)
  File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 18, in lookup
    r = self.lookup(self2, cr, *args)
  File "/usr/lib/pymodules/python2.7/openerp/tools/cache.py", line 46, in lookup
    value = d[args] = self.method(self2, cr, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_translation.py", line 277, in _get_source
    cr.execute(query, params)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

   handle_pageBegin args=()
2012-02-14 09:41:05,638 2764 ERROR ? openerp.netsvc: BŁĄD:  bieşąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji

   handle_pageBegin args=()
(<class 'psycopg2.InternalError'>, InternalError('B\xc5\x81\xc4\x84D:  bie\xc5\xbc\xc4\x85ca transakcja zosta\xc5\x82a przerwana, polecenia ignorowane do ko\xc5\x84ca bloku transakcji\n\n   handle_pageBegin args=()',), <traceback object at 0x3f5a3f8>)
2012-02-14 09:41:05,638 2764 ERROR ? openerp.service.netrpc_server: netrpc: cannot deliver exception message to client
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/service/netrpc_server.py", line 71, in run
    valid_exception = Exception(netrpc_handle_exception_legacy(e))
  File "/usr/lib/pymodules/python2.7/openerp/service/netrpc_server.py", line 93, in netrpc_handle_exception_legacy
    return 'warning -- ' + e.name + '\n\n' + e.value
TypeError: coercing to Unicode: need string or buffer, tuple found

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/928169

Title:
  error when "printing invoce"

Status in OpenERP Server:
  Incomplete

Bug description:
  openerp_6.1dev-20120205-020001

  When clicking "print invoice" I see this. 
  (I'm able to print other reports without problem)

  Client Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 260, in dispatch
      r = method(controller, self, **self.params)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1634, in index
      req.session._db, req.session._uid, req.session._password, report_id)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 594, in send
      fault = xmlrpclib.Fault('warning -- ' + e.name + '\n\n' + e.value, '')
  TypeError: coercing to Unicode: need string or buffer, tuple found

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/928169/+subscriptions

References

  Thread Previous • Date Previous • • Thread Next