Bij het openen van een Odoo-omgeving treedt de volgende fout op:
OData:
Request failed:
The remote server returned an error:
(500) Internal Server Error.
(itgenodo107: Invalid field 'x_ on model ‘y’ (200) (builtins.ValueError)
(itgenodo107, 87dd5a10-980c-43ed-a617-9cfdcb2e0221))
Het betreft de volgende foutmelding:
itgenodo107
Invalid field ‘x_studio_boolean_field_xh7n2’ on model ‘product.product’ (200).
builtins.ValueError
Deze foutmelding is een vertolking van een Odoo interne foutmelding:
{"jsonrpc": "2.0", "id": 17, "error": {"code": 200, "message": "Odoo Server Error", "data": {"name": "builtins.ValueError", "debug": "Traceback (most recent call last):\n File \"/home/odoo/src/odoo/odoo/addons/base/models/ir_http.py\", line 237, in _dispatch\n result = request.dispatch()\n File \"/home/odoo/src/odoo/odoo/http.py\", line 696, in dispatch\n result = self._call_function(**self.params)\n File \"/home/odoo/src/odoo/odoo/http.py\", line 370, in _call_function\n return checked_call(self.db, *args, **kwargs)\n File \"/home/odoo/src/odoo/odoo/service/model.py\", line 94, in wrapper\n return f(dbname, *args, **kwargs)\n File \"/home/odoo/src/odoo/odoo/http.py\", line 358, in checked_call\n result = self.endpoint(*a, **kw)\n File \"/home/odoo/src/odoo/odoo/http.py\", line 919, in __call__\n return self.method(*args, **kw)\n File \"/home/odoo/src/odoo/odoo/http.py\", line 544, in response_wrap\n response = f(*args, **kw)\n File \"/home/odoo/src/odoo/odoo/addons/base/controllers/rpc.py\", line 96, in jsonrpc\n return dispatch_rpc(service, method, args)\n File \"/home/odoo/src/odoo/odoo/http.py\", line 142, in dispatch_rpc\n result = dispatch(method, params)\n File \"/home/odoo/src/odoo/odoo/service/model.py\", line 41, in dispatch\n res = fn(db, uid, *params)\n File \"/home/odoo/src/odoo/odoo/service/model.py\", line 168, in execute_kw\n return execute(db, uid, obj, method, *args, **kw or {})\n File \"/home/odoo/src/odoo/odoo/service/model.py\", line 94, in wrapper\n return f(dbname, *args, **kwargs)\n File \"/home/odoo/src/odoo/odoo/service/model.py\", line 175, in execute\n res = execute_cr(cr, uid, obj, method, *args, **kw)\n File \"/home/odoo/src/odoo/odoo/service/model.py\", line 159, in execute_cr\n result = odoo.api.call_kw(recs, method, args, kw)\n File \"/home/odoo/src/odoo/odoo/api.py\", line 395, in call_kw\n result = _call_kw_model(method, model, args, kwargs)\n File \"/home/odoo/src/odoo/odoo/api.py\", line 368, in _call_kw_model\n result = method(recs, *args, **kwargs)\n File \"/home/odoo/src/odoo/odoo/models.py\", line 4890, in search_read\n result = records.read(fields)\n File \"/home/odoo/src/odoo/odoo/models.py\", line 3019, in read\n raise ValueError(\"Invalid field %r on model %r\" % (name, self._name))\nException\n\nThe above exception was the direct cause of the following exception:\n\nTraceback (most recent call last):\n File \"/home/odoo/src/odoo/odoo/http.py\", line 652, in _handle_exception\n return super(JsonRequest, self)._handle_exception(exception)\n File \"/home/odoo/src/odoo/odoo/http.py\", line 317, in _handle_exception\n raise exception.with_traceback(None) from new_cause\nValueError: Invalid field 'x_studio_boolean_field_xh7n2' on model 'product.product'\n", "message": "Invalid field 'x_studio_boolean_field_xh7n2' on model 'product.product'", "arguments": ["Invalid field 'x_studio_boolean_field_xh7n2' on model 'product.product'"], "context": {}}}}
als antwoord op de vraag voor het ophalen van de productwaardes:
{
"id":21,
"jsonrpc":"2.0",
"method":"call",
"params":{
"service":"object",
"method":"execute_kw",
"args":[
"binformed-ACME-gov14-production-2308664",
118,
"SECRET",
"product.product",
"search_read",
[
],
{
"limit":1500,
"offset":0,
"fields":[
"__last_update",
"accessory_product_ids",
"active",
"activity_date_deadline",
"activity_exception_decoration",
"activity_exception_icon",
"activity_ids",
"activity_state",
"activity_summary",
"activity_type_icon",
"activity_type_id",
"activity_user_id",
"alert_time",
"alternative_product_ids",
"attachment_count",
"attribute_line_ids",
"avail_only_specific_countries",
"available_threshold",
"barcode",
"can_image_1024_be_zoomed",
"can_image_variant_1024_be_zoomed",
"can_publish",
"cart_qty",
"categ_id",
"code",
"color",
"combination_indices",
"company_id",
"cost_currency_id",
"cost_method",
"countries_ids",
"create_date",
"create_uid",
"currency_id",
"custom_message",
"date_from",
"date_to",
"default_code",
"description",
"description_picking",
"description_pickingin",
"description_pickingout",
"description_purchase",
"description_sale",
"display_name",
MAATWERKVELD
"ean_unit",
"expected_margin",
"expected_margin_rate",
"expense_policy",
"expiration_time",
"fixed_pricelist_item_ids",
"free_qty",
"has_available_route_ids",
"has_configurable_attributes",
"hs_code",
"id",
"image_1024",
"image_128",
"image_1920",
"image_256",
"image_512",
"image_variant_1024",
"image_variant_128",
"image_variant_1920",
"image_variant_256",
"image_variant_512",
"incoming_qty",
"intrastat_id",
"intrastat_origin_country_id",
"inventory_availability",
"invoice_policy",
"invoice_state",
"is_product_variant",
"is_published",
"is_seo_optimized",
MAATWERKVELD
"label",
"list_price",
"location_id",
"lst_price",
"message_attachment_count",
"message_channel_ids",
"message_follower_ids",
"message_has_error",
"message_has_error_counter",
"message_has_sms_error",
"message_ids",
"message_is_follower",
"message_main_attachment_id",
"message_needaction",
"message_needaction_counter",
"message_partner_ids",
"message_unread",
"message_unread_counter",
"my_activity_date_deadline",
"name",
"nbr_reordering_rules",
"netto_gewicht_gr",
"normal_cost",
"orderpoint_ids",
"outgoing_qty",
"packaging_ids",
MAATWERKVELDEN
"partner_ref",
"price",
"price_extra",
"pricelist_id",
"pricelist_item_count",
"pricelist_item_ids",
"prijs_per_stuk_laag",
"prijs_pstuk_cost_1",
"prijs_pstuk_doos",
"prijs_pstuk_pallet",
"product_template_attribute_value_ids",
"product_template_image_ids",
"product_tmpl_id",
"product_variant_count",
"product_variant_id",
"product_variant_ids",
"product_variant_image_ids",
"property_account_creditor_price_difference",
"property_account_expense_id",
"property_account_income_id",
"property_stock_inventory",
"property_stock_production",
"public_categ_ids",
"purchase_avg_price",
"purchase_gap",
"purchase_line_warn",
"purchase_line_warn_msg",
"purchase_method",
"purchase_num_invoiced",
"purchase_ok",
"purchase_order_line_ids",
"purchased_product_qty",
"putaway_rule_ids",
"qty_available",
"quantity_svl",
"rating_avg",
"rating_count",
"rating_ids",
"rating_last_feedback",
"rating_last_image",
"rating_last_value",
"removal_time",
"reordering_max_qty",
"reordering_min_qty",
"responsible_id",
"route_from_categ_ids",
"route_ids",
"sale_avg_price",
"sale_delay",
"sale_expected",
"sale_line_warn",
"sale_line_warn_msg",
"sale_num_invoiced",
"sale_ok",
"sales_count",
"sales_gap",
"seller_ids",
"seo_name",
"sequence",
"service_to_purchase",
"service_type",
"show_on_hand_qty_status_button",
"standard_price",
"stock_move_ids",
"stock_quant_ids",
"stock_valuation_layer_ids",
"stuks_doos",
"stuks_laag",
"stuks_pallet",
"supplier_taxes_id",
"taxes_id",
"tht",
"total_cost",
"total_margin",
"total_margin_rate",
"tracking",
"turnover",
"type",
"uom_id",
"uom_name",
"uom_po_id",
"use_expiration_date",
"use_time",
"valid_product_template_attribute_line_ids",
"valuation",
"value_svl",
"variant_seller_ids",
"virtual_available",
"visible_expense_policy",
"visible_qty_configurator",
"volume",
"volume_uom_name",
"warehouse_id",
"website_description",
"website_id",
"website_message_ids",
"website_meta_description",
"website_meta_keywords",
"website_meta_og_img",
"website_meta_title",
"website_published",
"website_ribbon_id",
"website_sequence",
"website_size_x",
"website_size_y",
"website_url",
"weight",
"weight_uom_name",
"write_date",
"write_uid",
"x_studio_boolean_field_xh7n2",
"x_studio_bruto_gewicht_gr",
...<<meer custom velden verwijderd>>
]
}
]
}
}
Dit betreft een bug in Odoo die waarschijnlijk veroorzaakt is door niet-correct samengesteld maatwerk en waarschijnlijk betreffende een boolean veld dat toegevoegd is vanuit Odoo Studio aan de productentabel.
Advies is om contact op te nemen met de Odoo-consultant of applicatiebeheerder.
Op basis van bovenstaande twee blokken JSON moet men in staat zijn deze error te reproduceren buiten Invantive Cloud om, en correctieve acties te ondernemen, dan wel Odoo Support te benaderen met een reproductiescenario ter oplossing in een toekomstige versie van Odoo.
Deze vraag is automatisch gesloten na 2 weken inactiviteit. Het laatste gegeven antwoord is gemarkeerd als oplossing.
Gelieve een nieuwe vraag te stellen via een apart topic als het probleem opnieuw optreedt. Gelieve in de nieuwe vraag een link naar dit topic op te nemen door de URL er van in de tekst te plakken.
Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.