Magento OpenERP Connector

(order not exists) magento response

Bug #985507 reported by David on 2012-04-19

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Magento OpenERP Connector	Confirmed	Low	Unassigned

Bug Description

in a fresh install with the latest branch of the server, addon, magentoerpconnect (599) the orders doesn't import correctly and the process is looping : constantly is updating the res.partner.address and no order is download.

We have three diferent views of the store in different language (Catalan, Spanish and English). I had configured every store with the respective language and also the default language for the main webside.

When I type this : tail -n 200 /var/log/openerp/openerp-server.log | grep external_id

I get the next lines:

2012-04-19 08:49:29,453 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 104 and OpenERP id 96 successfully
2012-04-19 08:49:29,456 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 118 and OpenERP id 97 successfully
2012-04-19 08:49:29,459 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 164 and OpenERP id 98 successfully
2012-04-19 08:49:29,462 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 173 and OpenERP id 99 successfully
2012-04-19 08:49:29,466 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 189 and OpenERP id 100 successfully
2012-04-19 08:49:31,188 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 113 and OpenERP id 103 successfully
2012-04-19 08:49:31,634 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 104 and OpenERP id 96 successfully
2012-04-19 08:49:31,638 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 118 and OpenERP id 97 successfully
2012-04-19 08:49:31,641 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 164 and OpenERP id 98 successfully
2012-04-19 08:49:31,644 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 173 and OpenERP id 99 successfully
2012-04-19 08:49:31,647 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 189 and OpenERP id 100 successfully
2012-04-19 08:49:32,031 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Created in OpenERP sale.order from External Ref with external_id 200000021-1 and OpenERP id 228 successfully
2012-04-19 08:49:34,224 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 113 and OpenERP id 103 successfully
2012-04-19 08:49:34,771 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 104 and OpenERP id 96 successfully
2012-04-19 08:49:34,774 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 118 and OpenERP id 97 successfully
2012-04-19 08:49:34,777 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 164 and OpenERP id 98 successfully
2012-04-19 08:49:34,780 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 173 and OpenERP id 99 successfully
2012-04-19 08:49:34,783 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 189 and OpenERP id 100 successfully
2012-04-19 08:49:36,521 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 13 and OpenERP id 6 successfully
2012-04-19 08:49:36,885 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 5 and OpenERP id 4 successfully
2012-04-19 08:49:38,584 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 13 and OpenERP id 6 successfully
2012-04-19 08:49:38,947 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 5 and OpenERP id 4 successfully
2012-04-19 08:49:40,907 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 13 and OpenERP id 6 successfully
2012-04-19 08:49:41,271 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 5 and OpenERP id 4 successfully
2012-04-19 08:49:43,468 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 13 and OpenERP id 6 successfully
2012-04-19 08:49:43,822 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 5 and OpenERP id 4 successfully
2012-04-19 08:49:45,743 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner from External Ref with external_id 39 and OpenERP id 29 successfully
2012-04-19 08:49:46,108 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Updated in OpenERP res.partner.address from External Ref with external_id 29 and OpenERP id 26 successfully
2012-04-19 08:49:47,049 30449 INFO ? openerp.loglevels.deprecated.ext synchro: Created in OpenERP sale.order from External Ref with external_id 200000065-1 and

Tags:

Revision history for this message

David (dhecar) wrote on 2012-04-23:

Finally I think i found the error.

My client had delete some ordres with a module for magento.

The orders dissapear from the admin but in tha table of Mysql they remains and the connector fails.

Revision history for this message

Kyle Waid (midwest) wrote on 2012-05-16:

As you said this is due to your customer corrupting the magento database. I believe when this error happens, OpenERP should mark the order as imported and possibly to touch it off, create a sale exception or log notice. In this scenario it is impossible to continue order import until the issue is manually corrected directly in the magento database. I believe this is wrong.