OpenERP Server Errors

imadsani · 02-17-2014, 08:45 AM

Hey,

The title say's it, constantly getting these errors. Need help on how to fix them.

OpenERP V.7
Server OS: CentOS 6.5 64-bit

I'm pasting the latest error dump below:

Code:

Client Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/controllers/main.py", line 1128, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/controllers/main.py", line 1120, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/osv.py", line 190, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/osv.py", line 132, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/osv.py", line 199, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/osv.py", line 187, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/account_followup/account_followup.py", line 120, in fields_view_get
    toolbar=toolbar, submenu=submenu)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/base/res/res_partner.py", line 314, in fields_view_get
    res['arch'] = self.fields_view_get_address(cr, user, res['arch'], context=context)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/base/res/res_partner.py", line 38, in fields_view_get_address
    fmt = user_obj.browse(cr, SUPERUSER_ID, uid, context).company_id.country_id
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 497, in __getattr__
    return self[name]
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 405, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 3621, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 3730, in _read_flat
    res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/fields.py", line 1142, in get
    result = self._fnct(obj, cr, uid, ids, name, self._arg, context)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/addons/base/res/res_company.py", line 84, in _get_address_data
    if company.partner_id:
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 497, in __getattr__
    return self[name]
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 405, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 3621, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/osv/orm.py", line 3673, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.6/site-packages/openerp-7.0_20140217_002618-py2.6.egg/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column res_company.timesheet_max_difference does not exist
LINE 1: ..._company."rml_header",res_company."security_lead",res_compan...

padeen · 02-17-2014, 08:59 PM

On the face of it, it looks like a necessary table in a database has not been set up correctly on the server, triggered by an RPC call from the client.

I was going to have a look at it, until I needed to provide personal details to download an evaluation copy. I stopped there. You might get some interest here to provide you with a reply, but I wouldn't rely on it.

Since you pay for this application, why not ask the company's support network?

imadsani · 02-17-2014, 10:33 PM

^ thanks for the input. Nope don't pay for it. Using the self hosted version.

padeen · 02-18-2014, 02:02 AM

From this, it suggests that you have installed a module incorrectly. Which module uses a field called something like "company timesheet difference"?

imadsani · 02-18-2014, 02:10 AM

^ i was able to deduce that as well, I tried running an older backup I had and the errors gone. I need to trace what happened to corrupt the table.
thanks man.

HunterCottage · 02-18-2014, 04:31 AM

I got similar errors like these when Postgres wasn't setup properly. In my case I didn't have the correct user. When I created the user 'openerp' as superuser things started working properly. I haven't used the system that much yet so there might be other things I am missing.