Hi Team
When I open replenishment from inventory this error is showing
Traceback (most recent call last):
File "/home/odoo/src/odoo/saas-16.1/odoo/tools/safe_eval.py", line 362, in safe_eval
return unsafe_eval(c, globals_dict, locals_dict)
File "ir.actions.server(482,)", line 6, in
File "/home/odoo/src/odoo/saas-16.1/addons/stock/models/stock_orderpoint.py", line 203, in action_open_orderpoints
return self._get_orderpoint_action()
File "/home/odoo/src/odoo/saas-16.1/addons/stock/models/stock_orderpoint.py", line 419, in _get_orderpoint_action
orderpoints = self.env['stock.warehouse.orderpoint'].with_user(SUPERUSER_ID).create(orderpoint_values_list)
File "", line 2, in create
File "/home/odoo/src/odoo/saas-16.1/odoo/api.py", line 410, in _model_create_multi
return create(self, arg)
File "/home/odoo/src/odoo/saas-16.1/odoo/models.py", line 3929, in create
records = self._create(data_list)
File "/home/odoo/src/odoo/saas-16.1/odoo/models.py", line 4132, in _create
cr.execute(
File "/home/odoo/src/odoo/saas-16.1/odoo/sql_db.py", line 315, in execute
res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "warehouse_id" of relation "stock_warehouse_orderpoint" violates not-null constraint
DETAIL: Failing row contains (407, null, 77, 3882, null, null, null, null, 1, 1, Replenishment Report, manual, null, 0.00, 0.00, 1.00, null, t, 2023-05-13 04:19:06.270121, 2023-05-13 04:19:06.270121, null, null, 0, null, 0).
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/odoo/src/odoo/saas-16.1/odoo/http.py", line 1676, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/home/odoo/src/odoo/saas-16.1/odoo/service/model.py", line 134, in retrying
result = func()
File "/home/odoo/src/odoo/saas-16.1/odoo/http.py", line 1703, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/home/odoo/src/odoo/saas-16.1/odoo/http.py", line 1900, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/home/odoo/src/odoo/saas-16.1/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/home/odoo/src/odoo/saas-16.1/odoo/http.py", line 705, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/home/odoo/src/odoo/saas-16.1/addons/web/controllers/action.py", line 42, in run
result = action.run()
File "/home/odoo/src/odoo/saas-16.1/odoo/addons/base/models/ir_actions.py", line 695, in run
res = runner(run_self, eval_context=eval_context)
File "/home/odoo/src/odoo/saas-16.1/odoo/addons/base/models/ir_actions.py", line 565, in _run_action_code_multi
safe_eval(self.code.strip(), eval_context, mode="exec", nocopy=True, filename=str(self)) # nocopy allows to return 'action'
File "/home/odoo/src/odoo/saas-16.1/odoo/tools/safe_eval.py", line 376, in safe_eval
raise ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr))
ValueError: : "null value in column "warehouse_id" of relation "stock_warehouse_orderpoint" violates not-null constraint
DETAIL: Failing row contains (407, null, 77, 3882, null, null, null, null, 1, 1, Replenishment Report, manual, null, 0.00, 0.00, 1.00, null, t, 2023-05-13 04:19:06.270121, 2023-05-13 04:19:06.270121, null, null, 0, null, 0).
" while evaluating
"action = model.with_context(\n search_default_filter_to_reorder=True,\n search_default_filter_not_snoozed=True,\n default_trigger='manual',\n searchpanel_default_trigger='manual'\n ).action_open_orderpoints()"
The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
at makeErrorFromResponse (https://dxgl.odoo.com/web/assets/6123-1722a65/web.assets_backend.min.js:993:163)
at XMLHttpRequest. (https://dxgl.odoo.com/web/assets/6123-1722a65/web.assets_backend.min.js:1001:13)
A lot of thanks for given the suggestion
althought, sir I have already submit support ticket but still nothing respond