Instance migration issue from v14 to v15

ERPNext
1

I have migrated an instance from v14 to v15 with all the commands which need to be run in migration but when I run the command

bench --site sitename migrate.

It gives me an error:

Updating DocTypes for frappe : [========================================] 100%
Updating DocTypes for erpnext : [======== ] 20%Failed to alter schema using query: ALTER TABLE tabSales Invoice ADD COLUMN update_outstanding_for_self int(1) not null default 1, ADD COLUMN subscription varchar(140)

After I run this command

bench --site sitename migrate --skip-failing

the issue persist, any help or suggestion please

Versions:
frappe 15.36.0 version-15
erpnext 15.28.0 version-15

2

@NCP @revant_one @rmehta

Any help in this regard, what am I doing wrong in this migration process

3

Hi,

If we may know the operating environment and the commands used to perform the upgrade it may be helpful.

4

Ubuntu 22.04

After restoring backup, I ran this command

bench --site sitename migrate --skip-failing

5

Generally, to upgrade to 15 make sure the pre-requisits are up to date, make a backup and run the command:

bench switch-to-branch --upgrade version-15 frappe erpnext

Restoring the update shouldn’t be needed.