unit factor is limited to 5 zeros
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) | Status tracked in Trunk | |||||
5.0 |
Won't Fix
|
Undecided
|
Nhomar - Vauxoo | |||
Trunk |
Fix Released
|
Medium
|
OpenERP R&D Addons Team 2 |
Bug Description
I have got a category measure unit size.
The master unit is meter, but I need having m2, m3 and related measure units like mm, mm2, mm3, micrometer
so 1m = 1000mm
but 1m = 1000000micrometer
If I try including a conversion factor where I need more than 5 zeros, system crashes showing this error:
Environment Information :
System : Windows-
OS Name : nt
Operating System Release : XP
Operating System Version : 5.1.2600
Operating System Architecture : 32bit
Operating System Locale : es_ES.cp1252
Python Version : 2.5.2
OpenERP-Client Version : 5.0.6
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "/home/
result = LocalService(
File "/home/
return getattr(self, method)(*params)
File "/home/
res = super(recording
File "/home/
res = service.execute(db, uid, object, method, *args)
File "/home/
return f(self, dbname, *args, **kwargs)
File "/home/
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/
return getattr(object, method)(cr, uid, *args, **kw)
File "/home/
'where id in ('+ids_str+')', upd1)
File "/home/
return f(self, *args, **kwargs)
File "/home/
res = self._obj.
ProgrammingError: numeric field overflow
DETAIL: A field with precision 12, scale 6 must round to an absolute value less than 10^6.
This is limiting the possibility of having all posible and needed conversion factors on measure units, so I think it could be considered a bug or maybe wishlist
Thank you!!
Ana
Related branches
- OpenERP Core Team: Pending requested
-
Diff: 12 lines (+1/-1)1 file modifiedstock/stock_view.xml (+1/-1)
Changed in openobject-addons: | |
status: | Invalid → Incomplete |
Changed in openobject-addons: | |
milestone: | 5.0.8 → 5.0.9 |
Changed in openobject-addons: | |
milestone: | 5.0.9 → 5.0.10 |
Hello Ana.
The bug is happend to me too!!!!, only I want to add some comentary:
mm2, mm3 CAN NOT be ralated with mm or micrometer (symbol is called Miú)
because the first one is Area Units and the second one are Volume Units, for
this reason you must not relate this units, at least you want to make
calculation between them...... Area*Length is Volume etc....
Thanks
2010/1/22 Ana Juaristi Olalde <email address hidden>
> Public bug reported: XP-5.1. 2600-SP3 xabier/ openerp- server/ server/ bin/netsvc. py", line 244, in service_ name)(method, *params) xabier/ openerp- server/ server/ bin/netsvc. py", line 73, in xabier/ openerp- server/ server/ bin/addons/ base_module_ record/ base_module_ record. py", _objects_ proxy, self).execute( *args, **argv) xabier/ openerp- server/ server/ bin/service/ web_services. py", xabier/ openerp- server/ server/ bin/osv/ osv.py" , line 59, in xabier/ openerp- server/ server/ bin/osv/ osv.py" , line 118, in xabier/ openerp- server/ server/ bin/osv/ osv.py" , line 110, in xabier/ openerp- server/ server/ bin/osv/ orm.py" , line 2458, in xabier/ openerp- server/ server/ bin/sql_ db.py", line 76, in xabier/ openerp- server/ server/ bin/sql_ db.py", line 120, in execute( query, params) /bugs.launchpad .net/bugs/ 511193
>
> I have got a category measure unit size.
>
> The master unit is meter, but I need having m2, m3 and related measure
> units like mm, mm2, mm3, micrometer
>
> so 1m = 1000mm
> but 1m = 1000000micrometer
>
> If I try including a conversion factor where I need more than 5 zeros,
> system crashes showing this error:
>
> Environment Information :
> System : Windows-
> OS Name : nt
> Operating System Release : XP
> Operating System Version : 5.1.2600
> Operating System Architecture : 32bit
> Operating System Locale : es_ES.cp1252
> Python Version : 2.5.2
> OpenERP-Client Version : 5.0.6
> Last revision No. & ID :Bazaar Package not Found !Traceback (most recent
> call last):
> File "/home/
> dispatch
> result = LocalService(
> File "/home/
> __call__
> return getattr(self, method)(*params)
> File
> "/home/
> line 38, in execute
> res = super(recording
> File "/home/
> line 583, in execute
> res = service.execute(db, uid, object, method, *args)
> File "/home/
> wrapper
> return f(self, dbname, *args, **kwargs)
> File "/home/
> execute
> res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
> File "/home/
> execute_cr
> return getattr(object, method)(cr, uid, *args, **kw)
> File "/home/
> write
> 'where id in ('+ids_str+')', upd1)
> File "/home/
> wrapper
> return f(self, *args, **kwargs)
> File "/home/
> execute
> res = self._obj.
> ProgrammingError: numeric field overflow
> DETAIL: A field with precision 12, scale 6 must round to an absolute value
> less than 10^6.
>
> This is limiting the possibility of having all posible and needed
> conversion factors on measure units, so I think it could be considered a bug
> or maybe wishlist
>
> Thank you!!
>
> Ana
>
> ** Affects: openobject-addons
> Importance: Undecided
> Status: New
>
> --
> unit factor is limited to 5 zeros
> https:/
> You received this bug notification because you are subscribed to
> OpenObject.
>
> Status in OpenObject Addons Modules: New
>
> Bug description:
> I...