Questo sito utilizza cookie per le proprie funzionalità e per inviarti pubblicità e servizi in linea con le tue preferenze. Chiudendo questo banner, scorrendo questa pagina o cliccando qualunque suo elemento acconsenti all’uso dei cookie.

Accedendo al link http://www.odoo-italia.org/index.php/home/cookie-policy puoi leggere in dettaglio le modalità di trattamento dei cookie da parte dell'Associazione Odoo Italia.

Benvenuto, Ospite
Nome utente: Password: Ricordami
  • Pagina:
  • 1
  • 2

ARGOMENTO: Errore approvvigionamento articolo di produzione

Errore approvvigionamento articolo di produzione 6 Anni 2 Mesi fa #9271

  • alex_cam
  • Avatar di alex_cam
  • Offline
  • Expert Boarder
  • Messaggi: 153
  • Ringraziamenti ricevuti 2
  • Karma: 1
Ogni volta che provo a creare una richiesta di approvvigionamento per un articolo definito
con "produrre" (anzichè comprare), ricevo il seguente errore
Client Traceback (most recent call last):
File "/Users/alex/openerp/web/addons/web/common/http.py", line 180, in dispatch
response["result"] = method(controller, self, **self.params)
File "/Users/alex/openerp/web/addons/web/controllers/main.py", line 1052, in call_button
action = self.call_common(req, model, method, args, domain_id, context_id)
File "/Users/alex/openerp/web/addons/web/controllers/main.py", line 996, in call_common
return self._call_kw(req, model, method, args, {})
File "/Users/alex/openerp/web/addons/web/controllers/main.py", line 1010, in _call_kw
return getattr(req.session.model(model), method)(*args, **kwargs)
File "/Users/alex/openerp/web/addons/web/common/openerplib/main.py", line 250, in proxy
args, kw)
File "/Users/alex/openerp/web/addons/web/common/openerplib/main.py", line 117, in proxy
result = self.connector.send(self.service_name, method, *args)
File "/Users/alex/openerp/web/addons/web/common/http.py", line 608, in send
raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)


Server Traceback (most recent call last):
File "/Users/alex/openerp/web/addons/web/common/http.py", line 593, in send
return openerp.netsvc.dispatch_rpc(service_name, method, args)
File "/Users/alex/openerp/server/openerp/netsvc.py", line 360, in dispatch_rpc
result = ExportService.getService(service_name).dispatch(method, params)
File "/Users/alex/openerp/server/openerp/service/web_services.py", line 586, in dispatch
res = fn(db, uid, *params)
File "/Users/alex/openerp/server/openerp/osv/osv.py", line 167, in execute_kw
return self.execute(db, uid, obj, method, *args, **kw or {})
File "/Users/alex/openerp/server/openerp/osv/osv.py", line 121, in wrapper
return f(self, dbname, *args, **kwargs)
File "/Users/alex/openerp/server/openerp/osv/osv.py", line 176, in execute
res = self.execute_cr(cr, uid, obj, method, *args, **kw)
File "/Users/alex/openerp/server/openerp/osv/osv.py", line 164, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/Users/alex/openerp/addons/procurement/wizard/make_procurement_product.py", line 82, in make_procurement
wf_service.trg_validate(uid, 'procurement.order', procure_id, 'button_confirm', cr)
File "/Users/alex/openerp/server/openerp/workflow/wkf_service.py", line 124, in trg_validate
res2 = instance.validate(cr, id, ident, signal)
File "/Users/alex/openerp/server/openerp/workflow/instance.py", line 48, in validate
workitem.process(cr, witem, ident, signal, force_running, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 53, in process
result = _execute(cr, workitem, activity, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 128, in _execute
id_new = wkf_expr.execute(cr, ident, workitem, activity)
File "/Users/alex/openerp/server/openerp/workflow/wkf_expr.py", line 68, in execute
return _eval_expr(cr, ident, workitem, activity)
File "/Users/alex/openerp/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
ret = eval(line, env, nocopy=True)
File "/Users/alex/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval
return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
File "", line 1, in <module>
File "/Users/alex/openerp/server/openerp/osv/orm.py", line 368, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/Users/alex/openerp/addons/mrp/procurement.py", line 66, in action_produce_assign_product
res = procurement_obj.make_mo(cr, uid, ids, context=context)
File "/Users/alex/openerp/addons/mrp/procurement.py", line 102, in make_mo
wf_service.trg_validate(uid, 'mrp.production', produce_id, 'button_confirm', cr)
File "/Users/alex/openerp/server/openerp/workflow/wkf_service.py", line 124, in trg_validate
res2 = instance.validate(cr, id, ident, signal)
File "/Users/alex/openerp/server/openerp/workflow/instance.py", line 48, in validate
workitem.process(cr, witem, ident, signal, force_running, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 53, in process
result = _execute(cr, workitem, activity, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 128, in _execute
id_new = wkf_expr.execute(cr, ident, workitem, activity)
File "/Users/alex/openerp/server/openerp/workflow/wkf_expr.py", line 68, in execute
return _eval_expr(cr, ident, workitem, activity)
File "/Users/alex/openerp/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
ret = eval(line, env, nocopy=True)
File "/Users/alex/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval
return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
File "", line 1, in <module>
File "/Users/alex/openerp/server/openerp/osv/orm.py", line 368, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/Users/alex/openerp/addons/mrp/mrp.py", line 997, in action_confirm
self._make_production_line_procurement(cr, uid, line, shipment_move_id, context=context)
File "/Users/alex/openerp/addons/mrp/mrp.py", line 865, in _make_production_line_procurement
wf_service.trg_validate(uid, procurement_order._name, procurement_id, 'button_confirm', cr)
File "/Users/alex/openerp/server/openerp/workflow/wkf_service.py", line 124, in trg_validate
res2 = instance.validate(cr, id, ident, signal)
File "/Users/alex/openerp/server/openerp/workflow/instance.py", line 48, in validate
workitem.process(cr, witem, ident, signal, force_running, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 176, in _split_test
_join_test(cr, t[0], t[1], ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 184, in _join_test
create(cr,[activity], inst_id, ident, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 41, in create
process(cr, res, ident, stack=stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 61, in process
ok = _split_test(cr, workitem, activity, ident, signal, stack)
File "/Users/alex/openerp/server/openerp/workflow/workitem.py", line 158, in _split_test
if wkf_expr.check(cr, workitem, ident, transition,signal):
File "/Users/alex/openerp/server/openerp/workflow/wkf_expr.py", line 81, in check
return _eval_expr(cr, ident, workitem, transition)
File "/Users/alex/openerp/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
ret = eval(line, env, nocopy=True)
File "/Users/alex/openerp/server/openerp/tools/safe_eval.py", line 241, in safe_eval
return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
File "", line 1, in <module>
File "/Users/alex/openerp/server/openerp/osv/orm.py", line 368, in function_proxy
return attr(self._cr, self._uid, [self._id], *args, **kwargs)
File "/Users/alex/openerp/addons/procurement/procurement.py", line 255, in check_make_to_stock
ok = ok and self._check_make_to_stock_product(cr, uid, procurement, context)
File "/Users/alex/openerp/addons/procurement/procurement.py", line 387, in _check_make_to_stock_product
cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
File "/Users/alex/openerp/server/openerp/sql_db.py", line 152, in wrapper
return f(self, *args, **kwargs)
File "/Users/alex/openerp/server/openerp/sql_db.py", line 212, in execute
res = self._obj.execute(query, params)
DataError: value too long for type character varying(64)

Sapete da cosa può dipendere?
Grazie mille
Alessandro Camilli
www.openforce.it
L\'Amministratore ha disattivato l\'accesso in scrittura al pubblico.

Re:Errore approvvigionamento articolo di produzione 6 Anni 2 Mesi fa #9272

  • enlightx
  • Avatar di enlightx
  • Online
  • Platinum Boarder
  • Messaggi: 6064
  • Ringraziamenti ricevuti 638
  • Karma: 85
alex_cam ha scritto:
DataError: value too long for type character varying(64)

c'è qualcosa che ad occhio potrebbe essere + lungo di 64 caratteri?
Davide Corio
Odoo Solution Architect
email: Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
web: www.davidecorio.com
L\'Amministratore ha disattivato l\'accesso in scrittura al pubblico.

Re:Errore approvvigionamento articolo di produzione 6 Anni 2 Mesi fa #9273

  • alex_cam
  • Avatar di alex_cam
  • Offline
  • Expert Boarder
  • Messaggi: 153
  • Ringraziamenti ricevuti 2
  • Karma: 1
No.
Si tratta di un prodotto che ha in distinta base 2 componenti:
0,5 kg di A
0,5 kg di B

In più c'è anche un routing impostato (però non penso sia questo il problema perchè da errore
anche togliendolo)
Alessandro Camilli
www.openforce.it
L\'Amministratore ha disattivato l\'accesso in scrittura al pubblico.

Re:Errore approvvigionamento articolo di produzione 6 Anni 2 Mesi fa #9274

  • enlightx
  • Avatar di enlightx
  • Online
  • Platinum Boarder
  • Messaggi: 6064
  • Ringraziamenti ricevuti 638
  • Karma: 85
potrebbe essere che qualche nome calcolato come quello degli ordini di approvvigionamento e produzione o cose simili, si allunga fino a superare i 64 caratteri.

chiaramente un baco
Davide Corio
Odoo Solution Architect
email: Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
web: www.davidecorio.com
L\'Amministratore ha disattivato l\'accesso in scrittura al pubblico.

Re:Errore approvvigionamento articolo di produzione 6 Anni 2 Mesi fa #9275

  • enlightx
  • Avatar di enlightx
  • Online
  • Platinum Boarder
  • Messaggi: 6064
  • Ringraziamenti ricevuti 638
  • Karma: 85
anzi:
cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))

probabilmente il campo message
Davide Corio
Odoo Solution Architect
email: Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
web: www.davidecorio.com
L\'Amministratore ha disattivato l\'accesso in scrittura al pubblico.

Re:Errore approvvigionamento articolo di produzione 6 Anni 2 Mesi fa #9283

  • alex_cam
  • Avatar di alex_cam
  • Offline
  • Expert Boarder
  • Messaggi: 153
  • Ringraziamenti ricevuti 2
  • Karma: 1
Grazie mille.
In effetti era un bug.

Ho risolto con questa modifica:
### cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
cr.execute('update procurement_order set message=%s where id=%s', (message[:64], procurement.id))

Cosa si fa in questi casi? Si apre un ticket?
Alessandro Camilli
www.openforce.it
L\'Amministratore ha disattivato l\'accesso in scrittura al pubblico.
  • Pagina:
  • 1
  • 2
Tempo creazione pagina: 0.173 secondi

Odoo Italia Associazione - C.F: 94200470485 - Sede: Viale dei Cadorna, 83 - Firenze - Italy

Protected by R Antispam