Installation error openerp6.1-stable

Asked by Diego Madrigali on 2013-01-04

I get the following error when trying to install to openerp6.1 running on linux. I have all latest branches for ecommerce addons, oerp6.1stable, obenobject extension and product-extra-addons.

Any help?

Client Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1052, in call_button
    action = self.call_common(req, model, method, args, domain_id, context_id)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 996, in call_common
    return self._call_kw(req, model, method, args, {})
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1010, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 250, in proxy
    args, kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 608, in send
    raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

Server Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 593, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 167, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/module/module.py", line 361, in button_immediate_install
    db, pool = pooler.restart_pool(cr.dbname, update_module=True)
  File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 39, in restart_pool
    registry = RegistryManager.new(db_name, force_demo, status, update_module, True)
  File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 202, in new
    openerp.modules.load_modules(registry.db, force_demo, status, update_module)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 338, in load_modules
    processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 253, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 192, in load_module_graph
    load_update_xml(module_name, idref, mode)
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 90, in <lambda>
    load_update_xml = lambda *args: _load_data(cr, *args, kind='update_xml')
  File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 132, in _load_data
    tools.convert_csv_import(cr, module_name, pathname, fp.read(), idref, mode, noupdate)
  File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 974, in convert_csv_import
    raise Exception(_('Module loading failed: file %s/%s could not be processed:\n %s') % (module, fname, warning_msg))
Exception: Module loading failed: file base_sale_multichannels/base_sale_multichannels/settings/sale.exception.csv could not be processed:
 Line 3 : null value in column "name" violates not-null constraint

Question information

Language:
English Edit question
Status:
Solved
For:
Magento OpenERP Connector Edit question
Assignee:
No assignee Edit question
Solved by:
Diego Madrigali
Solved:
2013-01-10
Last query:
2013-01-10
Last reply:
2013-01-09
Diego Madrigali (burdo3417) said : #1

The first line in the sale.exception.csv is
id,name,description,sequence,model,code

Could it be because it should be with the ""?
"id","name","description","sequence","model","code"

nikko (nikkowang) said : #2

Not the first line problem.

Delete last line like "","","",7,""

this line contain null value of many column like "name" and cuase this error.

Diego Madrigali (burdo3417) said : #3

Well. Deleting that line completely worked for the install base on the very last branches.

I wonder if it is going to affect how something worked. Testing now. I'll let you asap.

Diego Madrigali (burdo3417) said : #4

Everything working. The only problem is:

I can import orders fine. If the order is invoiced and shipped (completed) it will still be unpaid and unshipped. Not a big issue, but when i try to confirm the order on OpenERP i get the following error:

  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 863, in action_ship_create
    self._create_pickings_and_procurements(cr, uid, order, order.order_line, None, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 831, in _create_pickings_and_procurements
    move_id = move_obj.create(cr, uid, self._prepare_order_line_move(cr, uid, order, line, picking_id, date_planned, context=context))
  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 728, in _prepare_order_line_move
    location_id = order.shop_id.warehouse_id.lot_stock_id.id
AttributeError: 'NoneType' object has no attribute 'id'

The stock level from Magento to OpenERP is not importing. But I think this is not an error. It's supposed to be this way.

nikko (nikkowang) said : #5

Regarding order.shop_id.warehouse_id.lot_stock_id.id problem, try to set warehouse of the magento shop.

Diego Madrigali (burdo3417) said : #6

That worked

Hello , I got this error message when I try to export product from OpenErp 6.1 :

Traceback (most recent call last):
  File "/opt/openerp/openerp-6.1-1/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/openerp-6.1-1/openerp/osv/osv.py", line 164, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_sale_export_product/wizard/export_product.py", line 77, in export_product
    return self.export(cr, uid, id, ['export_product'], context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_sale_export_product/wizard/export_product.py", line 73, in export
    self._export_one_product(cr, uid, external_session, product_id, options, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/product_links_sync/product.py", line 128, in _export_one_product
    res = super(product_export_wizard, self)._export_one_product(cr, uid, external_session, product_id, options, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_sale_export_product/wizard/export_product.py", line 40, in _export_one_product
    product_obj._export_one_resource(cr, uid, external_session, product_id, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/external_osv.py", line 1129, in _export_one_resource
    False, mapping, mapping_id, defaults=defaults, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/decorator.py", line 49, in wrapped
    return func(self, cr, uid, argument, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/decorator.py", line 110, in wrapper
    return func(self, cr, uid, external_session, resource, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/magerp_osv.py", line 47, in _transform_and_send_one_resource
    return self.mag_transform_and_send_one_resource(cr, uid, external_session, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/external_osv.py", line 1110, in _transform_and_send_one_resource
    return self.send_to_external(cr, uid, external_session, {resource_id : resource}, mapping, mapping_id, update_date, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/product.py", line 1067, in send_to_external
    self.export_inventory(cr, uid, external_session, product_ids, context=context)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/product.py", line 1436, in export_inventory
    self._export_inventory(cr, uid, external_session, product_id, context=location_ctx)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/base_external_referentials/decorator.py", line 110, in wrapper
    return func(self, cr, uid, external_session, resource, *args, **kwargs)
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/product.py", line 1452, in _export_inventory
    [mag_product_id, inventory_vals])
  File "/opt/openerp/openerp-6.1-1/openerp/addons/magentoerpconnect/magerp_osv.py", line 223, in call
    res = self.ser.call(self.session, method, arguments)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1224, in __call__
    return self.__send(self.__name, args)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1578, in __request
    verbose=self.__verbose
  File "/usr/lib/python2.7/xmlrpclib.py", line 1264, in request
    return self.single_request(host, handler, request_body, verbose)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1297, in single_request
    return self.parse_response(response)
  File "/usr/lib/python2.7/xmlrpclib.py", line 1473, in parse_response
    return u.close()
  File "/usr/lib/python2.7/xmlrpclib.py", line 793, in close
    raise Fault(**self._stack[0])
Fault: <Fault 3: 'Invalid api path.'>

Have you any idea ??????

André Savi (contato-p) said : #8

@eh.dem (eh-dem) , probably this is an Magento side error.

Try to install the Magento Path, https://code.launchpad.net/~magentoerpconnect-core-editors/magentoerpconnect/module-magento-trunk

Good luck!!!

Gestion-Ressources (mareeting) said : #9

Thanks André Savi (contato-p) , finally I resolved this issue