ARGOMENTO: unita' di misura differente

Buongiorno a tutti, da un paio di giorni ho notato che il pianificatore non generava richieste, oggi andando in debug mi sono trovato questo errore, che da quello che ho capito deve essere dovuto a qualche prodotto corrotto, con due unita' di misura differenti o non appartenenti alla stessa categoria. Per risolvere il problema ho pensato che bisognerebbe agire da database direttamente, ma non ho idea di quale sia la tabella dove possa essersi creata questa errata assegnazione, infatti mi dice che:

u'Error!', u'Conversione da UoM Prodotto Unit(s) a UoM Default m non possibile siccome appartengono a categorie differenti!'

allego il log. Ma per quale motivo il sistema dovrebbe tentare di cambiare l'unita' di misura da unita' a metri?

Grazie a tutti per la disponibilita'


2014-07-01 07:53:15,300 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:17,754 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:17,872 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:17,990 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,109 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,229 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,353 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,475 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,597 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,721 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,846 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:18,971 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:19,098 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:19,224 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:19,353 14694 WARNING emervolsrl openerp.osv.orm: No such field(s) in model procurement.order: sale_line_id.
2014-07-01 07:53:20,795 14694 ERROR emervolsrl openerp.tools.safe_eval: Cannot eval u'action_po_assign()'
Traceback (most recent call last):
File "/opt/openerp/lp/openerp/openerp/tools/safe_eval.py", line 285, in safe_eval
return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
File "", line 1, in <module>
File "/opt/openerp/lp/openerp/openerp/osv/orm.py", line 377, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/openerp/openerp/openerp/addons/purchase/purchase.py", line 1090, in action_po_assign
res = self.make_po(cr, uid, ids, context=context)
File "/openerp/openerp/openerp/addons/purchase_requisition/purchase_requisition.py", line 295, in make_po
res.update(super(procurement_order, self).make_po(cr, uid, non_requisition, context=context))
File "/openerp/openerp/openerp/addons/purchase/purchase.py", line 1189, in make_po
qty = uom_obj._compute_qty(cr, uid, procurement.product_uom.id, procurement.product_qty, uom_id)
File "/openerp/openerp/openerp/addons/product/product.py", line 169, in _compute_qty
return self._compute_qty_obj(cr, uid, from_unit, qty, to_unit)
File "/openerp/openerp/openerp/addons/product/product.py", line 176, in _compute_qty_obj
raise osv.except_osv(_('Error!'), _('Conversion from Product UoM %s to Default UoM %s is not possible as they both belong to different Category!.') % (from_unit.name,to_unit.name,))
except_osv: (u'Error!', u'Conversione da UoM Prodotto Unit(s) a UoM Default m non possibile siccome appartengono a categorie differenti!')
Exception in thread Thread-72:
Traceback (most recent call last):
File "/usr/lib/python2.7/threading.py", line 551, in __bootstrap_inner
self.run()
File "/usr/lib/python2.7/threading.py", line 504, in run
self.__target(*self.__args, **self.__kwargs)
File "/openerp/openerp/openerp/addons/procurement/wizard/schedulers_all.py", line 52, in _procure_calculation_all
context=context)
File "/openerp/openerp/openerp/addons/procurement/schedulers.py", line 41, in run_scheduler
self._procure_confirm(cr, uid, use_new_cursor=use_new_cursor, context=context)
File "/openerp/openerp/openerp/addons/procurement/schedulers.py", line 83, in _procure_confirm
wf_service.trg_validate(uid, 'procurement.order', proc.id, 'button_check', cr)
File "/opt/openerp/lp/openerp/openerp/workflow/wkf_service.py", line 119, in trg_validate
res2 = instance.validate(cr, id, ident, signal)
File "/opt/openerp/lp/openerp/openerp/workflow/instance.py", line 43, in validate
workitem.process(cr, witem, ident, signal, force_running, stack=stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 60, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 175, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 183, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 40, in create
process(cr, res, ident, stack=stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 60, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 175, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 183, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 40, in create
process(cr, res, ident, stack=stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 60, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 175, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 183, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 40, in create
process(cr, res, ident, stack=stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 52, in process
result = _execute(cr, workitem, activity, ident, stack)
File "/opt/openerp/lp/openerp/openerp/workflow/workitem.py", line 127, in _execute
id_new = wkf_expr.execute(cr, ident, workitem, activity)
File "/opt/openerp/lp/openerp/openerp/workflow/wkf_expr.py", line 67, in execute
return _eval_expr(cr, ident, workitem, activity)
File "/opt/openerp/lp/openerp/openerp/workflow/wkf_expr.py", line 57, in _eval_expr
ret = eval(line, env, nocopy=True)
File "/opt/openerp/lp/openerp/openerp/tools/safe_eval.py", line 285, in safe_eval
return eval(test_expr(expr, _SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
File "", line 1, in <module>
File "/opt/openerp/lp/openerp/openerp/osv/orm.py", line 377, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/openerp/openerp/openerp/addons/purchase/purchase.py", line 1090, in action_po_assign
res = self.make_po(cr, uid, ids, context=context)
File "/openerp/openerp/openerp/addons/purchase_requisition/purchase_requisition.py", line 295, in make_po
res.update(super(procurement_order, self).make_po(cr, uid, non_requisition, context=context))
File "/openerp/openerp/openerp/addons/purchase/purchase.py", line 1189, in make_po
qty = uom_obj._compute_qty(cr, uid, procurement.product_uom.id, procurement.product_qty, uom_id)
File "/openerp/openerp/openerp/addons/product/product.py", line 169, in _compute_qty
return self._compute_qty_obj(cr, uid, from_unit, qty, to_unit)
File "/openerp/openerp/openerp/addons/product/product.py", line 176, in _compute_qty_obj
raise osv.except_osv(_('Error!'), _('Conversion from Product UoM %s to Default UoM %s is not possible as they both belong to different Category!.') % (from_unit.name,to_unit.name,))
except_osv: (u'Error!', u'Conversione da UoM Prodotto Unit(s) a UoM Default m non possibile siccome appartengono a categorie differenti!')

2014-07-01 07:53:20,846 14694 WARNING emervolsrl openerp.sql_db: Cursor not closed explicitly
Please enable sql debugging to trace the caller.

papz ha scritto:
che versione stai usando?
quel sale_line_id mi pare sia una cosa specifica di trunk

Ciao Davide, sul sever di produzione ho una 7.0. Ho controllato in product_template nel database e non ho trovato nessun prodotto con uom_id diverso da uom_po_id, devo guardare altrove?

ti sta dicendo che la categoria di uom e uom_po sono diverse e non che uom e uom_po sono diversi.

magari hai uno o più uom e uom_po con lo stesso nome e quindi non noti la differenza.

mi è già capitato con alcuni clienti. uom duplicate per errore

Ok, ho controllato

in product_uom
1;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"reference";1;"Unit(s)";1.00;1.000000000000;TRUE
2;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"bigger";1;"Dozen(s)";0.01;0.083333333333;TRUE
3;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"reference";2;"kg";0.01;1.000000000000;TRUE
4;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"smaller";2;"g";0.01;1000.000000000000;TRUE
5;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"smaller";3;"Hour(s)";0.01;8.000000000000;TRUE
6;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"reference";3;"Day(s)";0.01;1.000000000000;TRUE
7;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"bigger";2;"t";0.01;0.001000000000;TRUE
8;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"reference";4;"m";0.01;1.000000000000;TRUE
9;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"bigger";4;"km";0.01;0.001000000000;TRUE
10;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"smaller";4;"cm";0.01;100.000000000000;TRUE
11;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"reference";5;"Liter(s)";0.01;1.000000000000;TRUE

in product_uom_categ
1;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"Unit"
2;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"Weight"
3;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"Working Time"
4;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"Length / Distance"
5;1;"2013-09-09 16:08:41.101371";"2013-09-09 16:08:41.101371";1;"Volume"

dovrei trovarmi voci duplicate suppongo in una di queste due tabelle, ma non ne vedo, ce n'e' una specifica dove e' indicata la categoria di uom_po?

Ho notato che avviando il server, quando questo carica i moduli, la riga dove è dichiarata la quantita' dei moduli e' duplicata:

2014-07-01 10:58:09,344 4733 INFO ? openerp: OpenERP version 7.0
2014-07-01 10:58:09,344 4733 INFO ? openerp: addons paths: /openerp/openerp/openerp/addons
2014-07-01 10:58:09,344 4733 INFO ? openerp: database hostname: localhost
2014-07-01 10:58:09,344 4733 INFO ? openerp: database port: 5432
2014-07-01 10:58:09,344 4733 INFO ? openerp: database user: openerp
2014-07-01 10:58:11,446 4733 INFO ? openerp.addons.google_docs.google_docs: GData lib version `%s GData-Python/2.0.18` detected
2014-07-01 10:58:12,437 4733 INFO ? openerp.service.wsgi_server: HTTP service (werkzeug) running on 0.0.0.0:8069
2014-07-01 10:58:12,449 4733 INFO emervolsrl openerp.modules.loading: loading 1 modules...
2014-07-01 10:58:12,676 4733 INFO emervolsrl openerp.modules.loading: loading 84 modules...
2014-07-01 10:58:13,383 4733 INFO emervolsrl openerp.modules.loading: Modules loaded.
2014-07-01 10:58:13,411 4733 INFO emervolsrl openerp: OpenERP server is running, waiting for connections...

Puo' essere un problema derivato o e' una cosa normale, non mi era mai capitato, se non durante l'installazione di un modulo nuovo.