SLES11 SP3 or SP4 4 SMT11 fails to upgrade to SLES12 MF SMT1.0 with an error: DB schema upgrade failed

  • Document ID:7024367
  • Creation Date:13-Jan-2020
  • Modified Date:13-Jan-2020
    • Micro Focus Products:
      Open Enterprise Server

Environment


SUSE Linux Enterprise Server 11 SP3 or SP4
SUSE Linux Enterprise Server 12

Situation

A working SLES11 SP4 smt server is being upgraded to SLES 12 with MF smt 1.0.

The smt upgrade fails with the following error:

smt-schema-upgrade[1845]: DB schema upgrade failed: Was not able to find upgrade path in directory [/usr/share/schemas/smt/mysql/].


Looking for the path /usr/share/schemas/smt/mysql/ manually shows that it exists and has data in it.

Resolution

Ensure that the SLES 11 server has the SMT channel enabled and upgrade smt to the latest available updates.
This will ensure that the schema is at 2.08.

Cause

The cause in this case was that smt11 on the sles11 server was not up to date so the schema was at version 2.03.

The schema needs to be version 2.08 for the upgrade to succeed.

Additional Information

MF SMT 1.0 does not have a channel