I am facing an issue. When I close a pos session that have no any sale its okay. But when a session have some sales it did not validate and popup this error.
OpenERP Server Error Client Traceback (most recent call last): File "/opt/openerp/web/addons/web/http.py", line 195, in dispatch response["result"] = method(self, **self.params) File "/opt/openerp/web/addons/web/controllers/main.py", line 1089, in exec_workflow return req.session.exec_workflow(model, id, signal) File "/opt/openerp/web/addons/web/session.py", line 148, in exec_workflow r = self.proxy('object').exec_workflow(self._db, self._uid, self._password, model, signal, id) File "/opt/openerp/web/addons/web/session.py", line 31, in proxy_method result = self.session.send(self.service_name, method, *args) File "/opt/openerp/web/addons/web/session.py", line 104, in send raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)
Server Traceback (most recent call last): File "/opt/openerp/web/addons/web/session.py", line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/server/openerp/netsvc.py", line 289, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/server/openerp/service/web_services.py", line 614, in dispatch res = fn(db, uid, params) File "/opt/openerp/server/openerp/osv/osv.py", line 123, in wrapper return f(self, dbname, *args, *kwargs) File "/opt/openerp/server/openerp/osv/osv.py", line 202, in exec_workflow res = self.exec_workflow_cr(cr, uid, obj, signal, args) File "/opt/openerp/server/openerp/osv/osv.py", line 195, in exec_workflow_cr return object._workflow_signal(cr, uid, [res_id], signal)[res_id] File "/opt/openerp/server/openerp/osv/orm.py", line 3928, in _workflow_signal result[res_id] = wf_service.trg_validate(uid, self._name, res_id, signal, cr) File "/opt/openerp/server/openerp/workflow/wkf_service.py", line 119, in trg_validate res2 = instance.validate(cr, id, ident, signal) File "/opt/openerp/server/openerp/workflow/instance.py", line 43, in validate workitem.process(cr, witem, ident, signal, force_running, stack=stack)
File "/opt/openerp/server/openerp/workflow/workitem.py", line 60, in process ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 175, in _split_test _join_test(cr, t[0], t[1], ident, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 183, in _join_test create(cr,[activity], inst_id, ident, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 40, in create process(cr, res, ident, stack=stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 60, in process ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 175, in _split_test _join_test(cr, t[0], t[1], ident, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 183, in _join_test create(cr,[activity], inst_id, ident, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 40, in create process(cr, res, ident, stack=stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 52, in process result = _execute(cr, workitem, activity, ident, stack) File "/opt/openerp/server/openerp/workflow/workitem.py", line 106, in _execute returned_action = wkf_expr.execute(cr, ident, workitem, activity) File "/opt/openerp/server/openerp/workflow/wkf_expr.py", line 67, in execute return _eval_expr(cr, ident, workitem, activity['action']) File "/opt/openerp/server/openerp/workflow/wkf_expr.py", line 57, in _eval_expr ret = eval(line, env, nocopy=True) File "/opt/openerp/server/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 "/opt/openerp/server/openerp/osv/orm.py", line 374, in function_proxy return attr(self._cr, self._uid, [self._id], *args, *kwargs) File "/opt/openerp/addons/point_of_sale/point_of_sale.py", line 433, in wkf_action_close self._confirm_orders(cr, uid, ids, context=context) File "/opt/openerp/addons/point_of_sale/point_of_sale.py", line 452, in _confirm_orders self.pool.get('pos.order')._create_account_move_line(cr, uid, order_ids, session, move_id, context=context) File "/opt/openerp/addons/point_of_sale/point_of_sale.py", line 1077, in _create_account_move_line account_move_line_obj.create(cr, uid, value, context=context) File "/opt/openerp/addons/account/account_move_line.py", line 1143, in create if ('account_id' in vals) and not account_obj.read(cr, uid, vals['account_id'], ['active'])['active']: File "/opt/openerp/server/openerp/osv/orm.py", line 3606, in read result = self._read_flat(cr, user, select, fields, context, load) File "/opt/openerp/server/openerp/osv/orm.py", line 3658, in _read_flat cr.execute(query, [tuple(sub_ids)] + rule_params) File "/opt/openerp/server/openerp/sql_db.py", line 162, in wrapper return f(self, args, *kwargs) File "/opt/openerp/server/openerp/sql_db.py", line 227, in execute res = self._obj.execute(query, params) ProgrammingError: operator does not exist: integer = boolean LINE 1: ...d FROM "account_account" WHERE account_account.id IN (false)... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
When I make a new data base with some xyz products this error gone. My database have upto 3000 products and it is too dificult to make new database. Please provide some help to solve this issue.
Hi, this looks like a bug. You will have more luck with bugs if you register them on launchpad here
I am facing exactly the same issue. OpenErp Assistance team is informed of it and I currently waits for their guidance.
here is the message received from the openerp assistance on march 13: "I tested with the latest 7 and this should have been solved. Could you confirm please? " So far I have not tested the "latest 7" (not a very precise information). Apparently this issue is solved
The fix doesnt seem to work, unless if there is something we are missing but please this is what i did:
1.Edited 'account/account_move_line.py' and changed lines 1060 and 1145 with: if vals.get('account_id',False) and not account_obj.read(cr, uid, vals['account_id'], ['active'])['active']: 2.After editing the .py file, we restarted the Openerp server. 3.We logged out of the database - we logged back in 4.We went to Settings and we Upgraded the Accounts Module. 5.Then tested the program
The error still occours, please assist