c2c-oerpscenario team mailing list archive

[Mihai Boiciuc <656264@xxxxxxxxxxxxxxxxxx>]

I have this error too on V6.0.2, I would really like to find a way to
see the exact lines in the database that are not ok.


Thanks.

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

Title:
  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".

Status in OpenERP 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".