Ugrade to V5 ends up in error ( Resolved)

SandeepAthiyarath · June 14, 2015, 10:24am

Hi team,
I was trying to upgrade my installation to the V5 and ends up the following error:

Migrating site1.local
Executing erpnext.patches.v5_0.repost_gle_for_jv_with_multiple_party in site1.local (1bd3e0294d)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, 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/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 77, in
main()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 14, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 664, in call
return self.main(*args, **kwargs)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 644, in main
rv = self.invoke(ctx)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 991, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 991, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 837, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 464, in invoke
return callback(*args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/commands.py”, line 28, in _func
ret = f(frappe.dict(ctx.obj), *args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/commands.py”, line 205, in migrate
frappe.modules.patch_handler.run_all()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
if not run_single(patchmodule = patch):
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/patches/v5_0/repost_gle_for_jv_with_multiple_party.py”, line 21, in execute
je.make_gl_entries()
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/journal_entry/journal_entry.py”, line 353, in make_gl_entries
make_gl_entries(gl_map, cancel=cancel, adv_adj=adv_adj)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py”, line 20, in make_gl_entries
save_entries(gl_map, adv_adj, update_outstanding)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py”, line 72, in save_entries
make_entry(entry, adv_adj, update_outstanding)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py”, line 80, in make_entry
gle.insert()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 178, in insert
self.run_before_save_methods()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 543, in run_before_save_methods
self.run_method(“validate”)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 509, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 625, in composer
return composed(self, method, *args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 608, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 503, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py”, line 15, in validate
self.check_mandatory()
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py”, line 41, in check_mandatory
frappe.throw((“Party Type and Party is required for Receivable / Payable account {0}”).format(self.account))
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 252, in throw
msgprint(msg, raise_exception=exc)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 245, in msgprint
_raise_exception()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 230, in _raise_exception
raise raise_exception, encode(msg)
frappe.exceptions.ValidationError: Party Type and Party is required for Receivable / Payable account Provision For Tax - ‘CompanyName’

Please help to identify the issue.

Thanks
Sandeep

SandeepAthiyarath · June 14, 2015, 12:58pm

Hi Team,

I tried to restore the db from the backup, that also ended in the similar error.
looks I am stuck, either upgrade or restore to old state is not working. Please help.
Restore errors are below:

ubuntu@ip-10-10-0-176:/tmp$ bench --force restore /tmp/20150614_40949885_database.sql
MySQL root password:
Installing frappe…
Already installed
*** Scheduler is disabled ***
ubuntu@ip-10-10-0-176:/tmp$ sudo /etc/init.d/nginx restart

Restarting nginx nginx [ OK ]
ubuntu@ip-10-10-0-176:/tmp$ bench migrate
Migrating site1.local
Executing frappe.patches.v5_0.convert_to_barracuda_and_utf8mb4 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘core’, ‘doctype’, ‘docfield’, force=True) #2015-05-15 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘email’, ‘doctype’, ‘email_alert’) #2014-07-15 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘desk’, ‘doctype’, ‘todo’) #2014-12-31-1 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘custom’, ‘doctype’, ‘property_setter’) #2014-12-31-1 in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.v4_to_v5 in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.remove_shopping_cart_app in site1.local (1bd3e0294d)
Success
Executing execute:frappe.permissions.reset_perms(“Module Def”) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.permissions.reset_perms(“User”) #2015-03-24 in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.rename_table_fieldnames in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.communication_parent in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.clear_website_group_and_notifications in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“”“update tabComment set comment = substr(comment, 6, locate(”:“, comment)-6) where comment_type in (“Assigned”, “Assignment Completed”)”“”) in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.fix_feed in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.update_shared in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.bookmarks_to_stars in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.style_settings_to_website_theme in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.rename_ref_type_fieldnames in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.fix_email_alert in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.fix_null_date_datetime in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.force_sync_website in site1.local (1bd3e0294d)
Success
Executing execute:frappe.delete_doc(“DocType”, “Tag”) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“delete from tabProperty Setter where property in (‘idx’, ‘_idx’)”) in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.move_scheduler_last_event_to_system_settings in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“update tabUser set new_password=‘’ where ifnull(new_password, ‘’)!=‘’”) in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.fix_text_editor_file_urls in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“update tabComment set comment_type=‘Comment’ where comment_doctype=‘Blog Post’ and ifnull(comment_type, ‘’)=‘’”) in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.modify_session in site1.local (1bd3e0294d)
Success
Executing frappe.patches.v5_0.expire_old_scheduler_logs in site1.local (1bd3e0294d)
Success
Executing execute:frappe.permissions.reset_perms(“GL Entry”) #2014-06-09 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.permissions.reset_perms(“Stock Ledger Entry”) #2014-06-09 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.rename_doc(“DocType”, “Support Ticket”, “Issue”, force=True) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v4_4.make_email_accounts in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v4_2.reset_bom_costs in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_frozen_accounts_permission_role in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_dn_against_doc_fields in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“update tabMaterial Request set material_request_type = ‘Material Transfer’ where material_request_type = ‘Transfer’”) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘stock’, ‘doctype’, ‘item’) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“update tabItem i set apply_warehouse_wise_reorder_level=1, re_order_level=0, re_order_qty=0 where exists(select name from tabItem Reorder where parent=i.name)”) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.set_default_company_in_bom in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.capacity_planning in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘crm’, ‘doctype’, ‘lead’) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘crm’, ‘doctype’, ‘opportunity’) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.rename_taxes_and_charges_master in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.rename_table_fieldnames in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql(“update tabJournal Entry set voucher_type=‘Journal Entry’ where ifnull(voucher_type, ‘’)=‘’”) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.is_group in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v4_2.party_model in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.party_model_patch_fix in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.recalculate_total_amount_in_jv in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_companywise_payment_account in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.remove_birthday_events in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_item_name_in_bom in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.rename_customer_issue in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.rename_total_fields in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.new_crm_module in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_material_transfer_for_manufacture in site1.local (1bd3e0294d)
Success
Executing execute:frappe.reload_doc(‘crm’, ‘doctype’, ‘opportunity_item’) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_item_description_and_image in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_material_transferred_for_manufacturing in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.stock_entry_update_value in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.convert_stock_reconciliation in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_projects in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.item_patches in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_journal_entry_title in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.taxes_and_totals_in_party_currency in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.replace_renamed_fields_in_custom_scripts_and_print_formats in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_from_bom in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_account_types in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_sms_sender in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.set_appraisal_remarks in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_time_log_title in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.newsletter in site1.local (1bd3e0294d)
Success
Executing execute:frappe.delete_doc(“DocType”, “Chart of Accounts”) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.delete_doc(“DocType”, “Style Settings”) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_opportunity in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.opportunity_not_submittable in site1.local (1bd3e0294d)
Success
Executing execute:frappe.permissions.reset_perms(“Purchase Taxes and Charges Template”) #2014-06-09 in site1.local (1bd3e0294d)
Success
Executing execute:frappe.permissions.reset_perms(“Expense Claim Type”) #2014-06-19 in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.execute_on_doctype_update in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v4_2.fix_recurring_orders in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v4_2.delete_gl_entries_for_cancelled_invoices in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.project_costing in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_temporary_account in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_advance_paid in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.link_warehouse_with_account in site1.local (1bd3e0294d)
Success
Executing execute:frappe.delete_doc(“Page”, “stock-ledger”) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.delete_doc(“Page”,“stock-level”) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.reclculate_planned_operating_cost_in_production_order in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.repost_requested_qty in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.fix_taxes_and_totals_in_party_currency in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_tax_amount_after_discount_in_purchase_cycle in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.rename_pos_setting in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_operation_description in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.set_footer_address in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.set_value(“Backup Manager”, None, “send_backups_to_dropbox”, 1 if frappe.db.get_value(“Backup Manager”, None, “upload_backups_to_dropbox”) in (“Daily”, “Weekly”) else 0) in site1.local (1bd3e0294d)
Success
Executing execute:frappe.db.sql_list(“delete from tabDocPerm where parent=‘Issue’ and modified_by=‘Administrator’ and role=‘Guest’”) in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.update_item_and_description_again in site1.local (1bd3e0294d)
Success
Executing erpnext.patches.v5_0.repost_gle_for_jv_with_multiple_party in site1.local (1bd3e0294d)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 162, 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/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 77, in
main()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 14, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 664, in call
return self.main(*args, **kwargs)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 644, in main
rv = self.invoke(ctx)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 991, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 991, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 837, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/ubuntu/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 464, in invoke
return callback(*args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/commands.py”, line 28, in _func
ret = f(frappe.dict(ctx.obj), *args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/commands.py”, line 205, in migrate
frappe.modules.patch_handler.run_all()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 25, in run_all
if not run_single(patchmodule = patch):
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 52, in run_single
return execute_patch(patchmodule, method, methodargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/modules/patch_handler.py”, line 68, in execute_patch
frappe.get_attr(patchmodule.split()[0] + “.execute”)()
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/patches/v5_0/repost_gle_for_jv_with_multiple_party.py”, line 21, in execute
je.make_gl_entries()
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/journal_entry/journal_entry.py”, line 353, in make_gl_entries
make_gl_entries(gl_map, cancel=cancel, adv_adj=adv_adj)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py”, line 20, in make_gl_entries
save_entries(gl_map, adv_adj, update_outstanding)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py”, line 72, in save_entries
make_entry(entry, adv_adj, update_outstanding)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/general_ledger.py”, line 80, in make_entry
gle.insert()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 178, in insert
self.run_before_save_methods()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 543, in run_before_save_methods
self.run_method(“validate”)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 509, in run_method
return Document.hook(fn)(self, *args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 625, in composer
return composed(self, method, *args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 608, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/model/document.py”, line 503, in
fn = lambda self, *args, **kwargs: getattr(self, method)(*args, **kwargs)
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py”, line 15, in validate
self.check_mandatory()
File “/home/ubuntu/frappe-bench/apps/erpnext/erpnext/accounts/doctype/gl_entry/gl_entry.py”, line 41, in check_mandatory
frappe.throw((“Party Type and Party is required for Receivable / Payable account {0}”).format(self.account))
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 252, in throw
msgprint(msg, raise_exception=exc)
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 245, in msgprint
_raise_exception()
File “/home/ubuntu/frappe-bench/apps/frappe/frappe/init.py”, line 230, in _raise_exception
raise raise_exception, encode(msg)
frappe.exceptions.ValidationError: Party Type and Party is required for Receivable / Payable account Provision For Tax

nabinhait · June 16, 2015, 10:51am

You should reset “Account Type” as blank for account “Provision For Tax” from mysql shell and then try again.

SandeepAthiyarath · June 21, 2015, 8:53am

Thanks Nabin for your reply.

I am able to rectify the error by selecting the either marked account type marked ‘Receivable’ or ‘Payable’ to blank.
I had to mark at-least 15+ accounts to this way. I understood that this is mainly due to change in ‘Chart of Accounts’ in the V5 as there is no
seperate chart of accounts for customers or suppliers. These 15+ accounts were created by my accountant while starting chart of accounts for indicating opening balance.
Do I need to be care full on any accounts structure due to this change ?