c2c-oerpscenario team mailing list archive

Thread
Date
Re: [Bug 779474] Re: [6.1 trunk]:[account_voucher]: loading test/account_voucher.yml fails

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: Bogdan Stanciu <bogdanovidiu.stanciu@xxxxxxxxx>
Date: Wed, 18 May 2011 10:13:23 -0000
Reply-to: Bug 779474 <779474@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
On 18. 05. 11 07:54, Vinay Rana (openerp) wrote:
> Hello Bogdan,
>
> I have checked your log.Again I have created a new database with l10n_ch module but did not face the same traceback.
> For your reference I am also attaching the related log at my end.
>
> So I am sure it's your end problem.
> Would you please remove all .pyc files and try again.
>
> Thanks.
>
> ** Attachment added: "testing_log.txt"
>    https://bugs.launchpad.net/openobject-addons/+bug/779474/+attachment/2133299/+files/testing_log.txt
>
thank you again!

i gave another try, with latest revs (as of today)

i reinstalled server, client, updated all addons (so EVERYTHING was
erased and written anew)

NEW db, db language french, with demo
extended configuration
country Switzerland, currency CHF
select ONLY accounting/finance (one check)
left COA config by default
the error appearer in the log (see the log)
left again COA config by default (taxes, acc)
left last screen by default (two checks in gray)
END

here is the log, with the same traceback.
enjoy:-)

Please let me know if I can provide additional info.
ubuntu 11.4, python 9

regards, Bogdan


** Attachment added: "openerp-server.log"
   https://bugs.launchpad.net/bugs/779474/+attachment/2133509/+files/openerp-server.log

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

Title:
  [6.1 trunk]:[account_voucher]: loading test/account_voucher.yml fails

Status in OpenERP Modules (addons):
  Incomplete

Bug description:
  hi there,

  while installing a NEW db with latest revs, i get this traceback:

  [2011-05-08 14:41:57,437][bs_test_minimal] INFO:init:module account_voucher: loading test/account_voucher.yml
  [2011-05-08 14:41:57,665][bs_test_minimal] ERROR:db.cursor:bad query: insert into "account_move" (id,"name","company_id","journal_id","state","period_id","narration","date","ref","to_check",create_uid,create_date) values (8,E'BNK/2011/001',E'1',5,E'draft',6,E'Basic Pc',NULL,E'none',E'False',1,now())
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "date" violates not-null constraint

  [2011-05-08 14:41:57,666][bs_test_minimal] ERROR:tests.account_voucher:null value in column "date" violates not-null constraint
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 729, in process
      self._process_node(node)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 763, in _process_node
      self.process_workflow({node: []})
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 452, in process_workflow
      wf_service.trg_validate(uid, workflow.model, id, workflow.action, self.cr)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/wkf_service.py", line 80, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 174, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 182, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 107, in _execute
      wkf_expr.execute(cr, ident, workitem, activity)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/safe_eval.py", line 284, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/osv/orm.py", line 181, in <lambda>
      return lambda *args, **argv: attr(self._cr, self._uid, [self._id], *args, **argv)
    File "/home/openerp/addons/account_voucher/account_voucher.py", line 569, in proforma_voucher
      self.action_move_line_create(cr, uid, ids, context=context)
    File "/home/openerp/addons/account_voucher/account_voucher.py", line 669, in action_move_line_create
      move_id = move_pool.create(cr, uid, move)
    File "/home/openerp/addons/account/account.py", line 1288, in create
      result = super(account_move, self).create(cr, uid, vals, context)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/osv/orm.py", line 3652, in create
      cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "date" violates not-null constraint

  [2011-05-08 14:41:57,735][bs_test_minimal] ERROR:test:Tests failed to execute in module account_voucher
  Traceback (most recent call last):
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/addons/__init__.py", line 680, in load_test
      _load_data(cr, module_name, id_map, mode, 'test')
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/addons/__init__.py", line 703, in _load_data
      tools.convert_yaml_import(cr, module_name, file, id_map, mode, noupdate)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 794, in yaml_import
      yaml_interpreter.process(yaml_string)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 729, in process
      self._process_node(node)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 763, in _process_node
      self.process_workflow({node: []})
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/yaml_import.py", line 452, in process_workflow
      wf_service.trg_validate(uid, workflow.model, id, workflow.action, self.cr)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/wkf_service.py", line 80, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 174, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 182, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/workitem.py", line 107, in _execute
      wkf_expr.execute(cr, ident, workitem, activity)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/tools/safe_eval.py", line 284, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/osv/orm.py", line 181, in <lambda>
      return lambda *args, **argv: attr(self._cr, self._uid, [self._id], *args, **argv)
    File "/home/openerp/addons/account_voucher/account_voucher.py", line 569, in proforma_voucher
      self.action_move_line_create(cr, uid, ids, context=context)
    File "/home/openerp/addons/account_voucher/account_voucher.py", line 669, in action_move_line_create
      move_id = move_pool.create(cr, uid, move)
    File "/home/openerp/addons/account/account.py", line 1288, in create
      result = super(account_move, self).create(cr, uid, vals, context)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/osv/orm.py", line 3652, in create
      cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.7/dist-packages/openerp_server-6.1_dev-py2.7.egg/openerp/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "date" violates not-null constraint

  [2011-05-08 14:41:57,919][bs_test_minimal] INFO:i18n:module
  account_voucher: loading translation file (fr) for language fr_FR

  
  thank you!
References

[Bug 779474] [NEW] [6.1 trunk]:[account_voucher]: loading test/account_voucher.yml fails
From: Bogdan Stanciu, 2011-05-08
[Bug 779474] Re: [6.1 trunk]:[account_voucher]: loading test/account_voucher.yml fails
From: Vinay Rana (openerp), 2011-05-18