IntegrityError: null value in column "company_id" violates not-null constraint

[OpenBMS JSC]

After creating a new DB, I install several customization modules but experience the following error for accounting modules (I check the option "Accounting & Financial" in the UI). This doesn't happen in the last week or so.

addons/: revision-id: <email address hidden> revno: 4045
addons-community/: revision-id: fran@fran-pc-20101213182241-2fogs8yh5u4ma31q revno: 292
addons-extra/: revision-id: <email address hidden> revno: 5117
server/: revision-id: <email address hidden> revno: 3145

[2010-12-23 09:51:00,646][demo60] INFO:init:module crclinic_data: no quality certificate
[2010-12-23 09:51:00,656][demo60] ERROR:db.cursor:bad query: insert into "account_fiscalyear" (id,"state","code","name","date_start","date_stop","company_id",create_uid,create_date) values (3,E'draft',E'2010',E'2010',E'2010-01-01',E'2010-12-31',NULL,1,now())
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "company_id" violates not-null constraint

[2010-12-23 09:51:00,657][demo60] DEBUG:web-services:IntegrityError
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 176, in execute
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/base/res/res_config.py", line 167, in action_next
    next = self.execute(cr, uid, ids, context=None)
  File "/var/local/software/openerp-v6.0dev/server/bin/addons/account/installer.py", line 724, in execute
    fiscal_id = fy_obj.create(cr, uid, vals, context=context)
  File "/var/local/software/openerp-v6.0dev/server/bin/osv/orm.py", line 3740, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/var/local/software/openerp-v6.0dev/server/bin/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "company_id" violates not-null constraint

[2010-12-23 09:51:00,660][demo60] DEBUG:web-services:netrpc: rpc-dispatching exception
Traceback (most recent call last):
  File "/var/local/software/openerp-v6.0dev/server/bin/service/netrpc_server.py", line 70, in run
    result = self.dispatch(msg[0], msg[1], msg[2:])
  File "/var/local/software/openerp-v6.0dev/server/bin/netsvc.py", line 499, in dispatch
    raise OpenERPDispatcherException(e, tb_s)
OpenERPDispatcherException

[Jamin Shah(OpenERP) (jamin-openerp)]

This problem is occur when you installing either Sales Management or Purchase Management from configuration wizard.

Thanks.

[Mustufa Rangwala (Open ERP) (mra-tinyerp)]

Hello Phong,

Bug is fixed in Trunk addons with,

Revision ID: <email address hidden>
Revision: 4051

Thank you,
Mustufa