openerp-expert-production team mailing list archive

[Nhomar Hernández - http://openerp.netquatro.com <nhomar@xxxxxxxxx>]

Hello Stephane.

This is a good reason, let me try to backport it to Stable, and try on our
Productions enviroments, after this, we will push this new module on
stable-extra-5.0.

If you have some aditional information that you think is relevant, before
begin the work, This will be welcome!!!

Nhomar

2010/4/26 Stephane (Open ERP) <stw@xxxxxxxxxxx>

> Hi all,
>
> I asked to Jay to shift the bug to Trunk (6.0).
>
> Why ?
>
> 1. Currently, there is a limit with the accuracy in stable, but we can't
> fix in the current version. Because we risk to introduce new bugs and I want
> to avoid that.
> 2. There is a featured module in trunk (decimal_precision), someone can
> propose a backport to stable, but don't forget to change every modules of
> stable.
>
>
> Regards,
>
> Stephane
>
> --
> unit factor is limited to 5 zeros
> https://bugs.launchpad.net/bugs/511193
> You received this bug notification because you are subscribed to
> OpenObject.
>
> Status in OpenObject Addons Modules: Confirmed
> Status in OpenObject Addons 5.0 series: Won't Fix
> Status in OpenObject Addons trunk series: Confirmed
>
> 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-XP-5.1.2600-SP3
> 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/xabier/openerp-server/server/bin/netsvc.py", line 244, in
> dispatch
>    result = LocalService(service_name)(method, *params)
>  File "/home/xabier/openerp-server/server/bin/netsvc.py", line 73, in
> __call__
>    return getattr(self, method)(*params)
>  File
> "/home/xabier/openerp-server/server/bin/addons/base_module_record/base_module_record.py",
> line 38, in execute
>    res = super(recording_objects_proxy, self).execute(*args, **argv)
>  File "/home/xabier/openerp-server/server/bin/service/web_services.py",
> line 583, in execute
>    res = service.execute(db, uid, object, method, *args)
>  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 59, in
> wrapper
>    return f(self, dbname, *args, **kwargs)
>  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 118, in
> execute
>    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
>  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 110, in
> execute_cr
>    return getattr(object, method)(cr, uid, *args, **kw)
>  File "/home/xabier/openerp-server/server/bin/osv/orm.py", line 2458, in
> write
>    'where id in ('+ids_str+')', upd1)
>  File "/home/xabier/openerp-server/server/bin/sql_db.py", line 76, in
> wrapper
>    return f(self, *args, **kwargs)
>  File "/home/xabier/openerp-server/server/bin/sql_db.py", line 120, in
> execute
>    res = self._obj.execute(query, params)
> 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
>
>


** Changed in: openobject-addons/5.0
       Status: Won't Fix => In Progress

** Changed in: openobject-addons/5.0
     Assignee: (unassigned) => Nhomar Hernández - http://openerp.netquatro.com (nhomar)

-- 
unit factor is limited to 5 zeros
https://bugs.launchpad.net/bugs/511193
You received this bug notification because you are a member of OpenERP
Manufacturing Experts, which is a direct subscriber.

Status in OpenObject Addons Modules: Confirmed
Status in OpenObject Addons 5.0 series: In Progress
Status in OpenObject Addons trunk series: Confirmed

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-XP-5.1.2600-SP3
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/xabier/openerp-server/server/bin/netsvc.py", line 244, in dispatch
    result = LocalService(service_name)(method, *params)
  File "/home/xabier/openerp-server/server/bin/netsvc.py", line 73, in __call__
    return getattr(self, method)(*params)
  File "/home/xabier/openerp-server/server/bin/addons/base_module_record/base_module_record.py", line 38, in execute
    res = super(recording_objects_proxy, self).execute(*args, **argv)
  File "/home/xabier/openerp-server/server/bin/service/web_services.py", line 583, in execute
    res = service.execute(db, uid, object, method, *args)
  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 59, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 118, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/xabier/openerp-server/server/bin/osv/osv.py", line 110, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/xabier/openerp-server/server/bin/osv/orm.py", line 2458, in write
    'where id in ('+ids_str+')', upd1)
  File "/home/xabier/openerp-server/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/home/xabier/openerp-server/server/bin/sql_db.py", line 120, in execute
    res = self._obj.execute(query, params)
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