c2c-oerpscenario team mailing list archive

[LACAILLE stephane <728521@xxxxxxxxxxxxxxxxxx>]

So sorry but I tried and tried and tried several time and I cannot import my 15000+ products.
Step one to 5 is no problem but import of product step 6 break down after the last product is read (one hour each time I tried...)
I put php.ini and htaccess with no limit. Firewall is down. I restart server. I create a new database...

I got this in the log.


Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
IntegrityError: ERREUR:  la valeur d'une clé dupliquée rompt la contrainte unique « ir_model_data_module_name_uniq »

[2011-03-06 00:57:30,398][stortlator] ERROR:db.cursor:bad query: SELECT "ir_model".id FROM "ir_model" WHERE (ir_model.model = E'product.category') ORDER BY model
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à  la fin du bloc
de la transaction

[2011-03-06 00:57:30,399][stortlator] ERROR:db.cursor:bad query: SELECT "ir_model".id FROM "ir_model" WHERE (ir_model.model = E'magerp.product_attribute_set') ORDER BY model
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à  la fin du bloc
de la transaction

[2011-03-06 00:57:30,400][stortlator] ERROR:db.cursor:bad query: SELECT "magerp_product_product_type".id FROM "magerp_product_product_type" WHERE (magerp_product_product_type.product_type = E'simple') ORDER BY id
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à  la fin du bloc
de la transaction

[2011-03-06 00:57:30,401][stortlator] ERROR:db.cursor:bad query: SELECT "ir_model".id FROM "ir_model" WHERE (ir_model.model = E'external.shop.group') ORDER BY model
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à  la fin du bloc
de la transaction

[2011-03-06 00:57:30,404][stortlator] ERROR:db.cursor:bad query: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (ir_model_data.model = E'product.product') AND (ir_model_data.name = E'product.product_226') AND (ir_model_data.external_referential_id = E'1') ORDER BY module,model,name
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction

[2011-03-06 00:57:30,405][stortlator] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_core.py", line 149, in sync_products
    self.pool.get('product.product').ext_import(cr, uid, result, inst.id, context={})
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base_external_referentials.zip/base_external_referentials/external_osv.py", line 188, in ext_import
    existing_ir_model_data_id = self.pool.get('ir.model.data').search(cr, uid, [('model', '=', self._name), ('name', '=', self.prefixed_id(external_id)), ('external_referential_id', '=', external_referential_id)])
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 1735, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3981, 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/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à  la fin du bloc
de la transaction

If you can contact me to make my config work, I m ok to pay
excuse my bad english because i m french.
best regards
stephane

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

Title:
  Import Product failed

Status in Magento Open ERP Connector:
  Invalid

Bug description:
  I run magento 1.4.1.1 and openerp6. So I'm able to do step 1 to 5 but
  on step 6 I have little issue :

  [2011-03-03 17:01:52,605][new_new_erp] INFO:Magento Connection:Attempting connection with Settings:http://girod.new/index.php/api/xmlrpc/,openerp,123456789
  [2011-03-03 17:01:54,570][new_new_erp] INFO:Magento Connection:Login Successful
  [2011-03-03 17:01:54,570][new_new_erp] INFO:Magento Connection:Calling Method:catalog_product.list,Arguments:[]
  [2011-03-03 17:01:58,182][new_new_erp] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_core.py", line 153, in sync_products
      list_prods = attr_conn.call('catalog_product.list')
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 53, in call
      res = self.ser.call(self.session, method, arguments)
    File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
      return self.__send(self.__name, args)
    File "/usr/lib/python2.6/xmlrpclib.py", line 1489, in __request
      verbose=self.__verbose
    File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
      return self._parse_response(h.getfile(), sock)
    File "/usr/lib/python2.6/xmlrpclib.py", line 1392, in _parse_response
      return u.close()
    File "/usr/lib/python2.6/xmlrpclib.py", line 836, in close
      raise ResponseError()
  ResponseError: ResponseError()

  
  I try to know if it's timeout issue as many had but I think no because . On magento side I put this in the function called items : 

  IN Openlabs_OpenERPConnector_Model_Olcatalog_Products

      public function items($filters = null, $store = null)
      {
          Mage::log("ok LIST PRODUCT");
  ...

  
  But nothing shown on var/log/system.log in magento. So openerp's request is never ask to magento api...

  Can anyone have this kind of issue ?