Odoo Help


Server Error In Open Erp

on 12/2/13, 7:32 AM 2,913 views

i have created my new module in open erp using web interface i have create it is showing perfectly but when click on save button it show me error ERROR "Open ERP Server Error"

OpenERP Server Error
    Client Traceback (most recent call last):
 File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\http.py", line 204, in  
         response["result"] = method(self, **self.params)
     File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\controllers\main.py", 
       line          1128, in call_kw
 return self._call_kw(req, model, method, args, kwargs)
    File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\controllers\main.py", line    
       1120, in _call_kw
     return getattr(req.session.model(model), method)(*args, **kwargs)
    File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 42, in 
result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
     File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 30, in 
result = self.session.send(self.service_name, method, *args)
      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 103, in 
     raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
       Server Traceback (most recent call last):
      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\addons\web\session.py", line 89, in 
return openerp.netsvc.dispatch_rpc(service_name, method, args)

      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\netsvc.py", line 292, in dispatch_rpc

     result = ExportService.getService(service_name).dispatch(method, params)
       File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\service\web_services.py", line 626, in  
       res = fn(db, uid, *params)
   File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 188, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
 File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 131, in wrapper
return f(self, dbname, *args, **kwargs)
     File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 197, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\osv.py", line 185, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\osv\orm.py", line 4434, in create
cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
      File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\sql_db.py", line 161, in wrapper
return f(self, *args, **kwargs)
       File "C:\Users\ANGEL\workspace\openerp-7.0-20130715-231029\openerp\sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
    ProgrammingError: column "x_number" of relation "x_test" does not exist
     L INE 1: insert into "x_test" (id,"x_number","x_name","x_products",cr...

Can you paste the full error log ? or the code?

on 12/2/13, 7:47 AM

please see my update question @pravitha

on 12/2/13, 8:07 AM

have you upgraded the module from the interface?

on 12/2/13, 8:17 AM

If you creating physical module or new addons then please do not use x_field name, x_ use for live field addition, just give proper field names.

then reload and upgrade module then try to test again.

on 12/2/13, 10:59 AM

do not use x_[fieldname],

on 12/2/13, 11:03 AM

i have created the field name with x and field label without x . but when i create a field name without x so it gives me error and does not save

on 12/3/13, 4:39 AM
On 12/2/13, 8:24 AM

The following Server error means you field is not existing. You must upgrade the module in openerp installed modules from the interface. Also i have found something as follows:


Check if the given name is a valid openerp object name.

The _name attribute in osv and osv_memory object is subject to some restrictions. This function returns True or False whether the given name is allowed or not.

TODO: this is an approximation. The goal in this approximation is to disallow uppercase characters (in some places, we quote table/column names and in other not, which leads to this kind of errors:

psycopg2.ProgrammingError: relation "xxx" does not exist).

The same restriction should apply to both osv and osv_memory objects for consistency

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 12/2/13, 7:32 AM
Seen: 2913 times
Last updated: 3/16/15, 8:10 AM