[6.0] Error in sales order

[Eric Caudal - www.elico-corp.com]

entering a line in sales order (new fresh demo database):

Unrecoverable error in the server. Traceback (most recent call last): File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 541, in run self.respond(pi) File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 624, in respond self.handle_error() File "/usr/local/lib/python2.6/dist-packages/CherryPy-3.1.2-py2.6.egg/cherrypy/_cprequest.py", line 746, in handle_error self.error_response() File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/controllers/root.py", line 39, in _cp_on_error message = errorpage.render() File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/controllers/error_page.py", line 55, in render return self.__render(value) File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/openobject/tools/_expose.py", line 202, in func_wrapper res = func(*args, **kw) File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/controllers/error_page.py", line 75, in __render maintenance = proxy.status() File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/utils/rpc.py", line 394, in return lambda *args: self._session.execute("object", "execute", self._resource, name, *args) File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/utils/rpc.py", line 355, in execute return self.gateway.execute(obj, method, *args) File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/utils/rpc.py", line 153, in execute return self.__execute(obj, method, args) File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/utils/rpc.py", line 135, in __execute raise common.warning(err.data) File "/usr/local/lib/python2.6/dist-packages/openerp_web-6.0devdev_20100830-py2.6.egg/openerp-web/addons/openerp/utils/common.py", line 75, in warning raise TinyWarning(message=msg, title=title or _("Warning")) TinyWarning: You can not read this document! (maintenance.contract)

It seems strange that by default, maintenance.contract object is unreadable

[Eric Caudal - www.elico-corp.com (elicoidal)]

I created the object maintenance.contract in the security list, read only by employees.
Final error about sales order is :

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/netsvc.py", line 431, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/service/web_services.py", line 589, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/osv.py", line 57, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/osv.py", line 135, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/osv.py", line 125, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/addons/sale/sale.py", line 391, in create
    return super(sale_order, self).create(cr, uid, vals, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/orm.py", line 3563, in create
    self.pool.get(object)._store_set_values(cr, user, ids, fields2, context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/osv/orm.py", line 3685, in _store_set_values
    '"'+f+'"='+self._columns[f]._symbol_set[0] + ' where id = %s', (self._columns[f]._symbol_set[1](value),id))
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/sql_db.py", line 74, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server_9920/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hi Eric,

I didn't face such an error while performing the same steps said by you.

Please try again and share the scenario.

Thanks.

[Eric Caudal - www.elico-corp.com (elicoidal)]

I restarted a fresh database and seems not to see the error again.
For me, you can close the bug.

Eric

[Jay Vora (Serpent Consulting Services) (jayvora)]

Thanks Eric and Nhomar.

[Mihai Satmarean (mihai-satmarean)]

First, without any intervention in the code,
I get the bug with "please correct red fields" when: merging purchase orders, and creating invoices from the sales order, or lines to invoice.

I have restarted the openerp server, and when I go in sales order, double click one line and press "Make invoice"
I get this:
Environment Information :
System : Linux-2.6.38-020638rc6-generic-i686-with-LinuxMint-10-julia
OS Name : posix
Distributor ID: LinuxMint
Description: Linux Mint 10 Julia
Release: 10
Codename: julia
Operating System Release : 2.6.38-020638rc6-generic
Operating System Version : #201102220910 SMP Tue Feb 22 10:23:10 UTC 2011
Operating System Architecture : 32bit
Operating System Locale : ro_RO.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 6.0.2
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/lib/openerp-server-6.0.1/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/lib/openerp-server-6.0.1/service/web_services.py", line 599, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/openerp-server-6.0.1/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/openerp-server-6.0.1/osv/orm.py", line 2921, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/openerp-server-6.0.1/osv/orm.py", line 3041, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/usr/lib/openerp-server-6.0.1/osv/fields.py", line 362, in get
    context=context))
  File "/usr/lib/openerp-server-6.0.1/addons/stock/stock.py", line 82, in name_get
    reads = self.read(cr, uid, ids, ['name','location_id'], context=context)
  File "/usr/lib/openerp-server-6.0.1/osv/orm.py", line 2921, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/openerp-server-6.0.1/osv/orm.py", line 2980, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/usr/lib/openerp-server-6.0.1/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/openerp-server-6.0.1/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

[Mihai Satmarean (mihai-satmarean)]

SORRY
MY bad,

I was freaking out,

but I did add a field to one report, which was not in the database,

after adding the field in the database, error is gone.

Thanks,