Determining the Database Upgrade Path - EcoSys - Installation & Upgrade - Hexagon

EcoSys Upgrade

Language
English
Product
EcoSys
Search by Category
Installation & Upgrade
EcoSys Version
9.2

Use the current and target EcoSys (ESFM) database schema versions, as well as the database platform, to determine which database scripts you need to run.

Determine the current database schema version

Use of of the following methods:

  • Prior to shutting down the EcoSys application server(s), log in to the EcoSys web application, navigate to System Information > Database, and make a note of the Current Database Version value.

  • Execute the following SQL query as the FMUSER database user:

    Select database_version_name from systemsettings

Determine the target database schema version

Use one of the following methods:

  • Open the EcoSys Release Notes for the target/upgrade version, and make a note of the required schema version value listed under Database Schema Version.

  • Locate the EcoSys target/upgrade version EcoSys Release column, and make a note of its corresponding Database Schema Version value.

EcoSys Release

Database Schema Version

Database Upgrade Script to Run

7.0.01

0600.0005.0005

fm_or_upgrade_0600_0005_0004_0001_to_0600_0005_0005_0001.sql

7.0.02

0600.0005.0005

No database scripts required.

7.0.03

0600.0005.0005

No database scripts required.

7.0.04

0600.0006.0003

fm_or_upgrade_0600_0005_0005_0001_to_0600_0006_0001_0001.sql

7.1.01

0600.0006.0009

fm_or_upgrade_0600_0006_0001_0001_to_0600_0006_0002_0001.sql
fm_or_upgrade_0600_0006_0002_0001_to_0600_0006_0003_0001.sql
fm_or_upgrade_0600_0006_0003_0001_to_0600_0006_0004_0001.sql
fm_or_upgrade_0600_0006_0004_0001_to_0600_0006_0005_0001.sql
fm_or_upgrade_0600_0006_0005_0001_to_0600_0006_0006_0001.sql
fm_or_upgrade_0600_0006_0006_0001_to_0600_0006_0007_0001.sql
fm_or_upgrade_0600_0006_0007_0001_to_0600_0006_0008_0001.sql
fm_or_upgrade_0600_0006_0008_0001_to_0600_0006_0009_0001.sql
fm_or_upgrade_0600_0006_0009_0001_to_0600_0007_0001_0001.sql

7.2.01

0600.0007.0003

fm_or_upgrade_0600_0007_0001_0001_to_0600_0007_0002_0001.sql
fm_or_upgrade_0600_0007_0002_0001_to_0600_0007_0003_0001.sql

7.2.02

0600.0007.0004

fm_or_upgrade_0600_0007_0003_0001_to_0600_0007_0004_0001.sql

7.2.03

0600.0007.0004

No database scripts required.

7.2.04

0600.0007.0006

fm_or_upgrade_0600_0007_0004_0001_to_0600_0007_0005_0001.sql
fm_or_upgrade_0600_0007_0005_0001_to_0600_0007_0006_0001.sql

7.2.05

0600.0007.0007

fm_or_upgrade_0600_0007_0006_0001_to_0600_0007_0007_0001.sql

7.0.06

0600.0007.0007

No database scripts required.

7.3.01

0600.0007.0008

fm_or_upgrade_0600_0007_0007_0001_to_0600_0007_0008_0001.sql

7.4.01

0600.0007.0011

fm_or_upgrade_0600_0007_0008_0001_to_0600_0007_0009_0001.sql
fm_or_upgrade_0600_0007_0009_0001_to_0600_0007_0010_0001.sql
fm_or_upgrade_0600_0007_0010_0001_to_0600_0007_0011_0001.sql

7.4.02

0600.0007.0011

No database scripts required.

7.4.03

0600.0007.0015

fm_or_upgrade_0600_0007_0011_0001_to_0600_0007_0012_0001.sql
fm_or_upgrade_0600_0007_0012_0001_to_0600_0007_0013_0001.sql
fm_or_upgrade_0600_0007_0013_0001_to_0600_0007_0014_0001.sql
fm_or_upgrade_0600_0007_0014_0001_to_0600_0007_0015_0001.sql

7.4.04

0600.0007.0015

No database scripts required.

7.4.05

0600.0007.0015.0001

No database scripts required.

7.4.06

0600.0007.0015.0001

No database scripts required.

7.4.07

0600.0007.0015.0001

No database scripts required.

7.4.08

0600.0007.00170001

fm_or_upgrade_0600_0007_0015_0001_to_0600_0007_0016_0001.sql
fm_or_upgrade_0600_0007_0016_0001_to_0600_0007_0017_0001.sql

7.0.09

0600.0007.00170001

No database scripts required.

7.4.10

0600.0007.00170001

No database scripts required.

7.4.11

0600.0007.00170001

No database scripts required.

7.5.01

0600.0008.0011.0001

fm_or_upgrade_0600_0007_0017_0001_to_0600_0008_0001_0001.sql
fm_or_upgrade_0600_0008_0001_0001_to_0600_0008_0002_0001.sql
fm_or_upgrade_0600_0008_0002_0001_to_0600_0008_0003_0001.sql
fm_or_upgrade_0600_0008_0003_0001_to_0600_0008_0004_0001.sql
fm_or_upgrade_0600_0008_0004_0001_to_0600_0008_0005_0001.sql
fm_or_upgrade_0600_0008_0005_0001_to_0600_0008_0006_0001.sql
fm_or_upgrade_0600_0008_0006_0001_to_0600_0008_0007_0001.sql
fm_or_upgrade_0600_0008_0007_0001_to_0600_0008_0008_0001.sql
fm_or_upgrade_0600_0008_0008_0001_to_0600_0008_0009_0001.sql
fm_or_upgrade_0600_0008_0009_0001_to_0600_0008_0010_0001.sql
fm_or_upgrade_0600_0008_0010_0001_to_0600_0008_0011_0001.sql

7.5.02

0600.0008.0011.0001

No database scripts required.

7.5.03

0600.0008.0011.0001

No database scripts required.

7.6.01

0600.0009.0004.0001

fm_or_upgrade_0600_0008_0011_0001_to_0600_0008_0012_0001.sql
fm_or_upgrade_0600_0008_0012_0001_to_0600_0009_0001_0001.sql
fm_or_upgrade_0600_0009_0001_0001_to_0600_0009_0002_0001.sql
fm_or_upgrade_0600_0009_0002_0001_to_0600_0009_0003_0001.sql
fm_or_upgrade_0600_0009_0003_0001_to_0600_0009_0004_0001.sql

7.6.02

0600.0009.0004.0001

No database scripts required.

7.6.03

0600.0010.0007.0001

fm_or_upgrade_0600_0009_0004_0001_to_0600_0009_0005_0001.sql
fm_or_upgrade_0600_0009_0005_0001_to_0600_0010_0001_0001.sql
fm_or_upgrade_0600_0010_0001_0001_to_0600_0010_0002_0001.sql
fm_or_upgrade_0600_0010_0002_0001_to_0600_0010_0003_0001.sql
fm_or_upgrade_0600_0010_0003_0001_to_0600_0010_0004_0001.sql
fm_or_upgrade_0600_0010_0004_0001_to_0600_0010_0005_0001.sql
fm_or_upgrade_0600_0010_0005_0001_to_0600_0010_0006_0001.sql
fm_or_upgrade_0600_0010_0006_0001_to_0600_0010_0007_0001.sql

7.6.04

0600.0010.0007.0001

No database scripts required.

7.7.01

0600.0011.0001.0001

fm_or_upgrade_0600_0010_0007_0001_to_0600_0011_0001_0001.sql

7.7.02

0600.0011.0001.0001

No database scripts required.

8.0.01

0600.0012.0003.0001

fm_or_upgrade_0600_0011_0001_0001_to_0600_0011_0002_0001.sql
fm_or_upgrade_0600_0011_0002_0001_to_0600_0011_0003_0001.sql
fm_or_upgrade_0600_0011_0003_0001_to_0600_0011_0004_0001.sql
fm_or_upgrade_0600_0011_0004_0001_to_0600_0012_0001_0001.sql
fm_or_upgrade_0600_0012_0001_0001_to_0600_0012_0002.0001.sql
fm_or_upgrade_0600_0012_0002_0001_to_0600_0012_0003_0001.sql

8.0.02

0600.0012.0003.0001

No database scripts required.

8.0.03

0600.0012.0003.0001

No database scripts required.

8.1.01

0600.0012.0004.0001

fm_or_upgrade_0600_0012_0003_0001_to_0600_0012_0004_0001.sql

8.1.02

0600.0012.0004.0001

No database scripts required.

8.2.01

0600.0013.0006.0001

fm_or_upgrade_0600_0012_0004_0001_to_0600_0012_0005_0001.sql
fm_or_upgrade_0600_0012_0005_0001_to_0600_0013_0001_0001.sql
fm_or_upgrade_0600_0013_0001_0001_to_0600_0013_0002_0001.sql
fm_or_upgrade_0600_0013_0002_0001_to_0600_0013_0003_0001.sql
fm_or_upgrade_0600_0013_0003_0001_to_0600_0013_0004_0001.sql
fm_or_upgrade_0600_0013_0004_0001_to_0600_0013_0005_0001.sql

fm_or_upgrade_0600_0013_0005_0001_to_0600_0013_0006_0001.sql

8.2.02

0600.0013.0008.0001

fm_or_upgrade_0600_0013_0006_0001_to_0600_0013_0007_0001.sql
fm_or_upgrade_0600_0013_0007_0001_to_0600_0013_0008_0001.sql

8.2.03

0600.0013.0009.0001

fm_or_upgrade_0600_0013_0008_0001_to_0600_0013_0009_0001.sql

8.3.01

0600.0014.0002.0001

fm_or_upgrade_0600_0013_0009_0001_to_0600_0014_0001_0001.sql
fm_or_upgrade_0600_0014_0001_0001_to_0600_0014_0002_0001.sql

8.3.02

0600.0014.0003.0001

fm_or_upgrade_0600_0014_0002_0001_to_0600_0014_0003_0001.sql

8.4.01

0600.0015.0002.0001

fm_or_upgrade_0600_0014_0003_0001_to_0600_0015_0001_0001.sql
fm_or_upgrade_0600_0015_0001_0001_to_0600_0015_0002_0001.sql

8.4.02

0600.0015.0002.0001

No database scripts required.

8.5.01

0600.0016.0003.0001

fm_or_upgrade_0600_0015_0002_0001_to_0600_0016_0001_0001.sql

fm_or_upgrade_0600_0016_0001_0001_to_0600_0016_0002_0001.sql

fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.READMENote 1

8.6.01

0600.0017.0002.0001

fm_or_upgrade_0600_0016_0003_0001_to_0600_0017_0001_0001.sql
fm_or_upgrade_0600_0017_0001_0001_to_0600_0017_0002_0001.sql

8.6.02

0600.0017.0002.0001

No database scripts required.

8.6.03

0600.0017.0002.0001

No database scripts required.

8.7.01

0600.0018.0002.0001

fm_or_upgrade_0600_0017_0002_0001_to_0600_0018_0001_0001.sql

fm_or_upgrade_0600_0018_0001_0001_to_0600_0018_0002_0001.sql

8.7.02

0600.0018.0002.0001

No database scripts required.

8.7.03

0600.0018.0002.0001

No database scripts required.

8.8.01

0600.0019.0004.0001

fm_or_upgrade_0600_0018_0002_0001_to_0600_0019_0001_0001.sql

fm_or_upgrade_0600_0019_0001_0001_to_0600_0019_0002_0001.sql

fm_or_upgrade_0600_0019_0002_0001_to_0600_0019_0003_0001.sql

fm_or_upgrade_0600_0019_0003_0001_to_0600_0019_0004_0001.sql

8.8.02

0600.0019.0005.0001

fm_or_upgrade_0600_0019_0004_0001_to_0600_0019_0005_0001.sql

8.8.03

0600.0019.0006.0001

fm_or_upgrade_0600_0019_0005_0001_to_0600_0019_0006_0001.sql

8.8.04

0600.0019.0007.0001

fm_or_upgrade_0600_0019_0006_0001_to_0600_0019_0007_0001.sql

8.8.05

0600.0019.0007.0001

No database scripts required.

8.8.06

0600.0019.0007.0001

No database scripts required.

8.8.07

0600.0019.0007.0001

No database scripts required.

9.0.01

0600.0020.0004.0001

fm_or_upgrade_0600_0019_0007_0001_to_0600_0020_0001_0001.sql

fm_or_upgrade_0600_0020_0001_0001_to_0600_0020_0002_0001.sql

fm_or_upgrade_0600_0020_0002_0001_to_0600_0020_0003_0001.sql

fm_or_upgrade_0600_0020_0003_0001_to_0600_0020_0004_0001.sql

9.1.01

0600.0021.0010.0001

Use Liquibase to apply schema changes.

9.1.02

0600.0021.0010.0001

No database scripts required.

9.2.01

0600.0021.0016.0001

Use Liquibase to apply schema changes

9.2.02

0600.0021.0016.0001

Use Liquibase to apply schema changes

9.1.03

0600.0021.0010.0001

No database scripts required

9.0.03

0600.0020.0004.0001

No database scripts required

Database schema versions for EcoSys versions 9.1 and above are not shown in the table.

Upgrading from Schema Version 0600.0016.0002.0001 to 0600.0016.0003.0001

The upgrade script fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql is produced by EcoSys during the application startup. The SQL script generated is specific to the environment that was created for and must only be executed on that database. When upgrading from an older version of EcoSys to a newer version you should:

  1. Apply all the database upgrade scripts up until fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql.

  2. Deploy the version of EcoSys you are upgrading to and start your application Server.

  3. Review the log files and find the directory containing the generated script fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql. This must be the ESFM_HOME\Schema directory.

  4. Shutdown the Application Server running EcoSys.

  5. Apply the database upgrade script fm_or_upgrade_0600_0016_0002_0001_to_0600_0016_0003_0001.sql

  6. Continue applying any additional upgrade scripts required for the upgrade.

  7. Start the Application Server to start EcoSys.

Determine which database upgrade scripts to run

All database upgrade scripts listed between the current and target database schema versions in the table above need to be run.

  • All scripts listed in the table above are for environments with Oracle databases. For Microsoft SQL Server databases, replace fm_or with fm_ss in the script names.

  • Pay extra attention to the database upgrade scripts shown in bold text. Depending on the database platform (Oracle versus Microsoft SQL Server), you may need to run these scripts with elevated database user privileges.