c2c-oerpscenario team mailing list archive

[Peter Glock <617905@xxxxxxxxxxxxxxxxxx>]

I did another attempt today:

1. ran bzr merge && bzr commit -m "Merge from main branch" in all components
2. started the server and created a new database, installed the connector
3. Ran steps 1-6 in the magento connector against a copy of my production database
4. Product import fails with "IntegrityError: null value in column "categ_id" violates not-null constraint"

Looking at the debug messages from xmlrpc:

[2010-11-23 13:59:58,239][splattest1] ERROR:db.cursor:bad query: insert into "product_template" (id,"supply_method","list_price","description","weight_net","standard_price","mes_type","uom_id","description_sale","cost_method","categ_id","name","uos_coeff","sale_delay","procure_method","sale_ok","purchase_ok","company_id","produce_delay","uom_po_id","rental","type",create_uid,create_date) values (3,E'buy',E'12.95',E'Ahoy there me hearties, do me bidding or I''ll run ya through wi'' my cutlass - sorry getting a bit carried away, maybe I shoudn''t watch Pirates of the Caribbean so often!  Anyway, this is a fab sword with a cut out bit for the handle, great with our skull and cross bones and parrot cutter.  Lovely big copper cutter 10cm x 17.5cm',0.1,E'0.00',E'fixed',1,E'Ahoy there me hearties. Lovely big copper cutter 10cm x 17.5cm',E'standard',NULL,E'Pirate Sword or Cutlass Big Copper Cookie Cutter',1.0,7.0,E'make_to_stock',E'True',E'True',1,1.0,1,E'False',E'consu',1,now())
Traceback (most recent call last):
  File "/opt/local/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/site-packages/openerp-server/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "categ_id" violates not-null constraint

...it looks like there is 'NULL' entry for categ_id. When I look at the
product (this is the first product in the catalog), it is a member of
three categories. Any ideas?

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

Status in Magento Open ERP Connector: Invalid

Bug description:
I'm using current stable (5.0.12) on an Amazon EC2 ubuntu 10.4 instance. I have installed and configured the openerpconnect module ok and the corresponding magento module.

In OpenERP, clicking on the referential actions in turn (1 - Import Customer Groups through to 5 - Import Product Attributes) works fine but when I click on 6 - Import products I get the following error. We have approx 2000 products, is this a timeout problem, or something else?

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 577, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 111, 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 137, 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()