This forum is now just an archive. Use the new Q&A website
It is currently Fri Apr 18, 2014 8:10 pm

All times are UTC + 2 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: OpenERP Server Error when opening most pages, OpenERP 6.1
PostPosted: Thu Mar 15, 2012 7:09 am 
Offline

Joined: Thu Mar 15, 2012 6:56 am
Posts: 4
Location: South Africa
Good day,

I'm receiving a non-critical, but annoying error.

When I open most pages, (accounts, customers, sales > scheduled calls etc.) the system intermittently throws an error. I've noticed, that during a session, once I start receiving the error, it comes up on almost every screen I open.

Interestingly, this does not impede or break any functionality, I can simply click OK then continue unhindered. Until I reopen that or almost any other screen, then the error prompts again.

Error as follows:

OpenERP Server Error

Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
response["result"] = method(controller, self, **self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 882, in get
return self.do_get(req, model, ids, fields)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 904, in do_get
records = Model.read(ids, fields, req.session.eval_context(req.context))
File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
args, kw)
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 611, in send
raise fault

Server Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 592, in send
result = openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 572, in dispatch
res = fn(db, uid, *params)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 167, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/addons/base/res/res_users.py", line 875, in read
res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
File "/usr/lib/pymodules/python2.7/openerp/addons/base/res/res_users.py", line 282, in read
result = super(users, self).read(cr, uid, ids, fields, context, load)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3381, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3434, in _read_flat
cr.execute(query, [tuple(sub_ids)] + rule_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)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...,res_users.id FROM "res_users" WHERE res_users.id IN (false)...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.


Top
 Profile  
 
 Post subject: Re: OpenERP Server Error when opening most pages, OpenERP 6.
PostPosted: Sat Mar 17, 2012 11:40 am 
Offline

Joined: Thu Mar 15, 2012 6:56 am
Posts: 4
Location: South Africa
So I installed the caldav and contacts modules form the standard "extra" module section, and upon doing so I get the following message when opening my leads/opportunities:
Client Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
response["result"] = method(controller, self, **self.params)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 882, in get
return self.do_get(req, model, ids, fields)
File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 904, in do_get
records = Model.read(ids, fields, req.session.eval_context(req.context))
File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
args, kw)
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 611, in send
raise fault


Server Traceback (most recent call last):
File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 592, in send
result = openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 572, in dispatch
res = fn(db, uid, *params)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 167, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3381, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3504, in _read_flat
res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
File "/usr/lib/pymodules/python2.7/openerp/osv/fields.py", line 488, in get
context=context))
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 2258, in name_get
[self._rec_name], context, load='_classic_write')]
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3381, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3440, 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: current transaction is aborted, commands ignored until end of transaction block

Is there something fundamentally wrong with my OpenERP installation?


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC + 2 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:

Protected by Anti-Spam ACP