c2c-oerpscenario team mailing list archive

Thread
Date
[Bug 617905] Re: Product Import fails

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: Kyle Waid <617905@xxxxxxxxxxxxxxxxxx>
Date: Sun, 07 Nov 2010 19:59:05 -0000
Reply-to: Bug 617905 <617905@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
This is a fresh erp-server log with the print response[2010-11-07 14:57:44,118][?] DEBUG:psycopg2:installed. Logging using Python logging module
[2010-11-07 14:57:44,122][?] INFO:server:version - 5.0.14
[2010-11-07 14:57:44,122][?] INFO:server:addons_path - /usr/share/pyshared/openerp-server/addons
[2010-11-07 14:57:44,123][?] INFO:server:database hostname - 127.0.0.1
[2010-11-07 14:57:44,123][?] INFO:server:database port - 5432
[2010-11-07 14:57:44,123][?] INFO:server:database user - openerp
[2010-11-07 14:57:44,124][?] INFO:objects:initialising distributed objects services
[2010-11-07 14:57:44,415][?] INFO:web-services:starting XML-RPC services, port 8069
[2010-11-07 14:57:44,416][?] INFO:web-services:starting NET-RPC service, port 8070
[2010-11-07 14:57:44,417][?] INFO:web-services:the server is running, waiting for connections...
[2010-11-07 14:57:49,864][openerp] INFO:init:module base: loading objects
[2010-11-07 14:57:49,865][openerp] INFO:init:module base: registering objects
[2010-11-07 14:57:50,694][openerp] DEBUG:init:Updating graph with 34 more modules
[2010-11-07 14:57:50,695][openerp] INFO:init:module base: loading objects
[2010-11-07 14:57:51,189][openerp] INFO:init:module process: loading objects
[2010-11-07 14:57:51,189][openerp] INFO:init:module process: registering objects
[2010-11-07 14:57:51,258][openerp] INFO:init:module base_setup: loading objects
[2010-11-07 14:57:51,258][openerp] INFO:init:module base_setup: registering objects
[2010-11-07 14:57:51,275][openerp] INFO:init:module board: loading objects
[2010-11-07 14:57:51,282][openerp] INFO:init:module board: registering objects
[2010-11-07 14:57:51,317][openerp] INFO:init:module base_external_referentials: loading objects
[2010-11-07 14:57:51,318][openerp] INFO:init:module base_external_referentials: registering objects
[2010-11-07 14:57:51,389][openerp] INFO:init:module product: loading objects
[2010-11-07 14:57:51,390][openerp] INFO:init:module product: registering objects
[2010-11-07 14:57:51,596][openerp] INFO:init:module hr: loading objects
[2010-11-07 14:57:51,596][openerp] INFO:init:module hr: registering objects
[2010-11-07 14:57:51,635][openerp] INFO:init:module product_images_olbs: loading objects
[2010-11-07 14:57:51,636][openerp] INFO:init:module product_images_olbs: registering objects
[2010-11-07 14:57:51,647][openerp] INFO:init:module hr_attendance: loading objects
[2010-11-07 14:57:51,648][openerp] INFO:init:module hr_attendance: registering objects
[2010-11-07 14:57:51,707][openerp] INFO:init:module account: loading objects
[2010-11-07 14:57:51,707][openerp] INFO:init:module account: registering objects
[2010-11-07 14:57:52,412][openerp] INFO:init:module product_m2mcategories: loading objects
[2010-11-07 14:57:52,412][openerp] INFO:init:module product_m2mcategories: registering objects
[2010-11-07 14:57:52,419][openerp] INFO:init:module base_iban: loading objects
[2010-11-07 14:57:52,419][openerp] INFO:init:module base_iban: registering objects
[2010-11-07 14:57:52,427][openerp] INFO:init:module account_chart: loading objects
[2010-11-07 14:57:52,428][openerp] INFO:init:module account_chart: registering objects
[2010-11-07 14:57:52,428][openerp] INFO:init:module stock: loading objects
[2010-11-07 14:57:52,429][openerp] INFO:init:module stock: registering objects
[2010-11-07 14:57:52,581][openerp] INFO:init:module hr_timesheet: loading objects
[2010-11-07 14:57:52,581][openerp] INFO:init:module hr_timesheet: registering objects
[2010-11-07 14:57:52,607][openerp] INFO:init:module base_vat: loading objects
[2010-11-07 14:57:52,607][openerp] INFO:init:module base_vat: registering objects
[2010-11-07 14:57:52,636][openerp] INFO:init:module project: loading objects
[2010-11-07 14:57:52,636][openerp] INFO:init:module project: registering objects
[2010-11-07 14:57:52,709][openerp] INFO:init:module hr_timesheet_invoice: loading objects
[2010-11-07 14:57:52,709][openerp] INFO:init:module hr_timesheet_invoice: registering objects
[2010-11-07 14:57:52,789][openerp] INFO:init:module l10n_chart_uk_minimal: loading objects
[2010-11-07 14:57:52,790][openerp] INFO:init:module l10n_chart_uk_minimal: registering objects
[2010-11-07 14:57:52,791][openerp] INFO:init:module purchase: loading objects
[2010-11-07 14:57:52,791][openerp] INFO:init:module purchase: registering objects
[2010-11-07 14:57:52,849][openerp] INFO:init:module report_analytic_line: loading objects
[2010-11-07 14:57:52,849][openerp] INFO:init:module report_analytic_line: registering objects
[2010-11-07 14:57:52,855][openerp] INFO:init:module report_timesheet: loading objects
[2010-11-07 14:57:52,856][openerp] INFO:init:module report_timesheet: registering objects
[2010-11-07 14:57:52,885][openerp] INFO:init:module account_analytic_analysis: loading objects
[2010-11-07 14:57:52,886][openerp] INFO:init:module account_analytic_analysis: registering objects
[2010-11-07 14:57:52,917][openerp] INFO:init:module mrp: loading objects
[2010-11-07 14:57:52,918][openerp] INFO:init:module mrp: registering objects
[2010-11-07 14:57:53,142][openerp] INFO:init:module hr_timesheet_sheet: loading objects
[2010-11-07 14:57:53,143][openerp] INFO:init:module hr_timesheet_sheet: registering objects
[2010-11-07 14:57:53,202][openerp] INFO:init:module report_task: loading objects
[2010-11-07 14:57:53,203][openerp] INFO:init:module report_task: registering objects
[2010-11-07 14:57:53,219][openerp] INFO:init:module report_analytic_planning: loading objects
[2010-11-07 14:57:53,220][openerp] INFO:init:module report_analytic_planning: registering objects
[2010-11-07 14:57:53,244][openerp] INFO:init:module sale: loading objects
[2010-11-07 14:57:53,244][openerp] INFO:init:module sale: registering objects
[2010-11-07 14:57:53,362][openerp] INFO:init:module board_project: loading objects
[2010-11-07 14:57:53,362][openerp] INFO:init:module board_project: registering objects
[2010-11-07 14:57:53,363][openerp] INFO:init:module account_analytic_default: loading objects
[2010-11-07 14:57:53,363][openerp] INFO:init:module account_analytic_default: registering objects
[2010-11-07 14:57:53,383][openerp] INFO:init:module delivery: loading objects
[2010-11-07 14:57:53,383][openerp] INFO:init:module delivery: registering objects
[2010-11-07 14:57:53,425][openerp] INFO:init:module base_sale_multichannels: loading objects
[2010-11-07 14:57:53,426][openerp] INFO:init:module base_sale_multichannels: registering objects
[2010-11-07 14:57:53,476][openerp] INFO:init:module sneldev_magento: loading objects
[2010-11-07 14:57:53,477][openerp] INFO:init:module sneldev_magento: registering objects
[2010-11-07 14:57:53,505][openerp] INFO:init:module magentoerpconnect: loading objects
[2010-11-07 14:57:53,505][openerp] INFO:init:module magentoerpconnect: registering objects
[2010-11-07 14:57:53,672][openerp] INFO:init:module profile_service: loading objects
[2010-11-07 14:57:53,673][openerp] INFO:init:module profile_service: registering objects
[2010-11-07 14:57:53,699][openerp] INFO:init:module base_external_referentials: no quality certificate
[2010-11-07 14:57:53,716][openerp] INFO:init:module product_images_olbs: no quality certificate
[2010-11-07 14:57:53,745][openerp] INFO:init:module product_m2mcategories: no quality certificate
[2010-11-07 14:57:53,885][openerp] INFO:init:module base_sale_multichannels: no quality certificate
[2010-11-07 14:57:53,899][openerp] INFO:init:module sneldev_magento: no quality certificate
[2010-11-07 14:57:53,907][openerp] INFO:init:module magentoerpconnect: no quality certificate
[2010-11-07 14:57:53,941][openerp] DEBUG:timers:Job scheduled in 3599.05918288 seconds for ir_cron._poolJobs
[2010-11-07 14:57:53,997][openerp] INFO:Magento Connection:Attempting connection with Settings:http://127.0.0.1/index.php/api/xmlrpc/,dwadmin,1astro98
[2010-11-07 14:57:54,578][openerp] INFO:Magento Connection:Login Successful
[2010-11-07 14:57:54,590][openerp] INFO:Magento Connection:Calling Method:catalog_product.list,Arguments:[]
[2010-11-07 14:58:07,730][openerp] ERROR:Magento Call:[01]: 
[2010-11-07 14:58:07,730][openerp] ERROR:Magento Call:[02]: Environment Information : 
[2010-11-07 14:58:07,731][openerp] ERROR:Magento Call:[03]: System : Linux-2.6.35-22-generic-i686-with-Ubuntu-10.10-maverick
[2010-11-07 14:58:07,731][openerp] ERROR:Magento Call:[04]: OS Name : posix
[2010-11-07 14:58:07,731][openerp] ERROR:Magento Call:[05]: Distributor ID:	Ubuntu
[2010-11-07 14:58:07,731][openerp] ERROR:Magento Call:[06]: Description:	Ubuntu 10.10
[2010-11-07 14:58:07,732][openerp] ERROR:Magento Call:[07]: Release:	10.10
[2010-11-07 14:58:07,732][openerp] ERROR:Magento Call:[08]: Codename:	maverick
[2010-11-07 14:58:07,732][openerp] ERROR:Magento Call:[09]: Operating System Release : 2.6.35-22-generic
[2010-11-07 14:58:07,732][openerp] ERROR:Magento Call:[10]: Operating System Version : #35-Ubuntu SMP Sat Oct 16 20:36:48 UTC 2010
[2010-11-07 14:58:07,733][openerp] ERROR:Magento Call:[11]: Operating System Architecture : 32bit
[2010-11-07 14:58:07,733][openerp] ERROR:Magento Call:[12]: Operating System Locale : en_US.UTF8
[2010-11-07 14:58:07,733][openerp] ERROR:Magento Call:[13]: Python Version : 2.6.6
[2010-11-07 14:58:07,734][openerp] ERROR:Magento Call:[14]: OpenERP-Server Version : 5.0.14
[2010-11-07 14:58:07,734][openerp] ERROR:Magento Call:[15]: Last revision No. & ID : 
[2010-11-07 14:58:07,734][openerp] ERROR:Magento Call:[16]: Method: catalog_product.list
[2010-11-07 14:58:07,734][openerp] ERROR:Magento Call:[17]: Arguments:[]
[2010-11-07 14:58:07,735][openerp] ERROR:Magento Call:[18]: Error:ResponseError()
[2010-11-07 14:58:07,745][openerp] WARNING:Magento Call:Webservice Failure, sleeping 1 second before next attempt
[2010-11-07 14:58:08,754][openerp] INFO:Magento Connection:Calling Method:catalog_product.list,Arguments:[]
[2010-11-07 14:58:24,338][openerp] ERROR:Magento Call:[01]: 
[2010-11-07 14:58:24,339][openerp] ERROR:Magento Call:[02]: Environment Information : 
[2010-11-07 14:58:24,339][openerp] ERROR:Magento Call:[03]: System : Linux-2.6.35-22-generic-i686-with-Ubuntu-10.10-maverick
[2010-11-07 14:58:24,339][openerp] ERROR:Magento Call:[04]: OS Name : posix
[2010-11-07 14:58:24,343][openerp] ERROR:Magento Call:[05]: Distributor ID:	Ubuntu
[2010-11-07 14:58:24,345][openerp] ERROR:Magento Call:[06]: Description:	Ubuntu 10.10
[2010-11-07 14:58:24,345][openerp] ERROR:Magento Call:[07]: Release:	10.10
[2010-11-07 14:58:24,345][openerp] ERROR:Magento Call:[08]: Codename:	maverick
[2010-11-07 14:58:24,346][openerp] ERROR:Magento Call:[09]: Operating System Release : 2.6.35-22-generic
[2010-11-07 14:58:24,346][openerp] ERROR:Magento Call:[10]: Operating System Version : #35-Ubuntu SMP Sat Oct 16 20:36:48 UTC 2010
[2010-11-07 14:58:24,346][openerp] ERROR:Magento Call:[11]: Operating System Architecture : 32bit
[2010-11-07 14:58:24,346][openerp] ERROR:Magento Call:[12]: Operating System Locale : en_US.UTF8
[2010-11-07 14:58:24,347][openerp] ERROR:Magento Call:[13]: Python Version : 2.6.6
[2010-11-07 14:58:24,347][openerp] ERROR:Magento Call:[14]: OpenERP-Server Version : 5.0.14
[2010-11-07 14:58:24,347][openerp] ERROR:Magento Call:[15]: Last revision No. & ID : 
[2010-11-07 14:58:24,347][openerp] ERROR:Magento Call:[16]: Method: catalog_product.list
[2010-11-07 14:58:24,353][openerp] ERROR:Magento Call:[17]: Arguments:[]
[2010-11-07 14:58:24,354][openerp] ERROR:Magento Call:[18]: Error:ResponseError()
[2010-11-07 14:58:24,357][openerp] WARNING:Magento Call:Webservice Failure, sleeping 3 second before next attempt
[2010-11-07 14:58:27,362][openerp] INFO:Magento Connection:Calling Method:catalog_product.list,Arguments:[]
[2010-11-07 14:58:38,327][openerp] ERROR:Magento Call:[01]: 
[2010-11-07 14:58:38,327][openerp] ERROR:Magento Call:[02]: Environment Information : 
[2010-11-07 14:58:38,328][openerp] ERROR:Magento Call:[03]: System : Linux-2.6.35-22-generic-i686-with-Ubuntu-10.10-maverick
[2010-11-07 14:58:38,328][openerp] ERROR:Magento Call:[04]: OS Name : posix
[2010-11-07 14:58:38,328][openerp] ERROR:Magento Call:[05]: Distributor ID:	Ubuntu
[2010-11-07 14:58:38,328][openerp] ERROR:Magento Call:[06]: Description:	Ubuntu 10.10
[2010-11-07 14:58:38,329][openerp] ERROR:Magento Call:[07]: Release:	10.10
[2010-11-07 14:58:38,329][openerp] ERROR:Magento Call:[08]: Codename:	maverick
[2010-11-07 14:58:38,329][openerp] ERROR:Magento Call:[09]: Operating System Release : 2.6.35-22-generic
[2010-11-07 14:58:38,329][openerp] ERROR:Magento Call:[10]: Operating System Version : #35-Ubuntu SMP Sat Oct 16 20:36:48 UTC 2010
[2010-11-07 14:58:38,330][openerp] ERROR:Magento Call:[11]: Operating System Architecture : 32bit
[2010-11-07 14:58:38,330][openerp] ERROR:Magento Call:[12]: Operating System Locale : en_US.UTF8
[2010-11-07 14:58:38,330][openerp] ERROR:Magento Call:[13]: Python Version : 2.6.6
[2010-11-07 14:58:38,331][openerp] ERROR:Magento Call:[14]: OpenERP-Server Version : 5.0.14
[2010-11-07 14:58:38,331][openerp] ERROR:Magento Call:[15]: Last revision No. & ID : 
[2010-11-07 14:58:38,331][openerp] ERROR:Magento Call:[16]: Method: catalog_product.list
[2010-11-07 14:58:38,331][openerp] ERROR:Magento Call:[17]: Arguments:[]
[2010-11-07 14:58:38,332][openerp] ERROR:Magento Call:[18]: Error:ResponseError()
[2010-11-07 14:58:38,335][openerp] WARNING:Magento Call:Webservice Failure, sleeping 6 second before next attempt
[2010-11-07 14:58:44,461][openerp] ERROR:web-services:[01]: 
[2010-11-07 14:58:44,462][openerp] ERROR:web-services:[02]: Environment Information : 
[2010-11-07 14:58:44,462][openerp] ERROR:web-services:[03]: System : Linux-2.6.35-22-generic-i686-with-Ubuntu-10.10-maverick
[2010-11-07 14:58:44,462][openerp] ERROR:web-services:[04]: OS Name : posix
[2010-11-07 14:58:44,463][openerp] ERROR:web-services:[05]: Distributor ID:	Ubuntu
[2010-11-07 14:58:44,463][openerp] ERROR:web-services:[06]: Description:	Ubuntu 10.10
[2010-11-07 14:58:44,464][openerp] ERROR:web-services:[07]: Release:	10.10
[2010-11-07 14:58:44,464][openerp] ERROR:web-services:[08]: Codename:	maverick
[2010-11-07 14:58:44,464][openerp] ERROR:web-services:[09]: Operating System Release : 2.6.35-22-generic
[2010-11-07 14:58:44,464][openerp] ERROR:web-services:[10]: Operating System Version : #35-Ubuntu SMP Sat Oct 16 20:36:48 UTC 2010
[2010-11-07 14:58:44,465][openerp] ERROR:web-services:[11]: Operating System Architecture : 32bit
[2010-11-07 14:58:44,465][openerp] ERROR:web-services:[12]: Operating System Locale : en_US.UTF8
[2010-11-07 14:58:44,465][openerp] ERROR:web-services:[13]: Python Version : 2.6.6
[2010-11-07 14:58:44,466][openerp] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.14
[2010-11-07 14:58:44,466][openerp] ERROR:web-services:[15]: Last revision No. & ID : 
[2010-11-07 14:58:44,466][openerp] ERROR:web-services:[16]: Traceback (most recent call last):
[2010-11-07 14:58:44,466][openerp] ERROR:web-services:[17]:   File "/usr/share/pyshared/openerp-server/osv/osv.py", line 58, in wrapper
[2010-11-07 14:58:44,467][openerp] ERROR:web-services:[18]:     return f(self, dbname, *args, **kwargs)
[2010-11-07 14:58:44,467][openerp] ERROR:web-services:[19]:   File "/usr/share/pyshared/openerp-server/osv/osv.py", line 119, in execute
[2010-11-07 14:58:44,467][openerp] ERROR:web-services:[20]:     res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2010-11-07 14:58:44,467][openerp] ERROR:web-services:[21]:   File "/usr/share/pyshared/openerp-server/osv/osv.py", line 111, in execute_cr
[2010-11-07 14:58:44,468][openerp] ERROR:web-services:[22]:     return getattr(object, method)(cr, uid, *args, **kw)
[2010-11-07 14:58:44,468][openerp] ERROR:web-services:[23]:   File "/usr/share/pyshared/openerp-server/addons/magentoerpconnect/magerp_core.py", line 137, in sync_products
[2010-11-07 14:58:44,468][openerp] ERROR:web-services:[24]:     list_prods = attr_conn.call('catalog_product.list')
[2010-11-07 14:58:44,468][openerp] ERROR:web-services:[25]:   File "/usr/share/pyshared/openerp-server/addons/magentoerpconnect/magerp_osv.py", line 53, in call
[2010-11-07 14:58:44,469][openerp] ERROR:web-services:[26]:     res = self.ser.call(self.session, method, arguments)
[2010-11-07 14:58:44,469][openerp] ERROR:web-services:[27]:   File "/usr/lib/python2.6/xmlrpclib.py", line 1199, in __call__
[2010-11-07 14:58:44,469][openerp] ERROR:web-services:[28]:     return self.__send(self.__name, args)
[2010-11-07 14:58:44,469][openerp] ERROR:web-services:[29]:   File "/usr/lib/python2.6/xmlrpclib.py", line 1490, in __request
[2010-11-07 14:58:44,469][openerp] ERROR:web-services:[30]:     verbose=self.__verbose
[2010-11-07 14:58:44,470][openerp] ERROR:web-services:[31]:   File "/usr/lib/python2.6/xmlrpclib.py", line 1253, in request
[2010-11-07 14:58:44,470][openerp] ERROR:web-services:[32]:     return self._parse_response(h.getfile(), sock)
[2010-11-07 14:58:44,470][openerp] ERROR:web-services:[33]:   File "/usr/lib/python2.6/xmlrpclib.py", line 1393, in _parse_response
[2010-11-07 14:58:44,470][openerp] ERROR:web-services:[34]:     return u.close()
[2010-11-07 14:58:44,471][openerp] ERROR:web-services:[35]:   File "/usr/lib/python2.6/xmlrpclib.py", line 836, in close
[2010-11-07 14:58:44,471][openerp] ERROR:web-services:[36]:     raise ResponseError()
[2010-11-07 14:58:44,471][openerp] ERROR:web-services:[37]: ResponseError: ResponseError()

-- 
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: Incomplete

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()