← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 656264] Re: IntegrityError: insert or update on table "product_supplierinfo" violates foreign key constraint "product_supplierinfo_name_fkey" DETAIL: Key (name)=(2) is not present in table "res_partner".

 

The clients you removed, have been referenced somewhere else like, as a
supplier of a product,or as a customer/supplier for any invoice,on any
address ,etc.

Version 6(to be released this december) will come up with a lot of such improvements.
Thanks.

-- 
IntegrityError: insert or update on table "product_supplierinfo" violates foreign key constraint "product_supplierinfo_name_fkey" DETAIL:  Key (name)=(2) is not present in table "res_partner".
https://bugs.launchpad.net/bugs/656264
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: Invalid

Bug description:
>From minimal profile + crm modules trying to install product modules I obtain this error


Environment Information : 
System : Linux-2.6.35-22-generic-x86_64-with-Ubuntu-10.10-maverick
OS Name : posix
Distributor ID:	Ubuntu
Description:	Ubuntu maverick (development branch)
Release:	10.10
Codename:	maverick
Operating System Release : 2.6.35-22-generic
Operating System Version : #33-Ubuntu SMP Sun Sep 19 20:32:27 UTC 2010
Operating System Architecture : 64bit
Operating System Locale : it_IT.UTF8
Python Version : 2.6.6
OpenERP-Client Version : 5.0.14
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
  File "/usr/share/pyshared/openerp-server/netsvc.py", line 256, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/share/pyshared/openerp-server/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/usr/share/pyshared/openerp-server/service/web_services.py", line 638, in execute
    return self._execute(db, uid, wiz_id, datas, action, context)
  File "/usr/share/pyshared/openerp-server/service/web_services.py", line 618, in _execute
    return wiz.execute(db, uid, self.wiz_datas[wiz_id], action, context)
  File "/usr/share/pyshared/openerp-server/wizard/__init__.py", line 178, in execute
    res = self.execute_cr(cr, uid, data, state, context)
  File "/usr/share/pyshared/openerp-server/wizard/__init__.py", line 73, in execute_cr
    action_res = action(self, cr, uid, data, context)
  File "/usr/share/pyshared/openerp-server/addons/base/module/wizard/wizard_module_upgrade.py", line 92, in _upgrade_module
    db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/share/pyshared/openerp-server/pooler.py", line 62, in restart_pool
    return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
  File "/usr/share/pyshared/openerp-server/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/share/pyshared/openerp-server/addons/__init__.py", line 736, in load_modules
    r = load_module_graph(cr, graph, status, report=report)
  File "/usr/share/pyshared/openerp-server/addons/__init__.py", line 637, in load_module_graph
    tools.convert_xml_import(cr, m, fp, idref, mode=mode, noupdate=True, **kwargs)
  File "/usr/share/pyshared/openerp-server/tools/convert.py", line 877, in convert_xml_import
    obj.parse(doc.getroot())
  File "/usr/share/pyshared/openerp-server/tools/convert.py", line 774, in parse
    self._tags[rec.tag](self.cr, rec, n)
  File "/usr/share/pyshared/openerp-server/tools/convert.py", line 746, in _tag_record
    id = self.pool.get('ir.model.data')._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode )
  File "/usr/share/pyshared/openerp-server/addons/base/ir/ir_model.py", line 515, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/usr/share/pyshared/openerp-server/osv/orm.py", line 2869, in create
    cr.execute('insert into "'+self._table+'" (id'+upd0+") values ("+str(id_new)+upd1+')', tuple(upd2))
  File "/usr/share/pyshared/openerp-server/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/share/pyshared/openerp-server/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
IntegrityError: insert or update on table "product_supplierinfo" violates foreign key constraint "product_supplierinfo_name_fkey"
DETAIL:  Key (name)=(2) is not present in table "res_partner".