c2c-oerpscenario team mailing list archive

[hsm flxCore <659183@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 592005 ***
    https://bugs.launchpad.net/bugs/592005

We found out that the problem was indeed in the account analytic analysis module. It tries to find month summaries. By the way, this has a huge performance impact. Even when displaying a tree of account analytic accounts, all month summaries are calculated (so it seems).
But that's worth another topic.

** Summary changed:

- currency error in analytic account
+ currency error in analytic account (solved)

-- 
currency error in analytic account (solved)
https://bugs.launchpad.net/bugs/659183
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Addons Modules: New

Bug description:
I have a problem with 3 machines (at least):
M1: oerpserver 5.0.11 (local instance)
M2: oerpserver 5.0.11 (development server)
M3: oerpserver 5.0.14 (local instance)

1. On M3 I import data (using spreadsheet). 
2. I backup the database (using Postgres dump)
3. On M1 I restore the database (using Postgres restore)
4  On M2 I restore the database (using Postgres restore)

Now, on M1 things work as expected. However, on M2 I get an error when displaying an account.analytic.account tree that contains a balance column.

I get the following error:

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 247, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/usr/lib/python2.5/site-packages/openerp-server/netsvc.py", line 76, in __call__
    return getattr(self, method)(*params)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/base_module_record/base_module_record.py", line 38, in execute
    res = super(recording_objects_proxy, self).execute(*args, **argv)
  File "/usr/lib/python2.5/site-packages/openerp-server/service/web_services.py", line 577, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 58, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 119, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 111, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2228, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/orm.py", line 2360, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/usr/lib/python2.5/site-packages/openerp-server/osv/fields.py", line 659, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
  File "/usr/lib/python2.5/site-packages/openerp-server/addons/account/project/project.py", line 133, in _balance_calc
    if  currency[child]<>currency[id]:
KeyError: 103



The most obvious reason would be that M3 handles things differently (for example the import of data). But the M1 machine still works.. 
Furthermore the M2 machine works correctly without the imported data (clean install with same set of modules).

Maybe you have an idea what may be the reason, and why it is so specific.

Thanks in advance!