[13.0] hr_timesheet_time_sheet: Field res.company.sheet_range with non-str value in selection

[gjhagens-shrd]

During install of the hr_timesheet_time_sheet module in Odoo 13 community edition, the stacktrace below is produced. This is related to recent changes in Odoo 13 handling of the Selection field # and #.

Error:
Odoo Server Error

Traceback (most recent call last):
File "/home/odoo/odoo13/odoo/http.py", line 619, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/home/odoo/odoo13/odoo/http.py", line 309, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/home/odoo/odoo13/odoo/tools/pycompat.py", line 14, in reraise
raise value
File "/home/odoo/odoo13/odoo/http.py", line 664, in dispatch
result = self._call_function(**self.params)
File "/home/odoo/odoo13/odoo/http.py", line 345, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/home/odoo/odoo13/odoo/service/model.py", line 93, in wrapper
return f(dbname, *args, **kwargs)
File "/home/odoo/odoo13/odoo/http.py", line 338, in checked_call
result = self.endpoint(*a, **kw)
File "/home/odoo/odoo13/odoo/http.py", line 910, in call
return self.method(*args, **kw)
File "/home/odoo/odoo13/odoo/http.py", line 510, in response_wrap
response = f(*args, **kw)
File "/home/odoo/odoo13/addons/web/controllers/main.py", line 1324, in call_button
action = self._call_kw(model, method, args, kwargs)
File "/home/odoo/odoo13/addons/web/controllers/main.py", line 1312, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/home/odoo/odoo13/odoo/api.py", line 387, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/home/odoo/odoo13/odoo/api.py", line 374, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "", line 2, in button_immediate_install
File "/home/odoo/odoo13/odoo/addons/base/models/ir_module.py", line 72, in check_and_log
return method(self, *args, **kwargs)
File "/home/odoo/odoo13/odoo/addons/base/models/ir_module.py", line 463, in button_immediate_install
return self._button_immediate_function(type(self).button_install)
File "/home/odoo/odoo13/odoo/addons/base/models/ir_module.py", line 573, in _button_immediate_function
modules.registry.Registry.new(self._cr.dbname, update_module=True)
File "/home/odoo/odoo13/odoo/modules/registry.py", line 86, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/home/odoo/odoo13/odoo/modules/loading.py", line 423, in load_modules
loaded_modules, update_module, models_to_check)
File "/home/odoo/odoo13/odoo/modules/loading.py", line 315, in load_marked_modules
perform_checks=perform_checks, models_to_check=models_to_check
File "/home/odoo/odoo13/odoo/modules/loading.py", line 201, in load_module_graph
registry.setup_models(cr)
File "/home/odoo/odoo13/odoo/modules/registry.py", line 252, in setup_models
model._setup_base()
File "/home/odoo/odoo13/odoo/models.py", line 2640, in _setup_base
self._add_field(name, field.new())
File "/home/odoo/odoo13/odoo/models.py", line 375, in _add_field
field.setup_base(self, name)
File "/home/odoo/odoo13/odoo/fields.py", line 324, in setup_base
self._setup_regular_base(model)
File "/home/odoo/odoo13/odoo/fields.py", line 2078, in _setup_regular_base
"Field %s with non-str value in selection" % self
AssertionError: Field res.company.sheet_range with non-str value in selection

[astirpe]

@gjhagens-shrd I guess you upgraded the database from an old version to 13.0. In this case, the conversion of the values of sheet_range field is automatically executed by this OpenUpgrade script within module hr_timesheet_sheet. If you upgraded the database to V13 with a different method, other than OpenUpgrade, you should manually convert the values or create your own script.

[gjhagens-shrd]

@astirpe Thanks for your reply. This however was not the case, the installation was performed on a completely wiped system with a fresh install of Odoo 13 community edition. Are there any manual adjustments that can be done?

[astirpe]

You could check the database directly.
The field sheet_range of table res_company shall contain only the following strings:
MONTHLY
WEEKLY
DAILY
You can fix the values manually in case they are wrong.

An alternative quick-and-dirty way to fix it could be by deleting field sheet_range from table res_company and update the module again.

[gjhagens-shrd]

Ah, thanks. The funny thing is that the field sheet_range doesn't exist in the table res_company. The quick-and-dirty way therefor doesn't work.

[maheshreddygali]

if anyone knows the solution please let me know..!! i am also facing the same problem during installation..

[github-actions]

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days.
If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.