Odoo Help

Welcome!

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

1

Point Of Sale error when closing session.

pos
By
Faheem Khan
on 2/19/13, 8:47 PM 3,482 views

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

Max
on 3/6/13, 11:28 AM

I am facing exactly the same issue. OpenErp Assistance team is informed of it and I currently waits for their guidance.

AD LIBITOM, michel Guénard
on 3/7/13, 9:08 AM

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

AD LIBITOM, michel Guénard
on 3/22/13, 8:41 PM

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

sivhaga
on 12/11/13, 10:08 AM
0
sivhaga
On 12/10/13, 8:34 AM

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

0
test
On 4/1/13, 9:53 AM

Hello,

I had fixed it.

you can use my patch and apply it.

Download path:

http://snipt.org/zhgjj9/download

This will resolve your traceback.

Thanks,

If this will resolve your issue please mark this answer.

test
on 4/1/13, 9:53 AM

Can you describe what was causing the error and how you solved it? Would be great for understanding.

AD LIBITOM, michel Guénard
on 4/1/13, 2:21 PM

Have you tested this patch and does it works well ?

test
on 4/2/13, 11:14 AM

I am using the Saas V7 of the official offer from OperErp.com; no capacity to change anything!!!

AD LIBITOM, michel Guénard
on 4/2/13, 2:37 PM

Hello, you can give http://snipt.org/zhgjj9/download link to OpenERP.com and let them know your isssue, so they soon able to fix it soon. Its problem of openerp stable 7.0 version.

test
on 4/3/13, 3:58 AM

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

sivhaga
on 12/10/13, 8:36 AM
0

michel Guénard

--michel Guénard--
1033
| 5 5 8
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 4/3/13, 6:52 AM

2 questions on this forum are closely related to Pos session errors https://accounts.openerp.com/forum/Help-1/question/2364/ https://accounts.openerp.com/forum/Help-1/question/7755/

Charlie Jackson said he found a fix to the cause of the errors while validating sessions:

< Hello, you can give http://snipt.org/zhgjj9/download link to OpenERP.com and let them know your isssue, so they soon able to fix it soon. Its problem of openerp stable 7.0 version.>

Could OpenErp.com quickly validate the proposed fix and make the necessary changes to the system so that I (we) - as paying users - could make my instance work as it should do.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 2/19/13, 8:47 PM
Seen: 3482 times
Last updated: 3/16/15, 8:10 AM