openerp-india team mailing list archive

[Serpent Consulting Services <885663@xxxxxxxxxxxxxxxxxx>]

Jignesh,

This is infact a confirmed error arising when one has not properly
configured the accounts inside the Expense Journal Linked to the
Payslip.

You might be trying to reproduce the error on the DB with demo data
installed, but this is not the case in realtime.

However, you can still generate the error in your DB, go to the payslip,
slect its Expense journal, remove default credit/debit accounts. Confirm
the Payslip now.

Attached the is merge proposal for the same.

Thanks,
Serpent Consulting Services.


** Project changed: openerp-web => openobject-addons

** Changed in: openobject-addons
       Status: Incomplete => Confirmed

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/885663

Title:
  Crash when confirming a payslip

Status in OpenERP Addons (modules):
  Confirmed

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/openobject-addons/+bug/885663/+subscriptions