openerp-connector-community team mailing list archive

[Guewen Baconnier <guewen.baconnier@xxxxxxxxxxxxxx>]

On Mon, Oct 19, 2015 at 11:50 AM, Tero Juola <tjuola@xxxxxx> wrote:

> I notice that if a product has about twenty attributes (simple) the
> connector can not import it:
>
> openerp.addons.magentoerpconnect.unit.import_synchronizer.import_record('magento.product.product',
> 1, 2351)
>
> Traceback (most recent call last): File
> "/opt/bitnami/apps/magentoconnector/connector/connector/queue/worker.py",
> line 124, in run_job job.perform(session) File
> "/opt/bitnami/apps/magentoconnector/connector/connector/queue/job.py", line
> 467, in perform self.result = self.func(session, *self.args, **self.kwargs)
> File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py",
> line 379, in import_record importer.run(magento_id, force=force) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py",
> line 197, in run self.magento_record = self._get_magento_data() File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/import_synchronizer.py",
> line 61, in _get_magento_data return
> self.backend_adapter.read(self.magento_id) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/product.py",
> line 245, in read [int(id), storeview_id, attributes, 'id']) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/product.py",
> line 210, in _call return super(ProductProductAdapter, self)._call(method,
> arguments) File
> "/opt/bitnami/apps/magentoconnector/connector-magento/magentoerpconnect/unit/backend_adapter.py",
> line 168, in _call result = api.call(method, arguments) File
> "/opt/bitnami/python/lib/python2.7/site-packages/magento/api.py", line 159,
> in call return self.client.call(self.session, resource_path, arguments)
> File "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1233, in
> __call__ return self.__send(self.__name, args) File
> "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1591, in __request
> verbose=self.__verbose File
> "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1273, in request
> return self.single_request(host, handler, request_body, verbose) File
> "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1306, in
> single_request return self.parse_response(response) File
> "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 1476, in
> parse_response p.feed(data) File
> "/opt/bitnami/python/lib/python2.7/xmlrpclib.py", line 558, in feed
> self._parser.Parse(data, 0) ExpatError: not well-formed (invalid token):
> line 7, column 1111
>
>
>
> I don't think this error is related to the number of attributes. We have
> Magento instances with hundreds of attributes.
> This stacktrace means that the XML Odoo receives from Magento is not
> well-formed, usually it means that Magento had an error and sent back
> garbage.
> You should investigate the Magento logs for this error.
>
>
>
There are 5775 failed jobs in queue. Is there a quick way to clean this?
>

You can interact with them with SQL queries directly in Postgresql (UPDATE
queue_job SET state = 'pending' WHERE state = 'failed') or use the the
requeue jobs wizard. You can also set the state to 'done' if you want to
"skip" the jobs, but beware because you could then miss synchronization
updates.

>
> Tero
>