V9.1 to latest: Migration error

sujay@sujay-ThinkPad-T420:~/frappe-bench$ bench --site site1.local migrate
Migrating site1.local
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docfield’, force=True) #2018-02-20 in site1.local (1bd3e0294da19198)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘activity_log’) in site1.local (1bd3e0294da19198)
Success
Executing frappe.patches.v9_1.resave_domain_settings in site1.local (1bd3e0294da19198)
Success
Executing frappe.patches.v9_1.revert_domain_settings in site1.local (1bd3e0294da19198)
Success
Executing frappe.patches.v9_1.move_feed_to_activity_log in site1.local (1bd3e0294da19198)
Success
Executing execute:frappe.delete_doc(‘Page’, ‘data-import-tool’, ignore_missing=True) in site1.local (1bd3e0294da19198)
Success
Executing frappe.patches.v10_0.reload_countries_and_currencies in site1.local (1bd3e0294da19198)
Updating country info : [========================================]
Success
Executing frappe.patches.v10_0.refactor_social_login_keys in site1.local (1bd3e0294da19198)
Success
Executing frappe.patches.v10_0.enable_chat_by_default_within_system_settings in site1.local (1bd3e0294da19198)
Success
Executing frappe.patches.v10_0.remove_custom_field_for_disabled_domain in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v10_0.rename_schools_to_education in site1.local (1bd3e0294da19198)
Success
Executing execute:frappe.reload_doc(“stock”, “doctype”, “stock_settings”) in site1.local (1bd3e0294da19198)
Success
Executing execute:frappe.db.sql(“update tabStock Entry set total_amount = 0 where purpose in(‘Repack’, ‘Manufacture’)”) in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v8_9.add_setup_progress_actions #08-09-2017 #26-09-2017 #22-11-2017 #15-12-2017 in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v8_9.set_member_party_type in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_0.set_pos_profile_name in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_0.remove_non_existing_warehouse_from_stock_settings in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v8_10.change_default_customer_credit_days in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_0.update_employee_loan_details in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_2.delete_healthcare_domain_default_items in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_1.create_issue_opportunity_type in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_2.rename_translated_domains_in_en in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_0.set_shipping_type_for_existing_shipping_rules in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_0.update_multi_uom_fields_in_material_request in site1.local (1bd3e0294da19198)
Success
Executing erpnext.patches.v9_2.repost_reserved_qty_for_production in site1.local (1bd3e0294da19198)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/sujay/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/home/sujay/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/sujay/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/sujay/frappe-bench/apps/frappe/frappe/commands/init.py”, line 25, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/sujay/frappe-bench/apps/frappe/frappe/commands/site.py”, line 222, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/sujay/frappe-bench/apps/frappe/frappe/migrate.py”, line 39, in migrate
frappe.modules.patch_handler.run_all()
File “/home/sujay/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 29, in run_all
if not run_single(patchmodule = patch):
File “/home/sujay/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 63, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/sujay/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 83, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/sujay/frappe-bench/apps/erpnext/erpnext/patches/v9_2/repost_reserved_qty_for_production.py”, line 7, in execute
bin_doc.update_reserved_qty_for_production()
File “/home/sujay/frappe-bench/apps/erpnext/erpnext/stock/doctype/bin/bin.py”, line 88, in update_reserved_qty_for_production
self.set_projected_qty()
File “/home/sujay/frappe-bench/apps/erpnext/erpnext/stock/doctype/bin/bin.py”, line 64, in set_projected_qty
- flt(self.reserved_qty_for_production) - flt(self.reserved_qty_for_sub_contract))
AttributeError: ‘Bin’ object has no attribute ‘reserved_qty_for_sub_contract’

I am getting this attribute error while migrating the database in local system, plz provide some solutions

Hi,

Just encountered this while trying to submit a Stock Entry document

Any ideas?

Thanks

Encountered same error

AttributeError: ‘Bin’ object has no attribute ‘reserved_qty_for_sub_contract’

Migrating site2.local
Executing erpnext.patches.v9_2.repost_reserved_qty_for_production in site2.local (a46003081c220c38)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/frappe/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py”, line 222, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py”, line 31, in migrate
frappe.modules.patch_handler.run_all()
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 29, in run_all
if not run_single(patchmodule = patch):
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 63, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 83, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v9_2/repost_reserved_qty_for_production.py”, line 7, in execute
bin_doc.update_reserved_qty_for_production()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/doctype/bin/bin.py”, line 88, in update_reserved_qty_for_production
self.set_projected_qty()
File “/home/frappe/frappe-bench/apps/erpnext/erpnext/stock/doctype/bin/bin.py”, line 64, in set_projected_qty
- flt(self.reserved_qty_for_production) - flt(self.reserved_qty_for_sub_contract))
AttributeError: ‘Bin’ object has no attribute ‘reserved_qty_for_sub_contract’

Pls provide some solution – > V8-V9

in frappe-bench folder, enter mysql shell by executing the command “bench mysql”.

in mysql shell execute the command (without quotes)
“alter table tabBin add reserved_qty_for_sub_contract decimal(16, 8) not null default ‘0.000000’;”

exit mysql shell and execute “bench update”.

1 Like