c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Sunday 15 May 2011, you wrote:
> 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.

...
DETAIL: Key (name)=(2) is not present in table "res_partner".

The 'DETAIL' line will only give you the values, not the id's of the offending 
lines. Reason is, Postgres tables are not always supposed to have 'id' or 
anything standardized as their primary key. So, the server can only report the 
values, not guess and report the primary key(s).

setting "res.partner.name = '2' " ? May I ask why you are trying to do
that?

-- 
Say NO to spam and viruses. Stop using Microsoft Windows!

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