← Back to team overview

openerp-india team mailing list archive

[Bug 1112672] Re: problem: bank_account_id violates nut-null constraint

 

Hello Nicola,

I faced this same error on my old database when I have update my trunk code but didn't update my database.
Whenever you will update your db, you will not face the error as well you will try with new database.

Please check it again and let us know about it.

Thanks and waiting for your reply!

** Changed in: openobject-server
       Status: New => Incomplete

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

Title:
  problem: bank_account_id violates nut-null constraint

Status in OpenERP Server:
  Incomplete

Bug description:
  Hi, OpenERP 7.0 Ubuntu 12.04 64 bit.

  I have this error in openerp console, during autovacuum scheduled
  action:

  2013-02-01 16:50:59,089 29382 ERROR my_db openerp.addons.base.ir.ir_cron: Call of self.pool.get('osv_memory.autovacuum').power_on(cr, uid, *()) failed in Job 1
  Traceback (most recent call last):
    File "/home/thebrush/lp7/openerp/openerp/addons/base/ir/ir_cron.py", line 132, in _callback
      method(cr, uid, *args)
    File "/home/thebrush/lp7/openerp/openerp/addons/base/ir/osv_memory_autovacuum.py", line 31, in power_on
      model._transient_vacuum(cr, uid, force=True)
    File "/home/thebrush/lp7/openerp/openerp/osv/orm.py", line 5191, in _transient_vacuum
      self._transient_clean_rows_older_than(cr, self._transient_max_hours * 60 * 60)
    File "/home/thebrush/lp7/openerp/openerp/osv/orm.py", line 5155, in _transient_clean_rows_older_than
      self.unlink(cr, SUPERUSER_ID, ids)
    File "/home/thebrush/lp7/openerp/openerp/osv/orm.py", line 3976, in unlink
      'where id IN %s', (sub_ids,))
    File "/home/thebrush/lp7/openerp/openerp/sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "/home/thebrush/lp7/openerp/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "bank_account_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."account_bank_accounts_wizard" SET "bank_account_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "bank_account_id""

  thanks

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1112672/+subscriptions


References