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

Bug #693663 reported by OpenBMS JSC
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Odoo Addons (MOVED TO GITHUB)
Fix Released
Medium
OpenERP R&D Addons Team 3

Bug Description

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

Revision history for this message
Jamin Shah(OpenERP) (jamin-openerp) wrote :

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

Thanks.

Changed in openobject-addons:
assignee: nobody → OpenERP R&D Addons Team 3 (openerp-dev-addons3)
importance: Undecided → Medium
status: New → Confirmed
Revision history for this message
Mustufa Rangwala (Open ERP) (mra-tinyerp) wrote :

Hello Phong,

Bug is fixed in Trunk addons with,

Revision ID: <email address hidden>
Revision: 4051

Thank you,
Mustufa

Changed in openobject-addons:
status: Confirmed → In Progress
milestone: none → 6.0-rc2
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.