Crash when confirming a payslip

[Antoine(OpenERP)]

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.

[Jignesh Rathod(OpenERP) (jir-openerp)]

Hello Antoine,

I have checked this issue at my end.
but I did not face any trace back so
would you please provide more information
regarding this issue like video or screen shot.

Thanks and waiting for replay.

[Serpent Consulting Services (serpent-consulting-services)]

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.

[Bharat Devnani (Open ERP) (bde-openerp)]

Hello Antoine, SerpentCS

Thanks for reporting and contributing, the solution of this bug will be merged in main addons soon.
The solution is applied in lp:~serpent-consulting-services/openobject-addons/trunk-885663-SerpentCS
with following Revision ID and Number:

Revision ID : <email address hidden>
Revision Number : 5493

Thanks & Regards,
Devnani Bharat R.

[Serpent Consulting Services (serpent-consulting-services)]

Thank you Bharat Devnani for reviewing.

The merge should get approved before getting merged I suppose.

Regards,
Serpent Consulting Services.