← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 880609] [NEW] base_external_referentials fails to create referential ID, cases integrity violation

 

Public bug reported:

This bug does not reproduce in all installations, but I have a test
system you can access.

Any type of referential ID fails to create, products, sales, partners,
even synchronize. It can create the data, but not the referential. I do
not know what causes it, but it makes it impossible to use connector on
some installations.

I have also seen on several installations, nearly all, where it fails to create product on the fly. It does not work.
An example

[2011-10-24 03:52:11,029][beginnenwebwinkel] INFO:ext synchro:Created in OpenERP res.partner.address from External Ref with external_id 2 and OpenERP id 4 successfully
[2011-10-24 03:52:11,045][beginnenwebwinkel] ERROR:db.cursor:bad query: insert into "ir_model_data" (id,"noupdate","external_referential_id","name","res_id","date_update","module","model","date_init",create_uid,create_date) values (6905,E'False',E'1',E'res_partner_address/2',5,E'2011-10-24 03:52:11',E'extref/http://www.beginnenwebwinkel.com/',E'res.partner.address',E'2011-10-24 03:52:11',1,now())
Traceback (most recent call last):
  File "/usr/local/openerp/openerp-server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
IntegrityError: duplicate key value violates unique constraint "ir_model_data_module_name_uniq"

** Affects: magentoerpconnect
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/880609

Title:
  base_external_referentials fails to create referential ID, cases
  integrity violation

Status in Magento OpenERP Connector:
  New

Bug description:
  This bug does not reproduce in all installations, but I have a test
  system you can access.

  Any type of referential ID fails to create, products, sales, partners,
  even synchronize. It can create the data, but not the referential. I
  do not know what causes it, but it makes it impossible to use
  connector on some installations.

  I have also seen on several installations, nearly all, where it fails to create product on the fly. It does not work.
  An example

  [2011-10-24 03:52:11,029][beginnenwebwinkel] INFO:ext synchro:Created in OpenERP res.partner.address from External Ref with external_id 2 and OpenERP id 4 successfully
  [2011-10-24 03:52:11,045][beginnenwebwinkel] ERROR:db.cursor:bad query: insert into "ir_model_data" (id,"noupdate","external_referential_id","name","res_id","date_update","module","model","date_init",create_uid,create_date) values (6905,E'False',E'1',E'res_partner_address/2',5,E'2011-10-24 03:52:11',E'extref/http://www.beginnenwebwinkel.com/',E'res.partner.address',E'2011-10-24 03:52:11',1,now())
  Traceback (most recent call last):
    File "/usr/local/openerp/openerp-server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: duplicate key value violates unique constraint "ir_model_data_module_name_uniq"

To manage notifications about this bug go to:
https://bugs.launchpad.net/magentoerpconnect/+bug/880609/+subscriptions


Follow ups

References