search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.05k stars 7.21k forks source link

ERPNEXT V13 to V14 update issues. #41367

Closed chanyork closed 5 months ago

chanyork commented 5 months ago

Information about bug

Update Issues from V13 to V14. Seems to be some Fiscal Year issue during Migrate Site.

Module

other

Version

ERPNext: v13.55.2 (HEAD) Frappe Framework: v13.58.21 (HEAD)

Installation method

FrappeCloud

Relevant log output / Stack trace / Full Error Message.

Migrating petpalace.erpnext.com
Executing execute:frappe.reload_doc('core', 'doctype', 'doctype_state', force=True) #2021-12-15 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.123s
Executing execute:frappe.reload_doc('core', 'doctype', 'doctype') #2022-06-21 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.786s
Executing frappe.patches.v13_0.jinja_hook in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.005s
Executing frappe.patches.v13_0.update_notification_channel_if_empty in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.53s
Executing execute:frappe.reload_doc('custom', 'doctype', 'custom_field') in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.565s
Executing frappe.email.doctype.email_queue.patches.drop_search_index_on_message_id in petpalace.erpnext.com (_6d85c5ba227a665f)
    Drop search index on message_id
Success: Done in 0.047s
Executing frappe.patches.v14_0.save_ratings_in_fraction #23-12-2021 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.244s
Executing frappe.patches.v14_0.transform_todo_schema in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.247s
Executing frappe.patches.v14_0.remove_post_and_post_comment in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.134s
Executing frappe.patches.v14_0.reset_creation_datetime in petpalace.erpnext.com (_6d85c5ba227a665f)
    Resetting creation datetimes for DocTypes
Success: Done in 0.507s
Executing frappe.patches.v14_0.remove_is_first_startup in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.005s
Executing frappe.patches.v14_0.clear_long_pending_stale_logs in petpalace.erpnext.com (_6d85c5ba227a665f)
    Due to large size of log tables on old sites some table cleanups never finished during daily log clean up. This patch discards such data by using "big delete" code.

        ref: https://github.com/frappe/frappe/issues/16971

Clearing old Scheduled Job Log records
Success: Done in 2.266s
Executing frappe.patches.v14_0.log_settings_migration in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.497s
Executing frappe.patches.v14_0.setup_likes_from_feedback in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.426s
Executing frappe.patches.v14_0.update_webforms in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.687s
Executing frappe.patches.v14_0.delete_payment_gateways in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.165s
Executing frappe.patches.v14_0.event_streaming_deprecation_warning in petpalace.erpnext.com (_6d85c5ba227a665f)
Event Streaming is moved to a separate app in version 15.
When upgrading to Frappe version-15, Please install the 'Event Streaming' app to continue using them: https://github.com/frappe/event_streaming
Success: Done in 0.005s
Executing execute:frappe.reload_doc("desk", "doctype", "Form Tour") in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.263s
Executing frappe.patches.v14_0.modify_value_column_size_for_singles in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.066s
Executing erpnext.patches.v14_0.change_is_subcontracted_fieldtype in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 5.799s
Executing erpnext.patches.v13_0.add_doctype_to_sla #14-06-2021 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.459s
Executing erpnext.patches.v13_0.update_response_by_variance in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.006s
Executing erpnext.patches.v14_0.update_opportunity_currency_fields in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.924s
Executing erpnext.patches.v13_0.healthcare_deprecation_warning in petpalace.erpnext.com (_6d85c5ba227a665f)
Healthcare Module is moved to a separate app and will be removed from ERPNext in version-14.
Please install the app to continue using the module: https://github.com/frappe/healthcare
Success: Done in 0.005s
Executing erpnext.patches.v13_0.create_ksa_vat_custom_fields # 07-01-2022 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.13s
Executing erpnext.patches.v14_0.migrate_crm_settings in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.133s
Executing erpnext.patches.v13_0.update_asset_quantity_field in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.005s
Executing erpnext.patches.v13_0.non_profit_deprecation_warning in petpalace.erpnext.com (_6d85c5ba227a665f)
Non Profit Domain is moved to a separate app and will be removed from ERPNext in version-14.
When upgrading to ERPNext version-14, please install the app to continue using the Non Profit domain: https://github.com/frappe/non_profit
Success: Done in 0.006s
Executing erpnext.patches.v14_0.update_reference_due_date_in_journal_entry in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.01s
Executing erpnext.patches.v14_0.france_depreciation_warning in petpalace.erpnext.com (_6d85c5ba227a665f)
Feature for region France will be remove in version-15 and moved to a separate app
Please install the app to continue using the regionnal France features: https://github.com/scopen-coop/erpnext_france.git
Success: Done in 0.005s
Executing erpnext.patches.v14_0.clear_reconciliation_values_from_singles in petpalace.erpnext.com (_6d85c5ba227a665f)

    Clear `tabSingles` and Payment Reconciliation tables of values

Success: Done in 0.007s
Updating DocTypes for frappe        : [========================================] 100%
Updating DocTypes for erpnext       : [========================================] 100%
Executing frappe.patches.v14_0.update_workspace2 # 06.06.2023 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 2.87s
Executing frappe.patches.v14_0.drop_data_import_legacy in petpalace.erpnext.com (_6d85c5ba227a665f)
`Data Import Legacy` has been deprecated. The DocType is deleted, but the data still exists on the database. If this data is worth recovering, you may export it using

    bench --site petpalace.erpnext.com backup -i 'Data Import Legacy'

After this, the table will continue to persist in the database, until you choose to remove it yourself. If you want to drop the table, you may run

    bench --site petpalace.erpnext.com execute frappe.db.sql --args "('DROP TABLE IF EXISTS `tabData Import Legacy`', )"

Success: Done in 0.227s
Executing frappe.patches.v14_0.copy_mail_data #08.03.21 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.152s
Executing frappe.patches.v14_0.update_github_endpoints #08-11-2021 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.006s
Executing frappe.patches.v14_0.remove_db_aggregation in petpalace.erpnext.com (_6d85c5ba227a665f)
    Replace temporarily available Database Aggregate APIs on frappe (develop)

        APIs changed:
                * frappe.db.max => frappe.qb.max
                * frappe.db.min => frappe.qb.min
                * frappe.db.sum => frappe.qb.sum
                * frappe.db.avg => frappe.qb.avg

Success: Done in 0.006s
Executing frappe.patches.v14_0.update_color_names_in_kanban_board_column in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.025s
Executing frappe.patches.v14_0.update_is_system_generated_flag in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.007s
Executing frappe.patches.v14_0.update_auto_account_deletion_duration in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.089s
Executing frappe.patches.v14_0.update_integration_request in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.008s
Executing frappe.patches.v14_0.set_document_expiry_default in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.007s
Executing frappe.patches.v14_0.delete_data_migration_tool in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.263s
Executing frappe.patches.v14_0.set_suspend_email_queue_default in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.251s
Executing frappe.patches.v14_0.different_encryption_key in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.006s
Executing frappe.patches.v14_0.update_multistep_webforms in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.147s
Executing frappe.patches.v14_0.drop_unused_indexes in petpalace.erpnext.com (_6d85c5ba227a665f)
��� dropped parent index from tabLoan
��� dropped parent index from tabLoan Type
��� dropped parent index from tabLoan Disbursement
��� dropped parent index from tabLoan Repayment
��� dropped parent index from tabGoCardless Settings
��� dropped parent index from tabSerial No
��� dropped parent index from tabRepost Item Valuation
��� dropped parent index from tabPacking Slip
- Skipped parent index for tabTerms and Conditions because it doesn't exist
��� dropped parent index from tabBranch
��� dropped parent index from tabDesignation
��� dropped parent index from tabAuthorization Rule
��� dropped parent index from tabPrint Heading
��� dropped parent index from tabVehicle
��� dropped parent index from tabDriver
��� dropped parent index from tabEmployee Group
��� dropped parent index from tabHoliday List
��� dropped parent index from tabSales Partner Type
��� dropped parent index from tabContract
��� dropped parent index from tabCampaign
��� dropped parent index from tabAppointment
��� dropped parent index from tabSales Stage
��� dropped parent index from tabExchange Rate Revaluation
��� dropped parent index from tabFiscal Year
- Skipped parent index for tabPurchase Taxes and Charges Template because it doesn't exist
- Skipped parent index for tabSales Taxes and Charges Template because it doesn't exist
��� dropped parent index from tabBank Transaction
��� dropped parent index from tabShareholder
��� dropped parent index from tabContact
��� dropped parent index from tabGender
��� dropped parent index from tabSalutation
��� dropped parent index from tabToken Cache
��� dropped parent index from tabCountry
��� dropped parent index from tabDocType Layout
��� dropped parent index from tabEmail Flag Queue
��� dropped parent index from tabNewsletter
��� dropped parent index from tabEmail Group Member
��� dropped parent index from tabEmail Queue
��� dropped parent index from tabWorkflow
��� dropped parent index from tabRole Profile
��� dropped parent index from tabDocument Share Key
��� dropped parent index from tabDeleted Document
��� dropped parent index from tabLanguage
- Skipped parent index for tabCustom DocPerm because it doesn't exist
��� dropped parent index from tabOpportunity
��� dropped parent index from tabService Level Agreement
��� dropped parent index from tabComment
��� dropped parent index from tabOAuth Client
��� dropped parent index from tabProject
��� dropped parent index from tabCost Center
��� dropped parent index from tabLower Deduction Certificate
��� dropped parent index from tabWeb Page
��� dropped parent index from tabLetter Head
- Skipped parent index for tabLedger Health because it doesn't exist
��� dropped parent index from tabServer Script
��� dropped parent index from tabSupplier Quotation
��� dropped parent index from tabCommunication
��� dropped parent index from tabSales Invoice
��� dropped parent index from tabTransaction Deletion Record
��� dropped parent index from tabPurchase Receipt
��� dropped parent index from tabDelivery Note
��� dropped parent index from tabSales Order
��� dropped parent index from tabQuotation
��� dropped parent index from tabPurchase Order
��� dropped parent index from tabPOS Invoice
��� dropped parent index from tabPurchase Invoice
��� dropped parent index from tabGL Entry
��� dropped parent index from tabRole
��� dropped parent index from tabItem Price
��� dropped parent index from tabConsole Log
��� dropped parent index from tabCustom Field
��� dropped parent index from tabProduction Plan
��� dropped parent index from tabItem Group
��� dropped parent index from tabWork Order
��� dropped parent index from tabUser
��� dropped parent index from tabStock Ledger Entry
��� dropped parent index from tabWebhook
��� dropped parent index from tabBank Account
��� dropped parent index from tabData Import
��� dropped parent index from tabPick List
��� dropped parent index from tabWarehouse
��� dropped parent index from tabAsset
��� dropped parent index from tabStock Entry
��� dropped parent index from tabItem
��� dropped parent index from tabEmployee
��� dropped parent index from tabHelp Article
��� dropped parent index from tabCashier Closing
��� dropped parent index from tabCustomer
��� dropped parent index from tabBOM
��� dropped parent index from tabProcess Statement Of Accounts
��� dropped parent index from tabWeb Template
��� dropped parent index from tabEmail Template
��� dropped parent index from tabPrint Format
��� dropped parent index from tabRoute History
��� dropped parent index from tabLead
��� dropped parent index from tabDocType
- Skipped parent index for tabBisect Nodes because it doesn't exist
��� dropped parent index from tabNotification Settings
- Skipped parent index for tabAsset Shift Factor because it doesn't exist
- Skipped parent index for tabAsset Shift Allocation because it doesn't exist
��� dropped parent index from tabWarranty Claim
��� dropped parent index from tabEmail Group
- Skipped parent index for tabCompetitor because it doesn't exist
��� dropped parent index from tabQuotation Lost Reason
��� dropped parent index from tabJournal Entry
��� dropped parent index from tabPayment Entry
��� dropped parent index from tabProduct Bundle
��� dropped parent index from tabAddress
��� dropped parent index from tabLeave Ledger Entry
��� dropped parent index from tabNotification
- Skipped parent index for tabSubcontracting Receipt because it doesn't exist
- Skipped parent index for tabBulk Transaction Log Detail because it doesn't exist
��� dropped parent index from tabNumber Card
��� dropped parent index from tabBatch
- Skipped parent index for tabPayment Ledger Entry because it doesn't exist
- Skipped parent index for tabRequest for Quotation because it doesn't exist
- Skipped parent index for tabProcess Payment Reconciliation Log because it doesn't exist
��� dropped parent index from tabBin
��� dropped parent index from tabCompany
��� dropped parent index from tabSupplier
��� dropped parent index from tabWeb Form
��� dropped parent index from tabIntegration Request
- Skipped parent index for tabInventory Dimension because it doesn't exist
��� dropped parent index from tabToDo
- Skipped parent index for tabAsset Capitalization because it doesn't exist
��� dropped parent index from tabTask
- Skipped parent index for tabRepost Payment Ledger because it doesn't exist
- Skipped parent index for tabRepost Accounting Ledger because it doesn't exist
��� dropped parent index from tabHotel Room Package
��� dropped parent index from tabHotel Room Type
��� dropped parent index from tabHotel Room Reservation
��� dropped parent index from tabHotel Room Pricing
��� dropped parent index from tabHotel Room
��� dropped parent index from tabGrant Application
��� dropped parent index from tabChapter
��� dropped parent index from tabCertified Consultant
��� dropped parent index from tabDonor Type
��� dropped parent index from tabVolunteer Type
��� dropped parent index from tabCertification Application
��� dropped parent index from tabTally Migration
��� dropped parent index from tabGoCardless Mandate
��� dropped parent index from tabShopify Log
��� dropped parent index from tabWeather
��� dropped parent index from tabSoil Texture
��� dropped parent index from tabCrop Cycle
��� dropped parent index from tabDisease
��� dropped parent index from tabSoil Analysis
��� dropped parent index from tabWater Analysis
��� dropped parent index from tabCrop
��� dropped parent index from tabFertilizer
��� dropped parent index from tabAgriculture Analysis Criteria
��� dropped parent index from tabPlant Analysis
��� dropped parent index from tabRestaurant Reservation
��� dropped parent index from tabRestaurant Table
��� dropped parent index from tabRestaurant Menu
��� dropped parent index from tabRestaurant
��� dropped parent index from tabDiagnosis
��� dropped parent index from tabComplaint
��� dropped parent index from tabPrescription Dosage
��� dropped parent index from tabLab Test UOM
��� dropped parent index from tabPrescription Duration
��� dropped parent index from tabDosage Form
��� dropped parent index from tabMedical Department
��� dropped parent index from tabSensitivity
��� dropped parent index from tabMedical Code Standard
- Skipped parent index for tabGSTR 3B Report because it doesn't exist
- Skipped parent index for tabE Invoice Request Log because it doesn't exist
��� dropped parent index from tabAcademic Term
��� dropped parent index from tabGrading Scale
��� dropped parent index from tabCourse Enrollment
��� dropped parent index from tabGuardian
��� dropped parent index from tabStudent Group
��� dropped parent index from tabStudent Language
��� dropped parent index from tabProgram
��� dropped parent index from tabArticle
��� dropped parent index from tabStudent Category
��� dropped parent index from tabAssessment Group
��� dropped parent index from tabAcademic Year
��� dropped parent index from tabCourse
��� dropped parent index from tabQuestion
��� dropped parent index from tabAssessment Criteria
��� dropped parent index from tabCourse Activity
��� dropped parent index from tabFee Category
��� dropped parent index from tabAssessment Criteria Group
��� dropped parent index from tabRoom
��� dropped parent index from tabStudent Batch Name
��� dropped parent index from tabStudent Log
��� dropped parent index from tabSchool House
��� dropped parent index from tabTopic
��� dropped parent index from tabHomepage Section
��� dropped parent index from tabAsset Maintenance
��� dropped parent index from tabSMS Log
��� dropped parent index from tabIssue Priority
��� dropped parent index from tabIssue Type
��� dropped parent index from tabPrice List
��� dropped parent index from tabManufacturer
��� dropped parent index from tabUOM Category
��� dropped parent index from tabItem Manufacturer
��� dropped parent index from tabItem Alternative
��� dropped parent index from tabItem Attribute
��� dropped parent index from tabRouting
��� dropped parent index from tabAttendance
��� dropped parent index from tabTraining Result
��� dropped parent index from tabJob Applicant Source
��� dropped parent index from tabEmployee Promotion
��� dropped parent index from tabEmployee Health Insurance
��� dropped parent index from tabInterest
��� dropped parent index from tabEmployee Onboarding Template
��� dropped parent index from tabTraining Program
��� dropped parent index from tabEmployee Transfer Property
��� dropped parent index from tabDaily Work Summary Group
��� dropped parent index from tabIdentification Document Type
- Skipped parent index for tabPurpose of Travel because it doesn't exist
��� dropped parent index from tabLeave Block List
��� dropped parent index from tabOffer Term
��� dropped parent index from tabEmployee Transfer
��� dropped parent index from tabTraining Feedback
��� dropped parent index from tabEmployee Separation
��� dropped parent index from tabShift Type
��� dropped parent index from tabEmployment Type
��� dropped parent index from tabEmployee Separation Template
��� dropped parent index from tabDaily Work Summary
��� dropped parent index from tabLeave Policy
��� dropped parent index from tabStaffing Plan
��� dropped parent index from tabCurrency Exchange
��� dropped parent index from tabUOM Conversion Factor
��� dropped parent index from tabSales Person
��� dropped parent index from tabParty Type
��� dropped parent index from tabSales Partner
��� dropped parent index from tabInstallation Note
��� dropped parent index from tabProject Update
��� dropped parent index from tabActivity Type
��� dropped parent index from tabActivity Cost
��� dropped parent index from tabProject Type
��� dropped parent index from tabSupplier Scorecard Standing
��� dropped parent index from tabSupplier Scorecard Period
��� dropped parent index from tabSupplier Scorecard Variable
��� dropped parent index from tabSupplier Scorecard
��� dropped parent index from tabOpportunity Type
��� dropped parent index from tabMarket Segment
��� dropped parent index from tabCheque Print Template
��� dropped parent index from tabCash Flow Mapping Template
��� dropped parent index from tabCash Flow Mapping
��� dropped parent index from tabMonthly Distribution
- Skipped parent index for tabC-Form because it doesn't exist
��� dropped parent index from tabAccounting Period
��� dropped parent index from tabBank Guarantee
��� dropped parent index from tabShare Transfer
��� dropped parent index from tabShare Type
��� dropped parent index from tabFinance Book
��� dropped parent index from tabCash Flow Mapper
��� dropped parent index from tabInvoice Discounting
��� dropped parent index from tabCoupon Code
��� dropped parent index from tabLoyalty Program
��� dropped parent index from tabShipping Rule
��� dropped parent index from tabBank Account Subtype
��� dropped parent index from tabPayment Terms Template
��� dropped parent index from tabPayment Order
��� dropped parent index from tabMilestone Tracker
��� dropped parent index from tabMilestone
��� dropped parent index from tabAddress Template
��� dropped parent index from tabPrint Style
��� dropped parent index from tabGoogle Calendar
��� dropped parent index from tabDesktop Icon
��� dropped parent index from tabTag
��� dropped parent index from tabList Filter
��� dropped parent index from tabUnhandled Email
��� dropped parent index from tabEmail Rule
��� dropped parent index from tabEmail Unsubscribe
��� dropped parent index from tabAuto Email Report
��� dropped parent index from tabWebsite Sidebar
��� dropped parent index from tabWebsite Route Meta
��� dropped parent index from tabWebsite Slideshow
��� dropped parent index from tabHelp Category
��� dropped parent index from tabPersonal Data Download Request
��� dropped parent index from tabCustom Role
��� dropped parent index from tabTransaction Log
��� dropped parent index from tabVersion
��� dropped parent index from tabSuccess Action
��� dropped parent index from tabPage
��� dropped parent index from tabTraining Event
��� dropped parent index from tabCompensatory Leave Request
��� dropped parent index from tabLeave Application
��� dropped parent index from tabWarehouse Type
��� dropped parent index from tabSubscription
��� dropped parent index from tabJob Offer
��� dropped parent index from tabWebsite Theme
��� dropped parent index from tabEnergy Point Rule
��� dropped parent index from tabDashboard Chart
��� dropped parent index from tabMaterial Request
��� dropped parent index from tabWebsite Item
��� dropped parent index from tabPeriod Closing Voucher
��� dropped parent index from tabQuality Procedure
��� dropped parent index from tabLocation
- Skipped parent index for tabUnreconcile Payment because it doesn't exist
��� dropped parent index from tabDepartment
- Skipped parent index for tabProcess Payment Reconciliation because it doesn't exist
��� dropped parent index from tabNon Conformance
��� dropped parent index from tabActivity Log
��� dropped parent index from tabFile
��� dropped parent index from tabDATEV Settings
��� dropped parent index from tabAsset Movement
��� dropped parent index from tabDelivery Trip
��� dropped parent index from tabDocShare
��� dropped parent index from tabNotification Log
��� dropped parent index from tabJob Card
��� dropped parent index from tabWorkspace
��� dropped parent index from tabEmail Account
��� dropped parent index from tabEmail Domain
- Skipped parent index for tabCustom HTML Block because it doesn't exist
��� dropped parent index from tabForm Tour
- Skipped parent index for tabClosing Stock Balance because it doesn't exist
��� dropped parent index from tabPatch Log
��� dropped parent index from tabIncome Tax Slab
��� dropped parent index from tabDocument Naming Rule
��� dropped parent index from tabTimesheet
��� dropped parent index from tabWorkflow Action Master
��� dropped parent index from tabAccount
��� dropped parent index from tabReport
��� dropped parent index from tabOAuth Bearer Token
��� dropped parent index from tabWorkflow State
- Skipped parent index for tabAccount Closing Balance because it doesn't exist
��� dropped parent index from tabWebhook Request Log
��� dropped parent index from tabBlog Post
��� dropped parent index from tabPricing Rule
��� dropped parent index from tabIndustry Type
��� dropped parent index from tabLead Source
��� dropped parent index from tabSalary Structure Assignment
��� dropped parent index from tabTerritory
��� dropped parent index from tabSupplier Group
��� dropped parent index from tabCustomer Group
��� dropped parent index from tabPayment Request
- Skipped parent index for tabIncoterm because it doesn't exist
��� dropped parent index from tabShipment
- Skipped parent index for tabWorkstation Type because it doesn't exist
��� dropped parent index from tabWorkstation
- Skipped parent index for tabProspect because it doesn't exist
��� dropped parent index from tabBudget
��� dropped parent index from tabQuality Inspection
��� dropped parent index from tabEnergy Point Log
��� dropped parent index from tabWeb Page View
��� dropped parent index from tabBank Statement Import
��� dropped parent index from tabTask Type
��� dropped parent index from tabSalary Slip
��� dropped parent index from tabAsset Repair
- Skipped parent index for tabSubcontracting Order because it doesn't exist
��� dropped parent index from tabEvent
��� dropped parent index from tabPOS Profile
��� dropped parent index from tabPOS Closing Entry
��� dropped parent index from tabPOS Invoice Merge Log
��� dropped parent index from tabEmployee Checkin
��� dropped parent index from tabShift Assignment
��� dropped parent index from tabLoan Balance Adjustment
��� dropped parent index from tabCurrency
��� dropped parent index from tabTranslation
��� dropped parent index from tabLoan Security Shortfall
��� dropped parent index from tabLoan Interest Accrual
��� dropped parent index from tabProcess Loan Interest Accrual
��� dropped parent index from tabScheduled Job Type
��� dropped parent index from tabLoan Refund
��� dropped parent index from tabBOM Update Log
��� dropped parent index from tabError Log
��� dropped parent index from tabAccess Log
��� dropped parent index from tabScheduled Job Log
��� dropped parent index from tabUser Type
��� dropped parent index from tabGratuity
��� dropped parent index from tabEmployee Advance
��� dropped parent index from tabGST HSN Code
��� dropped parent index from tabStock Reconciliation
��� dropped parent index from tabLeave Type
��� dropped parent index from tabPrepared Report
��� dropped parent index from tabCall Log
��� dropped parent index from tabKanban Board
��� dropped parent index from tabClient Script
��� dropped parent index from tabLeave Allocation
��� dropped parent index from tabHealthcare Service Unit
��� dropped parent index from tabMembership
- Skipped parent index for tabTax Exemption 80G Certificate because it doesn't exist
��� dropped parent index from tabDonation
��� dropped parent index from tabProperty Setter
��� dropped parent index from tabTelephony Call Type
��� dropped parent index from tabWorkflow Action
��� dropped parent index from tabInpatient Record
��� dropped parent index from tabVital Signs
��� dropped parent index from tabOpportunity Lost Reason
��� dropped parent index from tabSalary Structure
- Skipped parent index for tabCost Center Allocation because it doesn't exist
��� dropped parent index from tabSample Collection
��� dropped parent index from tabLab Test
��� dropped parent index from tabTax Category
��� dropped parent index from tabItem Tax Template
��� dropped parent index from tabLeave Policy Assignment
��� dropped parent index from tabLeave Period
��� dropped parent index from tabJob Applicant
��� dropped parent index from tabConnected App
��� dropped parent index from tabModule Def
��� dropped parent index from tabUser Permission
- Skipped parent index for tabData Import Log because it doesn't exist
��� dropped parent index from tabMaintenance Visit
��� dropped parent index from tabPersonal Data Deletion Request
- Skipped parent index for tabLedger Merge because it doesn't exist
��� dropped parent index from tabSubscription Plan
��� dropped parent index from tabModule Profile
��� dropped parent index from tabOnboarding Step
��� dropped parent index from tabOperation
��� dropped parent index from tabIssue
��� dropped parent index from tabCourse Schedule
��� dropped parent index from tabExpense Claim
��� dropped parent index from tabSupplier Scorecard Criteria
��� dropped parent index from tabError Snapshot
��� dropped parent index from tabView Log
- Skipped parent index for tabPrint Format Field Template because it doesn't exist
��� dropped parent index from tabUOM
��� dropped parent index from tabNetwork Printer Settings
��� dropped parent index from tabInterview Feedback
��� dropped parent index from tabInterview
��� dropped parent index from tabInterview Round
��� dropped parent index from tabInterview Type
��� dropped parent index from tabDiscussion Topic
��� dropped parent index from tabDiscussion Reply
��� dropped parent index from tabTag Link
��� dropped parent index from tabNote
��� dropped parent index from tabParty Specific Item
- Skipped parent index for tabPackage Import because it doesn't exist
- Skipped parent index for tabPackage Release because it doesn't exist
- Skipped parent index for tabPackage because it doesn't exist
��� dropped parent index from tabFee Validity
��� dropped parent index from tabKSA VAT Setting
��� dropped parent index from tabParty Link
��� dropped parent index from tabHealthcare Practitioner
��� dropped parent index from tabProduct Tax Category
��� dropped parent index from tabHealthcare Service Unit Type
��� dropped parent index from tabPatient Appointment
��� dropped parent index from tabTreatment Plan Template
��� dropped parent index from tabItem Review
��� dropped parent index from tabTax Withholding Category
��� dropped parent index from tabPatient Encounter
��� dropped parent index from tabAssignment Rule
��� dropped parent index from tabSouth Africa VAT Settings
��� dropped parent index from tabMember
��� dropped parent index from tabWishlist
��� dropped parent index from tabLoan Security Pledge
��� dropped parent index from tabBlanket Order
��� dropped parent index from tabGrievance Type
��� dropped parent index from tabEmployee Grievance
��� dropped parent index from tabTax Rule
��� dropped parent index from tabMaintenance Schedule
��� dropped parent index from tabAdditional Salary
��� dropped parent index from tabStock Entry Type
��� dropped parent index from tabVehicle Log
��� dropped parent index from tabSlack Webhook URL
��� dropped parent index from tabPromotional Scheme
��� dropped parent index from tabEmployee Referral
��� dropped parent index from tabOAuth Authorization Code
��� dropped parent index from tabImport Supplier Invoice
��� dropped parent index from tabLoan Application
��� dropped parent index from tabLoan Security Unpledge
��� dropped parent index from tabLoan Write Off
��� dropped parent index from tabUser Group
��� dropped parent index from tabSocial Media Post
��� dropped parent index from tabRetention Bonus
��� dropped parent index from tabEmployee Tax Exemption Proof Submission
��� dropped parent index from tabEmployee Tax Exemption Declaration
��� dropped parent index from tabEmployee Incentive
��� dropped parent index from tabEmployee Benefit Claim
��� dropped parent index from tabEmployee Benefit Application
��� dropped parent index from tabLeave Encashment
��� dropped parent index from tabStudent Attendance
��� dropped parent index from tabPatient
��� dropped parent index from tabMpesa Settings
��� dropped parent index from tabStudent Applicant
��� dropped parent index from tabBrand
��� dropped parent index from tabQuality Meeting
��� dropped parent index from tabSkill
��� dropped parent index from tabAsset Category
��� dropped parent index from tabQuality Inspection Parameter
��� dropped parent index from tabDonor
��� dropped parent index from tabPayment Term
��� dropped parent index from tabAccounting Dimension
��� dropped parent index from tabQuality Inspection Parameter Group
��� dropped parent index from tabAccounting Dimension Filter
��� dropped parent index from tabLanded Cost Voucher
��� dropped parent index from tabAsset Maintenance Team
��� dropped parent index from tabAsset Value Adjustment
��� dropped parent index from tabAsset Maintenance Log
��� dropped parent index from tabAppointment Type
��� dropped parent index from tabLoan Security Price
��� dropped parent index from tabProcess Loan Security Shortfall
- Skipped parent index for tabTest rename new because it doesn't exist
��� dropped parent index from tabAuto Repeat
��� dropped parent index from tabInpatient Medication Entry
��� dropped parent index from tabUAE VAT Settings
��� dropped parent index from tabQuiz
��� dropped parent index from tabQuiz Activity
��� dropped parent index from tabPayroll Entry
��� dropped parent index from tabVoice Call Settings
��� dropped parent index from tabContract Template
��� dropped parent index from tabGratuity Rule
��� dropped parent index from tabPutaway Rule
��� dropped parent index from tabIncoming Call Settings
��� dropped parent index from tabTherapy Session
��� dropped parent index from tabTherapy Plan
��� dropped parent index from tabCommunication Medium
��� dropped parent index from tabQuality Action
��� dropped parent index from tabQuality Feedback
��� dropped parent index from tabQuality Feedback Template
��� dropped parent index from tabQuality Goal
��� dropped parent index from tabEvent Producer Last Update
��� dropped parent index from tabEvent Producer
��� dropped parent index from tabLoan Security
��� dropped parent index from tabAssessment Plan
��� dropped parent index from tabQuality Review
��� dropped parent index from tabTherapy Plan Template
��� dropped parent index from tabSalary Component
��� dropped parent index from tabAppraisal
��� dropped parent index from tabInpatient Medication Order
��� dropped parent index from tabSocial Login Key
��� dropped parent index from tabBlog Category
��� dropped parent index from tabShipment Parcel Template
��� dropped parent index from tabStudent Leave Application
��� dropped parent index from tabPayment Gateway Account
- Skipped parent index for tabMode of Payment because it doesn't exist
��� dropped parent index from tabDomain
��� dropped parent index from tabCalendar View
��� dropped parent index from tabGoogle Contacts
��� dropped parent index from tabAppraisal Template
��� dropped parent index from tabExpense Claim Type
��� dropped parent index from tabPractitioner Schedule
��� dropped parent index from tabJob Opening
��� dropped parent index from tabStudent Admission
��� dropped parent index from tabDocument Follow
��� dropped parent index from tabVolunteer
��� dropped parent index from tabProgram Enrollment
��� dropped parent index from tabEvent Consumer
��� dropped parent index from tabStudent
��� dropped parent index from tabVideo
��� dropped parent index from tabEvent Update Log
��� dropped parent index from tabProcess Deferred Accounting
��� dropped parent index from tabEmployee Grade
��� dropped parent index from tabEmail Digest
��� dropped parent index from tabShift Request
��� dropped parent index from tabMembership Type
��� dropped parent index from tabFees
��� dropped parent index from tabDunning
��� dropped parent index from tabAssessment Result
��� dropped parent index from tabLab Test Template
��� dropped parent index from tabInstructor
��� dropped parent index from tabDashboard
��� dropped parent index from tabFee Schedule
��� dropped parent index from tabBank
��� dropped parent index from tabDunning Type
��� dropped parent index from tabEmail Campaign
��� dropped parent index from tabPayroll Period
��� dropped parent index from tabClinical Procedure
��� dropped parent index from tabTherapy Type
��� dropped parent index from tabClinical Procedure Template
��� dropped parent index from tabMedical Code
��� dropped parent index from tabDashboard Chart Source
��� dropped parent index from tabCustoms Tariff Number
��� dropped parent index from tabEmployee Onboarding
��� dropped parent index from tabPatient Assessment
��� dropped parent index from tabEmployee Tax Exemption Sub Category
��� dropped parent index from tabEmployee Tax Exemption Category
��� dropped parent index from tabEmployee Other Income
��� dropped parent index from tabFee Structure
��� dropped parent index from tabModule Onboarding
��� dropped parent index from tabPOS Opening Entry
��� dropped parent index from tabBlogger
��� dropped parent index from tabDowntime Entry
��� dropped parent index from tabLoan Security Type
��� dropped parent index from tabList View Settings
��� dropped parent index from tabJournal Entry Template
��� dropped parent index from tabPatient Medical Record
��� dropped parent index from tabQuality Inspection Template
��� dropped parent index from tabProject Template
��� dropped parent index from tabPatient Assessment Template
��� dropped parent index from tabExercise Type
��� dropped parent index from tabPatient Assessment Parameter
��� dropped parent index from tabColor
��� dropped parent index from tabBank Account Type
��� dropped parent index from tabBody Part
��� dropped parent index from tabDashboard Settings
��� dropped parent index from tabExercise Difficulty Level
��� dropped parent index from tabSanctioned Loan Amount
��� dropped parent index from tabLoyalty Point Entry
��� dropped parent index from tabLab Test Sample
��� dropped parent index from tabAppointment Letter
��� dropped parent index from tabAppointment Letter Template
��� dropped parent index from tabAttendance Request
��� dropped parent index from tabEmployee Skill Map
��� dropped parent index from tabTravel Request
��� dropped parent index from tabHub Tracked Item
��� dropped parent index from tabDocument Type Mapping
��� dropped parent index from tabEvent Sync Log
��� dropped parent index from tabOrganism
��� dropped parent index from tabAntibiotic
��� dropped link_doctype_link_name_index index from tabComment
��� dropped link_doctype_link_name_index index from tabActivity Log
Success: Done in 21.419s
Executing frappe.patches.v14_0.disable_email_accounts_with_oauth in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.273s
Executing frappe.patches.v14_0.remove_manage_subscriptions_from_navbar in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.068s
Executing frappe.core.doctype.system_settings.patches.set_default_rounding_method in petpalace.erpnext.com (_6d85c5ba227a665f)
    set default rounding method
Success: Done in 0.009s
Executing frappe.patches.v14_0.remove_background_jobs_from_dropdown in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 3.619s
Executing execute:frappe.delete_doc("Page", "translation-tool", force=1) in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.07s
Executing frappe.patches.v15_0.remove_prepared_report_settings_from_system_settings in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.053s
Executing frappe.desk.doctype.form_tour.patches.introduce_ui_tours in petpalace.erpnext.com (_6d85c5ba227a665f)
    Handle introduction of UI tours
Success: Done in 0.045s
Executing execute:frappe.delete_doc_if_exists("Workspace", "Customization") in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.167s
Executing frappe.patches.v15_0.set_file_type in petpalace.erpnext.com (_6d85c5ba227a665f)
    Set 'File Type' for all files based on file extension.
Success: Done in 0.126s
Executing frappe.core.doctype.data_import.patches.remove_stale_docfields_from_legacy_version in petpalace.erpnext.com (_6d85c5ba227a665f)
    Remove stale docfields from legacy version
Success: Done in 0.005s
Executing frappe.patches.v15_0.sanitize_workspace_titles in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.007s
Executing frappe.integrations.doctype.oauth_client.patches.set_default_allowed_role_in_oauth_client in petpalace.erpnext.com (_6d85c5ba227a665f)
    Set default allowed role in OAuth Client
Success: Done in 0.04s
Executing execute:frappe.delete_doc_if_exists('Workspace', 'ERPNext Integrations Settings') in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.03s
Executing erpnext.patches.v14_0.update_posting_datetime_and_dropped_indexes #22-02-2024 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.04s
Executing erpnext.patches.v14_0.rename_ongoing_status_in_sla_documents in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.008s
Executing erpnext.patches.v14_0.delete_shopify_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.247s
Executing erpnext.patches.v14_0.delete_healthcare_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 4.209s
Executing erpnext.patches.v14_0.delete_hub_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.121s
Executing erpnext.patches.v14_0.delete_hospitality_doctypes # 20-01-2022 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.535s
Executing erpnext.patches.v14_0.delete_agriculture_doctypes # 15-06-2022 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.85s
Executing erpnext.patches.v14_0.delete_education_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Education Module is moved to a separate appPlease install the app to continue using the module: https://github.com/frappe/education
Success: Done in 3.098s
Executing erpnext.patches.v14_0.delete_datev_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.067s
Executing erpnext.patches.v14_0.rearrange_company_fields in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 3.081s
Executing erpnext.patches.v14_0.migrate_cost_center_allocations in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.033s
Executing erpnext.patches.v13_0.update_exchange_rate_settings in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 1.324s
Executing erpnext.patches.v14_0.delete_amazon_mws_doctype in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.061s
Executing erpnext.patches.v14_0.update_batch_valuation_flag in petpalace.erpnext.com (_6d85c5ba227a665f)

    - Don't use batchwise valuation for existing batches.
    - Only batches created after this patch shoule use it.

Success: Done in 0.005s
Executing erpnext.patches.v14_0.delete_non_profit_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 1.048s
Executing erpnext.patches.v14_0.discount_accounting_separation in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.008s
Executing execute:frappe.delete_doc("DocType", "Naming Series") in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.05s
Executing erpnext.patches.v14_0.copy_is_subcontracted_value_to_is_old_subcontracting_flow in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.012s
Executing erpnext.patches.v14_0.crm_ux_cleanup in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.223s
Executing erpnext.patches.v14_0.migrate_existing_lead_notes_as_per_the_new_format in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.033s
Executing erpnext.patches.v14_0.remove_india_localisation # 14-07-2022 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.565s
Executing erpnext.patches.v14_0.remove_hr_and_payroll_modules # 20-07-2022 in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 6.268s
Executing erpnext.patches.v14_0.fix_crm_no_of_employees in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.019s
Executing erpnext.patches.v14_0.create_accounting_dimensions_in_subcontracting_doctypes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.037s
Executing erpnext.patches.v14_0.fix_subcontracting_receipt_gl_entries in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.259s
Executing erpnext.patches.v13_0.drop_unused_sle_index_parts in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.225s
Executing erpnext.patches.v14_0.create_accounting_dimensions_for_asset_capitalization in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.005s
Executing erpnext.patches.v14_0.update_partial_tds_fields in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.007s
Executing erpnext.patches.v14_0.create_incoterms_and_migrate_shipment in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.102s
Executing erpnext.patches.v14_0.setup_clear_repost_logs in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.065s
Executing erpnext.patches.v14_0.create_accounting_dimensions_for_payment_request in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.006s
Executing erpnext.patches.v14_0.update_entry_type_for_journal_entry in petpalace.erpnext.com (_6d85c5ba227a665f)

    Update Propery Setters for Journal Entry with new 'Entry Type'

Success: Done in 0.047s
Executing erpnext.patches.v14_0.change_autoname_for_tax_withheld_vouchers in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.007s
Executing erpnext.patches.v14_0.update_asset_value_for_manual_depr_entries in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.009s
Executing erpnext.patches.v14_0.set_pick_list_status in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.009s
Executing erpnext.patches.v14_0.enable_all_leads in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.006s
Executing execute:frappe.db.set_single_value("Accounts Settings", "merge_similar_account_heads", 0) in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.008s
Executing erpnext.patches.v14_0.update_reference_type_in_journal_entry_accounts in petpalace.erpnext.com (_6d85c5ba227a665f)

    Update Propery Setters for Journal Entry with new 'Entry Type'

Success: Done in 0.011s
Executing erpnext.patches.v14_0.update_company_in_ldc in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.05s
Executing erpnext.patches.v14_0.set_packed_qty_in_draft_delivery_notes in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.007s
Executing erpnext.patches.v14_0.cleanup_workspaces in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.069s
Executing erpnext.patches.v14_0.enable_allow_existing_serial_no in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.008s
Executing erpnext.patches.v14_0.set_report_in_process_SOA in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.005s
Executing erpnext.patches.v14_0.create_accounting_dimensions_for_closing_balance in petpalace.erpnext.com (_6d85c5ba227a665f)
Success: Done in 0.005s
Executing erpnext.patches.v14_0.update_closing_balances #15-07-2023 in petpalace.erpnext.com (_6d85c5ba227a665f)

Traceback with variables (most recent call last):
  File "/usr/lib/python3.10/runpy.py", line 196, in _run_module_as_main
    return _run_code(code, main_globals, None,
      mod_name = 'frappe.utils.bench_helper'
      alter_argv = True
      mod_spec = ModuleSpec(name='frappe.utils.bench_helper', loader=<_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>, origin='/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py')
      code = <code object <module> at 0x7f85b18dfd60, file "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 1>
      main_globals = {'__name__': '__main__', '__doc__': None, '__package__': 'frappe.utils', '__loader__': <_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>, '__spec__': ModuleSpec(name='frappe.utils.bench_helper', loader=<_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>, origin='/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py'), '__annotations__': {}, '__builtins__': <module 'builtins' (built-in)>, '__file__': '/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py', '__cached__': '/home/frappe/frappe-bench/apps/frappe/frappe/utils/__pycache__/bench_helper.cpython-310.pyc', 'importlib': <module 'importlib' from '/usr/lib/python3.10/importlib/__init__.py'>, 'json': <module 'json' from '/usr/lib/python3.10/json/__init__.py'>, 'os': <module 'os' from '/usr/lib/python3.10/os.py'>, 'traceback': <module 'traceback' from '/usr/lib/python3.10/traceback.py'>, 'warnings': <module 'warnings' from '/usr/lib/python3.10/warnings.py'>, 'click': <m...
  File "/usr/lib/python3.10/runpy.py", line 86, in _run_code
    exec(code, run_globals)
      code = <code object <module> at 0x7f85b18dfd60, file "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 1>
      run_globals = {'__name__': '__main__', '__doc__': None, '__package__': 'frappe.utils', '__loader__': <_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>, '__spec__': ModuleSpec(name='frappe.utils.bench_helper', loader=<_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>, origin='/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py'), '__annotations__': {}, '__builtins__': <module 'builtins' (built-in)>, '__file__': '/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py', '__cached__': '/home/frappe/frappe-bench/apps/frappe/frappe/utils/__pycache__/bench_helper.cpython-310.pyc', 'importlib': <module 'importlib' from '/usr/lib/python3.10/importlib/__init__.py'>, 'json': <module 'json' from '/usr/lib/python3.10/json/__init__.py'>, 'os': <module 'os' from '/usr/lib/python3.10/os.py'>, 'traceback': <module 'traceback' from '/usr/lib/python3.10/traceback.py'>, 'warnings': <module 'warnings' from '/usr/lib/python3.10/warnings.py'>, 'click': <m...
      init_globals = None
      mod_name = '__main__'
      mod_spec = ModuleSpec(name='frappe.utils.bench_helper', loader=<_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>, origin='/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py')
      pkg_name = 'frappe.utils'
      script_name = None
      loader = <_frozen_importlib_external.SourceFileLoader object at 0x7f85b2e9f8e0>
      fname = '/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py'
      cached = '/home/frappe/frappe-bench/apps/frappe/frappe/utils/__pycache__/bench_helper.cpython-310.pyc'
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 109, in <module>
    main()
      ...skipped... 25 vars
  File "/home/frappe/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
    click.Group(commands=commands)(prog_name="bench")
      commands = {'frappe': <Group frappe>, 'get-frappe-commands': <Command get-frappe-commands>, 'get-frappe-help': <Command get-frappe-help>}
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
      self = <Group None>
      args = ()
      kwargs = {'prog_name': 'bench'}
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
      self = <Group None>
      args = ['frappe', '--site', 'petpalace.erpnext.com', 'migrate', '--skip-search-index']
      prog_name = 'bench'
      complete_var = None
      standalone_mode = True
      extra = {}
      ctx = <click.core.Context object at 0x7f85b16ab280>
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
      _process_result = <function MultiCommand.invoke.<locals>._process_result at 0x7f85b16c36d0>
      args = ['migrate', '--skip-search-index']
      cmd_name = 'frappe'
      cmd = <Group frappe>
      sub_ctx = <click.core.Context object at 0x7f85b173fbe0>
      ctx = <click.core.Context object at 0x7f85b16ab280>
      self = <Group None>
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
      _process_result = <function MultiCommand.invoke.<locals>._process_result at 0x7f85b174b010>
      args = []
      cmd_name = 'migrate'
      cmd = <Command migrate>
      sub_ctx = <click.core.Context object at 0x7f85b173fd60>
      ctx = <click.core.Context object at 0x7f85b173fbe0>
      self = <Group frappe>
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
      self = <Command migrate>
      ctx = <click.core.Context object at 0x7f85b173fd60>
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
      args = ()
      kwargs = {'skip_search_index': True, 'skip_failing': False}
      self = <click.core.Context object at 0x7f85b173fd60>
      callback = <function migrate at 0x7f85b16ef2e0>
      ctx = <click.core.Context object at 0x7f85b173fd60>
  File "/home/frappe/frappe-bench/env/lib/python3.10/site-packages/click/decorators.py", line 21, in new_func
    return f(get_current_context(), *args, **kwargs)
      args = ()
      kwargs = {'skip_search_index': True, 'skip_failing': False}
      f = <function migrate at 0x7f85b16ef0a0>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 29, in _func
    ret = f(frappe._dict(ctx.obj), *args, **kwargs)
      ctx = <click.core.Context object at 0x7f85b173fd60>
      args = ()
      kwargs = {'skip_search_index': True, 'skip_failing': False}
      profile = False
      f = <function migrate at 0x7f85b16ef010>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/commands/site.py", line 671, in migrate
    SiteMigration(
      context = {'sites': ['petpalace.erpnext.com'], 'force': False, 'verbose': False, 'profile': False}
      skip_failing = False
      skip_search_index = True
      activate_by_import = <module 'traceback_with_variables.activate_by_import' from '/home/frappe/frappe-bench/env/lib/python3.10/site-packages/traceback_with_variables/activate_by_import.py'>
      SiteMigration = <class 'frappe.migrate.SiteMigration'>
      site = 'petpalace.erpnext.com'
  File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 182, in run
    self.run_schema_updates()
      self = <frappe.migrate.SiteMigration object at 0x7f85b173fd00>
      site = 'petpalace.erpnext.com'
  File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 52, in wrapper
    raise e
      args = (<frappe.migrate.SiteMigration object at 0x7f85b173fd00>,)
      kwargs = {}
      method = <function SiteMigration.run_schema_updates at 0x7f85af6a05e0>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 44, in wrapper
    ret = method(*args, **kwargs)
      args = (<frappe.migrate.SiteMigration object at 0x7f85b173fd00>,)
      kwargs = {}
      method = <function SiteMigration.run_schema_updates at 0x7f85af6a05e0>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/migrate.py", line 121, in run_schema_updates
    frappe.modules.patch_handler.run_all(
      self = <frappe.migrate.SiteMigration object at 0x7f85b173fd00>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 76, in run_all
    run_patch(patch)
      patch_type = <PatchType.post_model_sync: 'post_model_sync'>
      executed = {'erpnext.patches.v11_0.add_index_on_nestedset_doctypes', 'execute:frappe.delete_doc("Page","stock-level")', 'execute:frappe.delete_doc("DocType", "Tag")', 'execute:frappe.db.sql("update `tabDesktop Icon` set type=\'list\' where _doctype=\'Communication\'")', 'frappe.patches.v11_0.drop_column_apply_user_permissions', "execute:frappe.reload_doc('email', 'doctype', 'email_alert') #2014-07-15", 'execute:import frappe.defaults;frappe.defaults.clear_default("price_list_currency")', 'erpnext.patches.v11_0.reset_publish_in_hub_for_all_items', 'execute:frappe.delete_doc_if_exists("Page", "purchase-analytics")', 'erpnext.patches.v12_0.update_production_plan_status', 'erpnext.patches.v12_0.set_payment_entry_status', 'frappe.patches.v8_0.set_currency_field_precision\t# 2017-05-09', 'frappe.patches.v13_0.replace_old_data_import # 2020-06-24', 'frappe.patches.v4_0.rename_sitemap_to_route', 'erpnext.patches.v8_10.change_default_customer_credit_days', 'erpnext.patches.v5_0.update_sms_sender', 'erpnex...
      run_patch = <function run_all.<locals>.run_patch at 0x7f85ae5a8f70>
      patches = ["execute:frappe.get_doc('Role', 'Guest').save() # remove desk access", 'frappe.core.doctype.role.patches.v13_set_default_desk_properties', 'frappe.patches.v14_0.update_workspace2 # 06.06.2023', 'frappe.patches.v14_0.drop_data_import_legacy', 'frappe.patches.v14_0.copy_mail_data #08.03.21', 'frappe.patches.v14_0.update_github_endpoints #08-11-2021', 'frappe.patches.v14_0.remove_db_aggregation', 'frappe.patches.v14_0.update_color_names_in_kanban_board_column', 'frappe.patches.v14_0.update_is_system_generated_flag', 'frappe.patches.v14_0.update_auto_account_deletion_duration', 'frappe.patches.v14_0.update_integration_request', 'frappe.patches.v14_0.set_document_expiry_default', 'frappe.patches.v14_0.delete_data_migration_tool', 'frappe.patches.v14_0.set_suspend_email_queue_default', 'frappe.patches.v14_0.different_encryption_key', 'frappe.patches.v14_0.update_multistep_webforms', 'frappe.patches.v14_0.drop_unused_indexes', 'frappe.patches.v14_0.disable_email_accounts_with_oauth', 'frappe...
      patch = 'erpnext.patches.v14_0.update_closing_balances #15-07-2023'
      skip_failing = False
  File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 62, in run_patch
    if not run_single(patchmodule=patch):
      patch = 'erpnext.patches.v14_0.update_closing_balances #15-07-2023'
      skip_failing = False
  File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 150, in run_single
    return execute_patch(patchmodule, method, methodargs)
      patchmodule = 'erpnext.patches.v14_0.update_closing_balances #15-07-2023'
      method = None
      methodargs = None
      force = False
      conf = <LocalProxy unbound>
  File "/home/frappe/frappe-bench/apps/frappe/frappe/modules/patch_handler.py", line 186, in execute_patch
    _patch()
      patchmodule = 'erpnext.patches.v14_0.update_closing_balances #15-07-2023'
      method = None
      methodargs = None
      has_patch_file = True
      patch = 'erpnext.patches.v14_0.update_closing_balances.execute'
      docstring = ''
      _patch = <function execute at 0x7f85abfbb640>
      start_time = 1715084409.6726923
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/patches/v14_0/update_closing_balances.py", line 28, in execute
    pcv_doc.year_start_date = get_fiscal_year(
      company = 'Pet Palace Hong Kong'
      i = 0
      company_wise_order = {'Pet Palace Hong Kong': []}
      pcv = {'company': 'Pet Palace Hong Kong', 'posting_date': datetime.date(2019, 3, 31), 'name': 'ACC-PCV-2020-00000'}
      pcv_doc = <PeriodClosingVoucher: ACC-PCV-2020-00000 docstatus=1>
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/utils.py", line 58, in get_fiscal_year
    fiscal_years = get_fiscal_years(
      date = datetime.date(2019, 3, 31)
      fiscal_year = None
      label = 'Date'
      verbose = 1
      company = 'Pet Palace Hong Kong'
      as_dict = False
      boolean = False
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/utils.py", line 140, in get_fiscal_years
    raise FiscalYearError(error_msg)
      transaction_date = datetime.date(2019, 3, 31)
      fiscal_year = None
      label = 'Date'
      verbose = 1
      company = 'Pet Palace Hong Kong'
      as_dict = False
      boolean = False
      fiscal_years = [{'name': '2024-2025', 'year_start_date': datetime.date(2024, 4, 1), 'year_end_date': datetime.date(2025, 3, 31)}, {'name': '2023-2024', 'year_start_date': datetime.date(2023, 4, 1), 'year_end_date': datetime.date(2024, 3, 31)}, {'name': '2022-2023', 'year_start_date': datetime.date(2022, 4, 1), 'year_end_date': datetime.date(2023, 3, 31)}, {'name': '2021-2022', 'year_start_date': datetime.date(2021, 4, 1), 'year_end_date': datetime.date(2022, 3, 31)}, {'name': '2020-2021', 'year_start_date': datetime.date(2020, 4, 1), 'year_end_date': datetime.date(2021, 3, 31)}, {'name': '2019-2020', 'year_start_date': datetime.date(2019, 4, 1), 'year_end_date': datetime.date(2020, 3, 31)}]
      fy = {'name': '2019-2020', 'year_start_date': datetime.date(2019, 4, 1), 'year_end_date': datetime.date(2020, 3, 31)}
      matched = False
      error_msg = 'Date 31-03-2019 is not in any active Fiscal Year for <strong>Pet Palace Hong Kong</strong>'
erpnext.accounts.utils.FiscalYearError: Date 31-03-2019 is not in any active Fiscal Year for <strong>Pet Palace Hong Kong</strong>
Nihantra-Patel commented 5 months ago

This isn't a bug, because Fiscal Year 2019-2020 is disabled, so please enable (active) them and check it.