devendrapathi / sneldev-magento-openerp

Automatically exported from code.google.com/p/sneldev-magento-openerp
0 stars 1 forks source link

Error while importing orders #36

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.Import orders
2.
3.

What version of the product are you using? On what operating system?

Openerp 6.1
Magento 1.7.0.2

Please provide any additional information below.

Log :
2013-01-10 14:20:36 Invoice 700000053 - Order 77 - Created 2012-08-31 14:21:19
2013-01-10 14:20:36     Getting Info invoice 700000053
2013-01-10 14:20:37     Getting Info order 77
2013-01-10 14:20:38     ERROR ! Invoice Skipped
Traceback (most recent call last):
  File "/usr/share/openerp/addons/sneldev_magento/sneldev_magento.py", line 754, in import_orders
    id_orders = self.pool.get('sale.order').search(cr, uid, [('magento_id', '=', info_order['order_id'])])
  File "/usr/share/openerp/osv/orm.py", line 2241, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/share/openerp/osv/orm.py", line 4561, in _search
    cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params)
  File "/usr/share/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/share/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of 
transaction block

Same with all orders.

Also get :

2013-01-10 15:41:11 Invoice 700000008 - Order 27 - Created 2012-05-23 11:31:25
2013-01-10 15:41:11     Getting Info invoice 700000008
2013-01-10 15:41:12     Getting Info order 27
2013-01-10 15:41:14     Getting Info customer 29
2013-01-10 15:41:15     Updating customer Pablo Benedi Gascon
2013-01-10 15:41:15             Customer not found in OpenErp -> creation
2013-01-10 15:41:15             Creation of new invoice contact address
2013-01-10 15:41:15             Creation of new delivery contact address
2013-01-10 15:41:15     Creation of sales order in OpenErp 700000008
2013-01-10 15:41:15             No parent price
2013-01-10 15:41:15             Product with magento_id 311 not found in ERP - 
skipping
2013-01-10 15:41:15             Creating shipping costs :3.3900
2013-01-10 15:41:15                     Tax added, id: 4
2013-01-10 15:41:15     Missing products in openERP, leaving in order in draft 
state

But no order is created.

After many error like that I get :

2013-01-10 15:55:38 Done
2013-01-10 15:55:38 ===== Credit memo import
2013-01-10 15:55:38 Could not retreive Magento credit memos. Did you install 
the Magento module ?

And yes, moule is installed.

Regards

Original issue reported on code.google.com by serrrgi...@gmail.com on 10 Jan 2013 at 4:41