Error migrating from erpnext with hrms to 15.47.1

[Bradeskojest]

Information about bug

When calling bench migrate I get the error: pymysql.err.ProgrammingError: (‘DocType’, ‘Shift Assignment Schedule’)

Module

HR

Version

Frappe v15.51.0
ErpNext v15.47.1
HR: v15.37.1

Installation method

docker

Relevant log output / Stack trace / Full Error Message.

Executing hrms.patches.v15_0.migrate_shift_assignment_schedule_to_shift_schedule in frontend (_5e5899d8398b5f7b)
Queued rebuilding of search index for frontend

Traceback (most recent call last):
File “/usr/local/lib/python3.10/runpy.py”, line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File “/usr/local/lib/python3.10/runpy.py”, line 86, in _run_code
exec(code, run_globals)
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 114, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 20, in main
click.Group(commands=commands)(prog_name=“bench”)
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1161, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1082, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1697, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1697, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 1443, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py”, line 788, in invoke
return __callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py”, line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 29, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 686, in migrate
SiteMigration(
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 186, in run
self.run_schema_updates()
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 52, in wrapper
raise e
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 44, in wrapper
ret = method(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 121, in run_schema_updates
frappe.modules.patch_handler.run_all(
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 76, in run_all
run_patch(patch)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 62, in run_patch
if not run_single(patchmodule=patch):
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 152, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 188, in execute_patch
_patch()
File “/home/frappe/frappe-bench/apps/hrms/hrms/patches/v15_0/migrate_shift_assignment_schedule_to_shift_schedule.py”, line 8, in execute
for doc in frappe.get_all(“Shift Assignment Schedule”, fields=fields):
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 2015, in get_all
return get_list(doctype, *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/init.py”, line 1990, in get_list
return frappe.model.db_query.DatabaseQuery(doctype).execute(*args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 186, in execute
self.columns = self.get_table_columns()
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/db_query.py”, line 547, in get_table_columns
return get_table_columns(self.doctype)
File “/home/frappe/frappe-bench/apps/frappe/frappe/model/meta.py”, line 73, in get_table_columns
return frappe.db.get_table_columns(doctype)
File “/home/frappe/frappe-bench/apps/frappe/frappe/database/database.py”, line 1326, in get_table_columns
raise self.TableMissingError(“DocType”, doctype)
pymysql.err.ProgrammingError: (‘DocType’, ‘Shift Assignment Schedule’)

Code of Conduct

• I agree to follow this project's Code of Conduct

[ruchamahabal]

#2571