Expected singleton: product.pricelist(2, 1)

[amoradel]

Hola,

Muchas gracias por este conector de ODOO a Power Bi.

Estoy tratando de consultar del modelo de ventas sale.order, pero me esta dando el siguiente error:

Odoo Server Error: Expected singleton: product.pricelist(2, 1)
Detalles:
    Traceback (most recent call last):
  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/home/odoo/src/odoo/odoo/http.py", line 683, in dispatch
    result = self._call_function(**self.params)
  File "/home/odoo/src/odoo/odoo/http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/odoo/src/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/odoo/src/odoo/odoo/http.py", line 347, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/odoo/src/odoo/odoo/http.py", line 912, in __call__
    return self.method(*args, **kw)
  File "/home/odoo/src/odoo/odoo/http.py", line 531, in response_wrap
    response = f(*args, **kw)
  File "/home/odoo/src/odoo/odoo/addons/base/controllers/rpc.py", line 96, in jsonrpc
    return dispatch_rpc(service, method, args)
  File "/home/odoo/src/odoo/odoo/http.py", line 140, in dispatch_rpc
    result = dispatch(method, params)
  File "/home/odoo/src/odoo/odoo/service/model.py", line 41, in dispatch
    res = fn(db, uid, *params)
  File "/home/odoo/src/odoo/odoo/service/model.py", line 168, in execute_kw
    return execute(db, uid, obj, method, *args, **kw or {})
  File "/home/odoo/src/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/odoo/src/odoo/odoo/service/model.py", line 175, in execute
    res = execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/odoo/src/odoo/odoo/service/model.py", line 159, in execute_cr
    result = odoo.api.call_kw(recs, method, args, kw)
  File "/home/odoo/src/odoo/odoo/api.py", line 395, in call_kw
    result = _call_kw_model(method, model, args, kwargs)
  File "/home/odoo/src/odoo/odoo/api.py", line 368, in _call_kw_model
    result = method(recs, *args, **kwargs)
  File "/home/odoo/src/odoo/odoo/models.py", line 4867, in search_read
    result = records.read(fields)
  File "/home/odoo/src/odoo/odoo/models.py", line 3022, in read
    return self._read_format(fnames=fields, load=load)
  File "/home/odoo/src/odoo/odoo/models.py", line 3042, in _read_format
    vals[name] = convert(record[name], record, use_name_get)
  File "/home/odoo/src/odoo/odoo/models.py", line 5694, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "/home/odoo/src/odoo/odoo/fields.py", line 1021, in __get__
    self.compute_value(recs)
  File "/home/odoo/src/odoo/odoo/fields.py", line 1177, in compute_value
    records._compute_field_value(self)
  File "/home/odoo/src/odoo/addons/sale/models/sale.py", line 523, in _compute_field_value
    super()._compute_field_value(field)
  File "/home/odoo/src/odoo/addons/mail/models/mail_thread.py", line 410, in _compute_field_value
    return super()._compute_field_value(field)
  File "/home/odoo/src/odoo/odoo/models.py", line 4069, in _compute_field_value
    getattr(self, field.compute)()
  File "/home/odoo/src/user/hms_ventas/models/SaleOrder.py", line 24, in _get_name_of_pricelist
    self.text_tarifa = self.pricelist_id.name
  File "/home/odoo/src/odoo/odoo/fields.py", line 965, in __get__
    record.ensure_one()
  File "/home/odoo/src/odoo/odoo/models.py", line 5019, in ensure_one
    raise ValueError("Expected singleton: %s" % self)
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/odoo/http.py", line 639, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/odoo/src/odoo/odoo/http.py", line 315, in _handle_exception
    raise exception.with_traceback(None) from new_cause
ValueError: Expected singleton: product.pricelist(2, 1)

No estoy seguro si esto es por algun desarrollo extra que se realizo en ODOO.

[tmijail]

Hola.

Cuando hay un Odoo Server Error de ese tipo en general se trata de un error en la evaluación de algún campo calculado. En este caso parece ser un error en el cálculo del campo text_tarifa. Puede ser que en algún caso self.pricelist_id no esté establecido y por lo tanto self.text_tarifa = self.pricelist_id.name tire error.

Una solución idiomática desde el punto de vista de Power BI sería no importar text_tarifa sino en cambio importar las columnas id y name de la tabla product.pricelist y definir la relación entre el pricelist_id de sale.order y el id de product.pricelist.

[amoradel]

Muchas gracias 👌