c2c-oerpscenario team mailing list archive

[hsm flxCore <659183@xxxxxxxxxxxxxxxxxx>]

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

Can this error report be related? Its the same ids2, although in another
module:

/home/openerp/OpenERP/5.0/server/bin/tools/misc.py:750: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
  if hasattr(e, 'message'):
/home/openerp/OpenERP/5.0/server/bin/tools/misc.py:751: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
  return ustr(e.message)
bzr: ERROR: Not a branch: "/home/openerp/".
No LSB modules are available.
[2010-10-26 11:11:55,194] ERROR:web-services:[01]: 
[2010-10-26 11:11:55,201] ERROR:web-services:[02]: Environment Information : 
[2010-10-26 11:11:55,202] ERROR:web-services:[03]: System : Linux-2.6.32-22-generic-x86_64-with-Ubuntu-10.04-lucid
[2010-10-26 11:11:55,202] ERROR:web-services:[04]: OS Name : posix
[2010-10-26 11:11:55,202] ERROR:web-services:[05]: Distributor ID:	Ubuntu
[2010-10-26 11:11:55,203] ERROR:web-services:[06]: Description:	Ubuntu 10.04 LTS
[2010-10-26 11:11:55,203] ERROR:web-services:[07]: Release:	10.04
[2010-10-26 11:11:55,203] ERROR:web-services:[08]: Codename:	lucid
[2010-10-26 11:11:55,203] ERROR:web-services:[09]: Operating System Release : 2.6.32-22-generic
[2010-10-26 11:11:55,204] ERROR:web-services:[10]: Operating System Version : #36-Ubuntu SMP Thu Jun 3 19:31:57 UTC 2010
[2010-10-26 11:11:55,204] ERROR:web-services:[11]: Operating System Architecture : 64bit
[2010-10-26 11:11:55,204] ERROR:web-services:[12]: Operating System Locale : en_US.UTF8
[2010-10-26 11:11:55,208] ERROR:web-services:[13]: Python Version : 2.6.5
[2010-10-26 11:11:55,208] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.11
[2010-10-26 11:11:55,209] ERROR:web-services:[15]: Last revision No. & ID : 
[2010-10-26 11:11:55,209] ERROR:web-services:[16]: Traceback (most recent call last):
[2010-10-26 11:11:55,209] ERROR:web-services:[17]:   File "/home/openerp/OpenERP/5.0/server/bin/osv/osv.py", line 58, in wrapper
[2010-10-26 11:11:55,210] ERROR:web-services:[18]:     return f(self, dbname, *args, **kwargs)
[2010-10-26 11:11:55,210] ERROR:web-services:[19]:   File "/home/openerp/OpenERP/5.0/server/bin/osv/osv.py", line 119, in execute
[2010-10-26 11:11:55,210] ERROR:web-services:[20]:     res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2010-10-26 11:11:55,211] ERROR:web-services:[21]:   File "/home/openerp/OpenERP/5.0/server/bin/osv/osv.py", line 111, in execute_cr
[2010-10-26 11:11:55,211] ERROR:web-services:[22]:     return getattr(object, method)(cr, uid, *args, **kw)
[2010-10-26 11:11:55,211] ERROR:web-services:[23]:   File "/home/openerp/OpenERP/5.0/server/bin/osv/orm.py", line 2228, in read
[2010-10-26 11:11:55,212] ERROR:web-services:[24]:     result = self._read_flat(cr, user, select, fields, context, load)
[2010-10-26 11:11:55,212] ERROR:web-services:[25]:   File "/home/openerp/OpenERP/5.0/server/bin/osv/orm.py", line 2360, in _read_flat
[2010-10-26 11:11:55,212] ERROR:web-services:[26]:     res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
[2010-10-26 11:11:55,212] ERROR:web-services:[27]:   File "/home/openerp/OpenERP/5.0/server/bin/osv/fields.py", line 659, in get
[2010-10-26 11:11:55,213] ERROR:web-services:[28]:     res = self._fnct(obj, cr, user, ids, name, self._arg, context)
[2010-10-26 11:11:55,213] ERROR:web-services:[29]:   File "/home/openerp/OpenERP/5.0/server/bin/addons/account_analytic_analysis/account_analytic_analysis.py", line 376, in _month
[2010-10-26 11:11:55,213] ERROR:web-services:[30]:     'WHERE account_id in (' + ','.join([str(x) for x in ids2]) + ') ' \
[2010-10-26 11:11:55,213] ERROR:web-services:[31]:   File "/home/openerp/OpenERP/5.0/server/bin/sql_db.py", line 77, in wrapper
[2010-10-26 11:11:55,213] ERROR:web-services:[32]:     return f(self, *args, **kwargs)
[2010-10-26 11:11:55,214] ERROR:web-services:[33]:   File "/home/openerp/OpenERP/5.0/server/bin/sql_db.py", line 122, in execute
[2010-10-26 11:11:55,214] ERROR:web-services:[34]:     res = self._obj.execute(query, params)
[2010-10-26 11:11:55,216] ERROR:web-services:[35]: DataError: integer out of range


Should I file this as another bug? Or is it a related error?

-- 
currency error in analytic account
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!