c2c-oerpscenario team mailing list archive

Thread
Date
[Bug 885663] [NEW] Crash when confirming a payslip

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: "Antoine\(OpenERP\)" <885663@xxxxxxxxxxxxxxxxxx>
Date: Thu, 03 Nov 2011 13:08:12 -0000
Reply-to: Bug 885663 <885663@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

OpenERP Server Error
Client Traceback (most recent call last):
  File "/home/openerp/source/web/trunk/addons/web/common/http.py", line 154, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/home/openerp/source/web/trunk/addons/web/controllers/main.py", line 731, in exec_workflow
    r = req.session.exec_workflow(model, id, signal)
  File "/home/openerp/source/web/trunk/addons/web/common/session.py", line 82, in exec_workflow
    r = self.proxy('object').exec_workflow(self._db, self._uid, self._password, model, signal, id)
  File "/home/openerp/source/web/trunk/addons/web/common/openerplib/main.py", line 294, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/home/openerp/source/web/trunk/addons/web/common/openerplib/main.py", line 264, in send
    raise fault


Server Traceback (most recent call last):
  File "/home/openerp/source/web/trunk/addons/web/common/openerplib/main.py", line 245, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/openerp/source/server/trunk/openerp/netsvc.py", line 325, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/openerp/source/server/trunk/openerp/service/web_services.py", line 580, in dispatch
    res = fn(db, uid, *params)
  File "/home/openerp/source/server/trunk/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/openerp/source/server/trunk/openerp/osv/osv.py", line 192, in exec_workflow
    res = self.exec_workflow_cr(cr, uid, obj, method, *args)
  File "/home/openerp/source/server/trunk/openerp/osv/osv.py", line 185, in exec_workflow_cr
    return wf_service.trg_validate(uid, obj, args[0], method, cr)
  File "/home/openerp/source/server/trunk/openerp/workflow/wkf_service.py", line 124, in trg_validate
    res2 = instance.validate(cr, id, ident, signal)
  File "/home/openerp/source/server/trunk/openerp/workflow/instance.py", line 48, in validate
    workitem.process(cr, witem, ident, signal, force_running, stack=stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 174, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 182, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 174, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 182, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 53, in process
    result = _execute(cr, workitem, activity, ident, stack)
  File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 107, in _execute
    wkf_expr.execute(cr, ident, workitem, activity)
  File "/home/openerp/source/server/trunk/openerp/workflow/wkf_expr.py", line 68, in execute
    return _eval_expr(cr, ident, workitem, activity['action'])
  File "/home/openerp/source/server/trunk/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
    ret = eval(line, env, nocopy=True)
  File "/home/openerp/source/server/trunk/openerp/tools/safe_eval.py", line 286, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 372, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/home/openerp/source/addons/trunk-edi-review-hmo/hr_payroll_account/hr_payroll_account.py", line 157, in process_sheet
    move_id = move_pool.create(cr, uid, move, context=context)
  File "/home/openerp/source/addons/trunk-edi-review-hmo/account/account.py", line 1361, in create
    result = super(account_move, self).create(cr, uid, vals, c)
  File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 4067, in create
    result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
  File "/home/openerp/source/server/trunk/openerp/osv/fields.py", line 482, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/home/openerp/source/addons/trunk-edi-review-hmo/account/account_move_line.py", line 1236, in create
    if ('account_id' in vals) and not account_obj.read(cr, uid, vals['account_id'], ['active'])['active']:
  File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 3272, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 3331, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/home/openerp/source/server/trunk/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/source/server/trunk/openerp/sql_db.py", line 215, 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.

** Affects: openerp-web
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/885663

Title:
  Crash when confirming a payslip

Status in OpenERP Web:
  New

Bug description:
  OpenERP Server Error
  Client Traceback (most recent call last):
    File "/home/openerp/source/web/trunk/addons/web/common/http.py", line 154, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/home/openerp/source/web/trunk/addons/web/controllers/main.py", line 731, in exec_workflow
      r = req.session.exec_workflow(model, id, signal)
    File "/home/openerp/source/web/trunk/addons/web/common/session.py", line 82, in exec_workflow
      r = self.proxy('object').exec_workflow(self._db, self._uid, self._password, model, signal, id)
    File "/home/openerp/source/web/trunk/addons/web/common/openerplib/main.py", line 294, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/home/openerp/source/web/trunk/addons/web/common/openerplib/main.py", line 264, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/home/openerp/source/web/trunk/addons/web/common/openerplib/main.py", line 245, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/openerp/source/server/trunk/openerp/netsvc.py", line 325, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/openerp/source/server/trunk/openerp/service/web_services.py", line 580, in dispatch
      res = fn(db, uid, *params)
    File "/home/openerp/source/server/trunk/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/openerp/source/server/trunk/openerp/osv/osv.py", line 192, in exec_workflow
      res = self.exec_workflow_cr(cr, uid, obj, method, *args)
    File "/home/openerp/source/server/trunk/openerp/osv/osv.py", line 185, in exec_workflow_cr
      return wf_service.trg_validate(uid, obj, args[0], method, cr)
    File "/home/openerp/source/server/trunk/openerp/workflow/wkf_service.py", line 124, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/home/openerp/source/server/trunk/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 174, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 182, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 174, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 182, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/home/openerp/source/server/trunk/openerp/workflow/workitem.py", line 107, in _execute
      wkf_expr.execute(cr, ident, workitem, activity)
    File "/home/openerp/source/server/trunk/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/home/openerp/source/server/trunk/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/home/openerp/source/server/trunk/openerp/tools/safe_eval.py", line 286, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 372, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/home/openerp/source/addons/trunk-edi-review-hmo/hr_payroll_account/hr_payroll_account.py", line 157, in process_sheet
      move_id = move_pool.create(cr, uid, move, context=context)
    File "/home/openerp/source/addons/trunk-edi-review-hmo/account/account.py", line 1361, in create
      result = super(account_move, self).create(cr, uid, vals, c)
    File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 4067, in create
      result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
    File "/home/openerp/source/server/trunk/openerp/osv/fields.py", line 482, in set
      id_new = obj.create(cr, user, act[2], context=context)
    File "/home/openerp/source/addons/trunk-edi-review-hmo/account/account_move_line.py", line 1236, in create
      if ('account_id' in vals) and not account_obj.read(cr, uid, vals['account_id'], ['active'])['active']:
    File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 3272, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/openerp/source/server/trunk/openerp/osv/orm.py", line 3331, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/home/openerp/source/server/trunk/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/openerp/source/server/trunk/openerp/sql_db.py", line 215, 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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openerp-web/+bug/885663/+subscriptions
Follow ups

[Bug 885663] Re: Crash when confirming a payslip
From: Serpent Consulting Services, 2011-11-12
[Bug 885663] Re: Crash when confirming a payslip
From: Serpent Consulting Services, 2011-11-04
[Bug 885663] Re: Crash when confirming a payslip
From: Bharat Devnani (Open ERP), 2011-11-04
[Bug 885663] Re: Crash when confirming a payslip
From: Bharat Devnani (Open ERP), 2011-11-04
[Bug 885663] Re: Crash when confirming a payslip
From: Jignesh Rathod(OpenERP), 2011-11-04
[Bug 885663] Re: Crash when confirming a payslip
From: Serpent Consulting Services, 2011-11-04
[Bug 885663] Re: Crash when confirming a payslip
From: Launchpad Bug Tracker, 2011-11-04
[Bug 885663] Re: Crash when confirming a payslip
From: Jignesh Rathod(OpenERP), 2011-11-04
[Bug 885663] [NEW] Crash when confirming a payslip
From: Antoine(OpenERP), 2011-11-03
References

[Bug 885663] [NEW] Crash when confirming a payslip
From: Antoine(OpenERP), 2011-11-03