Invalid parent field

[quantixdream]

Hello,

Since a few days the connector is not working anymore, i have been using it for almost 2 years without any issue. I cannot refresh anymore the datasource as it says "Invalid parent field : res.users.parent_id".

`Odoo Server Error : Invalid parent field: res.users.parent_id
Détails :
Traceback (most recent call last):
File "/home/odoo/src/odoo/15.0/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
result = request.dispatch()
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 698, in dispatch
result = self._call_function(**self.params)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 368, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/home/odoo/src/odoo/15.0/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 357, in checked_call
result = self.endpoint(*a, **kw)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 921, in call
return self.method(*args, **kw)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 546, in response_wrap
response = f(*args, **kw)
File "/home/odoo/src/custom/trial/saas_trial/controllers/main.py", line 275, in jsonrpc
res = super(OdooRPC, self).jsonrpc(service, method, args)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 546, in response_wrap
response = f(*args, **kw)
File "/home/odoo/src/odoo/15.0/odoo/addons/base/controllers/rpc.py", line 101, in jsonrpc
return dispatch_rpc(service, method, args)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 141, in dispatch_rpc
result = dispatch(method, params)
File "/home/odoo/src/odoo/15.0/odoo/service/model.py", line 41, in dispatch
res = fn(db, uid, *params)
File "/home/odoo/src/odoo/15.0/odoo/service/model.py", line 169, in execute_kw
return execute(db, uid, obj, method, *args, **kw or {})
File "/home/odoo/src/odoo/15.0/odoo/service/model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "/home/odoo/src/odoo/15.0/odoo/service/model.py", line 176, in execute
res = execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/odoo/src/odoo/15.0/odoo/service/model.py", line 160, in execute_cr
result = odoo.api.call_kw(recs, method, args, kw)
File "/home/odoo/src/odoo/15.0/odoo/api.py", line 460, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/home/odoo/src/odoo/15.0/odoo/api.py", line 433, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/home/odoo/src/odoo/15.0/odoo/models.py", line 2438, in read_group
result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)
File "/home/odoo/src/odoo/15.0/odoo/models.py", line 2474, in _read_group_raw
query = self._where_calc(domain)
File "/home/odoo/src/odoo/15.0/odoo/models.py", line 4467, in _where_calc
return expression.expression(domain, self).query
File "/home/odoo/src/odoo/15.0/odoo/osv/expression.py", line 442, in init
self.parse()
File "/home/odoo/src/odoo/15.0/odoo/osv/expression.py", line 703, in parse
right_ids = comodel.with_context(active_test=False)._search([(path[1], operator, right)], order='id')
File "/home/odoo/src/odoo/15.0/odoo/addons/base/models/res_users.py", line 214, in _search
return super(Groups, self)._search(args, offset=offset, limit=limit, order=order, count=count, access_rights_uid=access_rights_uid)
File "/home/odoo/src/odoo/15.0/odoo/models.py", line 4711, in _search
query = self._where_calc(args)
File "/home/odoo/src/odoo/15.0/odoo/models.py", line 4467, in _where_calc
return expression.expression(domain, self).query
File "/home/odoo/src/odoo/15.0/odoo/osv/expression.py", line 442, in init
self.parse()
File "/home/odoo/src/odoo/15.0/odoo/osv/expression.py", line 811, in parse
domain = HIERARCHY_FUNCS[operator]('id', ids2, comodel)
File "/home/odoo/src/odoo/15.0/odoo/osv/expression.py", line 543, in child_of_domain
raise ValueError(f"Invalid parent field: {left_model._fields[parent_name]}")
Exception

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

Traceback (most recent call last):
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 654, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/home/odoo/src/odoo/15.0/odoo/http.py", line 301, in _handle_exception
raise exception.with_traceback(None) from new_cause
ValueError: Invalid parent field: res.users.parent_id`

Do you have any idea ?

[tmijail]

That's an error in Odoo. I've ran into similar issues before. It usually means that there's a corrupted record in your database or that there's a bug in a calculated field.

Can you show me the complete code (from the Advanced Editor) of the query that's throwing the error?

[quantixdream]

Thanks for the reply. Here is the query : let

Source = Odoo.Contents("xxx.odoo.com", "xxx"), Tables = Source{[Key="Tables"]}[Data], product.product = Tables{[Model="product.product"]}[Data], product.product1 = product.product{[Key="product.product"]}[Data], #"product_variant_id développé" = Table.ExpandRecordColumn(product.product1, "product_variant_id", {"id", "name"}, {"product_variant_id.id", "product_variant_id.name"}), #"categ_id développé" = Table.ExpandRecordColumn(#"product_variant_id développé", "categ_id", {"id", "name"}, {"categ_id.id", "categ_id.name"}), #"pos_categ_id développé" = Table.ExpandRecordColumn(#"categ_id développé", "pos_categ_id", {"id", "name"}, {"pos_categ_id.id", " pos_categ_id.name"}) in #"pos_categ_id développé"

Le jeu. 1 juin 2023 à 21:58, Mijail Todorovich ***@***.***> a écrit :

…

That's an error in Odoo. I've ran into similar issues before. It usually means that there's a corrupted record in your database or that there's a bug in a calculated field. Can you show me the complete code (from the Advanced Editor) of the query that's throwing the error? — Reply to this email directly, view it on GitHub <#17 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAH5MHD4RVTTZOAJUTXTDXLXJDX7DANCNFSM6AAAAAAYXFJCCI> . You are receiving this because you authored the thread.Message ID: <tmijail/Odoo-Power-BI-Connector/repo-discussions/17/comments/6065020@ github.com>

[tmijail]

Try adding a new blank query named search_read and pasting the following in the advanced editor. Remember to replace xxx with your connection info.

let
    Origen = Odoo.Contents("xxx.odoo.com", "xxx"),
    Functions = Origen{[Key="Functions"]}[Data],
    search_read1 = Functions{[Function="search_read"]}[Data]
in
    search_read1

Then, modify your product query so it looks like this:

let
     Source = search_read(
        "product.product", 
        {}, [
        fields = {
            "default_code",
            "display_name",
            "product_variant_id",
            "categ_id",
            "active"
         }]),
     #"product_variant_id développé" = Table.ExpandRecordColumn(Source, "product_variant_id", {"id", "name"}, {"product_variant_id.id", "product_variant_id.name"}),
     #"categ_id développé" = Table.ExpandRecordColumn(#"product_variant_id développé", "categ_id", {"id", "name"}, {"categ_id.id", "categ_id.name"}),
     #"pos_categ_id développé" = Table.ExpandRecordColumn(#"categ_id développé", "pos_categ_id", {"id", "name"}, {"pos_categ_id.id", "pos_categ_id.name"})
 in
     #"pos_categ_id développé"

Modify the fields = { ... } section such that it contains a list of just the columns that are necessary for your reports.
Don't add unnecessary columns. That would add load to the server and increase the chances of a refresh failing because of an error in one of them.

For more info, see this section of the readme.

[Mauricio815]

First of all, many thanks in advance for tremendous development, Mijail! @tmijail

In my case, I am setting up the connector for the first time and I have the same error, but with the contacts. Could you help me? Thank you in advance!

I share the error:

Odoo Server Error: Invalid parent field: res.users.parent_id
Detalles:
Traceback (most recent call last):
File "/home/odoo/src/odoo/16.0/odoo/http.py", line 1584, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/home/odoo/src/odoo/16.0/odoo/service/model.py", line 133, in retrying
result = func()
File "/home/odoo/src/odoo/16.0/odoo/http.py", line 1611, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/home/odoo/src/odoo/16.0/odoo/http.py", line 1815, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/home/odoo/src/odoo/16.0/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/home/odoo/src/odoo/16.0/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/home/odoo/src/custom/trial/saas_trial/controllers/main.py", line 275, in jsonrpc
res = super(OdooRPC, self).jsonrpc(service, method, args)
File "/home/odoo/src/odoo/16.0/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/home/odoo/src/odoo/16.0/odoo/addons/base/controllers/rpc.py", line 156, in jsonrpc
return dispatch_rpc(service, method, args)
File "/home/odoo/src/odoo/16.0/odoo/http.py", line 366, in dispatch_rpc
return dispatch(method, params)
File "/home/odoo/src/odoo/16.0/odoo/service/model.py", line 37, in dispatch
res = execute_kw(db, uid, *params[3:])
File "/home/odoo/src/odoo/16.0/odoo/service/model.py", line 59, in execute_kw
return execute(db, uid, obj, method, *args, **kw or {})
File "/home/odoo/src/odoo/16.0/odoo/service/model.py", line 65, in execute
res = execute_cr(cr, uid, obj, method, *args, **kw)
File "/home/odoo/src/odoo/16.0/odoo/service/model.py", line 50, in execute_cr
result = retrying(partial(odoo.api.call_kw, recs, method, args, kw), env)
File "/home/odoo/src/odoo/16.0/odoo/service/model.py", line 133, in retrying
result = func()
File "/home/odoo/src/odoo/16.0/odoo/api.py", line 457, in call_kw
result = _call_kw_model(method, model, args, kwargs)
File "/home/odoo/src/odoo/16.0/odoo/api.py", line 430, in _call_kw_model
result = method(recs, *args, **kwargs)
File "/home/odoo/src/odoo/16.0/odoo/models.py", line 2188, in read_group
result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)
File "/home/odoo/src/odoo/16.0/odoo/models.py", line 2213, in _read_group_raw
query = self._where_calc(domain)
File "/home/odoo/src/odoo/16.0/odoo/models.py", line 4407, in _where_calc
return expression.expression(domain, self).query
File "/home/odoo/src/odoo/16.0/odoo/osv/expression.py", line 447, in init
self.parse()
File "/home/odoo/src/odoo/16.0/odoo/osv/expression.py", line 721, in parse
right_ids = comodel.with_context(active_test=False)._search([(path[1], operator, right)], order='id')
File "/home/odoo/src/odoo/16.0/odoo/addons/base/models/res_users.py", line 208, in _search
return super(Groups, self)._search(args, offset=offset, limit=limit, order=order, count=count, access_rights_uid=access_rights_uid)
File "/home/odoo/src/odoo/16.0/odoo/models.py", line 4639, in _search
query = self._where_calc(domain)
File "/home/odoo/src/odoo/16.0/odoo/models.py", line 4407, in _where_calc
return expression.expression(domain, self).query
File "/home/odoo/src/odoo/16.0/odoo/osv/expression.py", line 447, in init
self.parse()
File "/home/odoo/src/odoo/16.0/odoo/osv/expression.py", line 829, in parse
domain = HIERARCHY_FUNCS[operator]('id', ids2, comodel)
File "/home/odoo/src/odoo/16.0/odoo/osv/expression.py", line 561, in child_of_domain
raise ValueError(f"Invalid parent field: {left_model._fields[parent_name]}")
ValueError: Invalid parent field: res.users.parent_id

[iqbalnurhabib]

@quantixdream did you manage to solve this problem

[AlexandreOnnee]

Hi, No. I don't know how to solve this. Many thanks for your help! Le mar. 27 juin 2023 à 08:42, Iqbal Nurhabib ***@***.***> a écrit :

…

@quantixdream <https://github.com/quantixdream> did you manage to solve this problem — Reply to this email directly, view it on GitHub <#17 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BANRPOVI7S65ZZGN3BMDDY3XNJ6GBANCNFSM6AAAAAAYXFJCCI> . You are receiving this because you commented.Message ID: <tmijail/Odoo-Power-BI-Connector/repo-discussions/17/comments/6289508@ github.com>

[tmijail]

This is fixed in the new releases v1.0.0 and v0.2.0.