unexpected error while using base_synchro

Asked by ajiz on 2013-08-01

Hi,

I had already install the base_synchro that I had downloaded from here. But got this error when I want to synchronize the new partner that I had created.

Here is the error:

1)

Server Traceback (most recent call last):
  File "/opt/openerp/v7/web/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/v7/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/v7/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/v7/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/v7/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/v7/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/v7/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/v7/addons_bpooutfit/base_synchro/wizard/base_synchro.py", line 277, in upload_download_multi_thread
    threaded_synchronization.run()
  File "/usr/lib/python2.7/threading.py", line 763, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/opt/openerp/v7/addons_bpooutfit/base_synchro/wizard/base_synchro.py", line 245, in upload_download
    self.synchronize(cr, uid, server, object, context=context)
  File "/opt/openerp/v7/addons_bpooutfit/base_synchro/wizard/base_synchro.py", line 119, in synchronize
    value = pool_src.get(object.model_id.model).read(cr, uid, [id], fields)[0]
  File "/opt/openerp/v7/addons_bpooutfit/base_synchro/wizard/base_synchro.py", line 44, in <lambda>
    return lambda cr, uid, *args, **kwargs: self.rpc.execute(self.server.server_db, self.uid, self.server.password, self.ressource, name, *args)
  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 syntax error at or near ")"
LINE 5: AND l.partner_id IN ()
                                                   ^
: 'Traceback (most recent call last):\n File "/opt/openerp/v7/server/openerp/service/wsgi_server.py", line 82, in xmlrpc_return\n result = openerp.netsvc.dispatch_rpc(service, method, params)\n File "/opt/openerp/v7/server/openerp/netsvc.py", line 292, in dispatch_rpc\n result = ExportService.getService(service_name).dispatch(method, params)\n File "/opt/openerp/v7/server/openerp/service/web_services.py", line 626, in dispatch\n res = fn(db, uid, *params)\n File "/opt/openerp/v7/server/openerp/osv/osv.py", line 131, in wrapper\n return f(self, dbname, *args, **kwargs)\n File "/opt/openerp/v7/server/openerp/osv/osv.py", line 197, in execute\n res = self.execute_cr(cr, uid, obj, method, *args, **kw)\n File "/opt/openerp/v7/server/openerp/osv/osv.py", line 185, in execute_cr\n return getattr(object, method)(cr, uid, *args, **kw)\n File "/opt/openerp/v7/server/openerp/osv/orm.py", line 3604, in read\n result = self._read_flat(cr, user, select, fields, context, load)\n File "/opt/openerp/v7/server/openerp/osv/orm.py", line 3712, in _read_flat\n res2 = self._columns[val[0]].get(cr, self, ids, val, user, context=context, values=res)\n File "/opt/openerp/v7/server/openerp/osv/fields.py", line 1133, in get\n result = self._fnct(obj, cr, uid, ids, name, self._arg, context)\n File "/opt/openerp/v7/addons/account/partner.py", line 123, in _credit_debit_get\n (tuple(ids),))\n File "/opt/openerp/v7/server/openerp/sql_db.py", line 161, in wrapper\n return f(self, *args, **kwargs)\n File "/opt/openerp/v7/server/openerp/sql_db.py", line 226, in execute\n res = self._obj.execute(query, params)\nProgrammingError: syntax error at or near ")"\nLINE 5: AND l.partner_id IN ()\n ^\n\n'>

2)

Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 277, in upload_download_multi_thread
    threaded_synchronization.run()
  File "/usr/lib/python2.7/threading.py", line 504, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 245, in upload_download
    self.synchronize(cr, uid, server, object, context=context)
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 119, in synchronize
    value = pool_src.get(object.model_id.model).read(cr, uid, [id], fields)[0]
IndexError: list index out of range

3)

Server Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 277, in upload_download_multi_thread
    threaded_synchronization.run()
  File "/usr/lib/python2.7/threading.py", line 504, in run
    self.__target(*self.__args, **self.__kwargs)
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 245, in upload_download
    self.synchronize(cr, uid, server, object, context=context)
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 95, in synchronize
    {'action':'d'}
  File "/opt/openerp/server/openerp/addons/base_synchro/wizard/base_synchro.py", line 44, in <lambda>
    return lambda cr, uid, *args, **kwargs: self.rpc.execute(self.server.server_db, self.uid, self.server.password, self.ressource, name, *args)
  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 Invalid leaf name: 'Traceback (most recent call last):\n File "/opt/openerp/server/openerp/service/wsgi_server.py", line 82, in xmlrpc_return\n result = openerp.netsvc.dispatch_rpc(service, method, params)\n File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc\n result = ExportService.getService(service_name).dispatch(method, params)\n File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch\n res = fn(db, uid, *params)\n File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper\n return f(self, dbname, *args, **kwargs)\n File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute\n res = self.execute_cr(cr, uid, obj, method, *args, **kw)\n File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr\n return getattr(object, method)(cr, uid, *args, **kw)\n File "/opt/openerp/server/openerp/addons/base_synchro/base_synchro_obj.py", line 71, in get_ids\n return self._get_ids(cr, uid, object, dt, domain, context=context)\n File "/opt/openerp/server/openerp/addons/base_synchro/base_synchro_obj.py", line 80, in _get_ids\n ids = self.pool.get(object).search(cr, uid, domain2, context=context)\n File "/opt/openerp/server/openerp/osv/orm.py", line 2354, in search\n return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)\n File "/opt/openerp/server/openerp/osv/orm.py", line 4845, in _search\n query = self._where_calc(cr, user, args, context=context)\n File "/opt/openerp/server/openerp/osv/orm.py", line 4674, in _where_calc\n e = expression.expression(cr, user, domain, self, context)\n File "/opt/openerp/server/openerp/osv/expression.py", line 640, in __init__\n self.parse(cr, uid, context=context)\n File "/opt/openerp/server/openerp/osv/expression.py", line 740, in parse\n self.stack = [ExtendedLeaf(leaf, self.root_model) for leaf in self.expression]\n File "/opt/openerp/server/openerp/osv/expression.py", line 526, in __init__\n self.check_leaf()\n File "/opt/openerp/server/openerp/osv/expression.py", line 582, in check_leaf\n raise ValueError("Invalid leaf %s" % str(self.leaf))\nValueError: Invalid leaf name\n'>

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Addons (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
2013-08-19
Last reply:
2013-08-21

Hello Sir..

                    Give Me Further description of your occured error, because in my system it work perfectly.
                    Define the Process steps ,like How to do Synchronization Process and which process step you got error..

ajiz (sukrisupian8888) said : #2

Hi Vishal,

I got it working now. Thanks.

But I have some problems here.

Let's say I have 50 products from Server A.
Server B has 0 product.

When I use base_synchro to sync from Server A to Server B, it's successful but it only sync 3 - 5 products. If I try to sync again, sometimes I only get 1 product.

I tried this on the sales -> customers too, same issue.

Any idea what's wrong? Thanks.

Hi Ajiz,

            Your scenario works perfectly on my system, that synchronization of all the Product from server A to B,

You can see that video on http://www.youtube.com/watch?v=U-sNTEXX_c4

Thanks.

ajiz (sukrisupian8888) said : #5

Hi Vishal,

Thanks for the video. It works for you but weird, it didn't work for me.

In fact my friend also tested this, same issue with me.

Few questions:-

a. Which OpenERP 7 version are you using?

- the nightly version http://nightly.openerp.com/7.0/nightly/src/openerp-7.0-latest.tar.gz ?
- or download latest openerp codes via bzr way ?
- or download other codes?
- or is that the openerp 7 enterprise version?

b. For the base synchro shown in the video, is it the same one from this launchpad's repository? Or do you use a different version release?

c. Right now, the sync is more manual way. Is there a way to perform a schedule sync at a particular time e.g 2 a.m.?

d. Lastly Is it possible if you can share a test VirtualBox's VM, so I can test from my end? Maybe I can compare the difference from my end.

Any help? Thanks.

Ajiz,

The answers:

a. We always use developer mode, download latest openerp codes via bzr way.
b. Its the same code I have given : https://code.launchpad.net/~serpent-consulting-services/server-env-tools/7.0-base_synchro
c. We can set a scheduler for the same.
d. This will be difficult. You have to talk to the concern person of SerpentCS. Email to <email address hidden>

Thanks.

--
Vishal Jadav,
Jr. Software Developer
Serpent Consulting Services Pvt. Ltd.
Web : http://www.serpentcs.com

Can you help with this problem?

Provide an answer of your own, or ask ajiz for more information if necessary.

To post a message you must log in.