c2c-oerpscenario team mailing list archive

[Phong Nguyen <693663@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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: qdp-launchpad@xxxxxxxxxxx-20101222224722-co70k0g3d9y22cku revno: 4045
addons-community/: revision-id: fran@fran-pc-20101213182241-2fogs8yh5u4ma31q revno: 292
addons-extra/: revision-id: alexis@xxxxxxxxxx-20101213202902-osg052b07bwnq8ld revno: 5117
server/: revision-id: fp@xxxxxxxxxxx-20101222184021-7vzgrjcgbnmnnfq5 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

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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/693663

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

Status in OpenObject Addons Modules:
  New

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: qdp-launchpad@xxxxxxxxxxx-20101222224722-co70k0g3d9y22cku revno: 4045
addons-community/: revision-id: fran@fran-pc-20101213182241-2fogs8yh5u4ma31q revno: 292
addons-extra/: revision-id: alexis@xxxxxxxxxx-20101213202902-osg052b07bwnq8ld revno: 5117
server/: revision-id: fp@xxxxxxxxxxx-20101222184021-7vzgrjcgbnmnnfq5 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