Management of Change Upgrade | On-Premises APM

Upgrade or Update MoC to V5.0.6.0.0

Upgrading or updating to the V5.0.6.0.0 is a two-step process. You need to first upgrade to APM V4.6.2.0.0 or later and then follow the steps to upgrade or update to V5.0.6.0.0.

The following table provides you the reference to procedures to upgrade from an earlier APM version to the latest version.


Upgrade from	Upgrade to	Procedure
V5.0.0.0.0 through V5.0.5.0.0	V5.0.6.0.0	Upgrade from any version V5.0.0.0.0 through V5.0.5.0.0
V4.6.2.0.0 through V4.6.10.0.0	V5.0.6.0.0	Upgrade from any version V4.6.0.0.0 through V4.6.2.0.0

Upgrade from any version V5.0.0.0.0 through V5.0.5.0.0

This module will be upgraded to V5.0.6.0.0 automatically when you upgrade the components in the basic APM system architecture. No additional steps are required.

Upgrade from any version V4.6.0.0.0 through V4.6.2.0.0

The following tables outline the steps that you must complete to upgrade this module to V5.0.6.0.0. These instructions assume that you have completed the steps for upgrading the basic APM system architecture.

These tasks may be completed by multiple people in your organization. We recommend, however, that the tasks be completed in the order in which they are listed.


Step	Task	Notes
1	Update entity key parameters from :n to :k for the following catalog queries: Public\Meridium\Modules\Management Of Change\Queries folder. Change Project Checklist Query Checklist Questions Query Exceptions Admin Query Exception Graph Query MOC Checklists Admin Query Remaining Questions Task states count query Task Summary Graph Query	This step is required only if you have previously modified the queries. This step will be completed automatically when you upgrade the components in the basic APM system architecture.
2	Update Asset Hierarchy parameter from -1 to #ahhome for the following catalog queries: For example, (? :ah :id=entity_key) = '-1' must be updated to (? :ah :id=entity_key) = (#:ahhome). Public\Meridium\Modules\Management Of Change\Queries folder All Change Projects All MOC Tasks Public\Meridium\Modules\Management Of Change\Dashboards\Queries folder. MOC Calendar Query MOC Permanent Projects MOC Temporary Expired Projects MOC Temporary Projects	This step is required only if you have previously modified the queries. This step will be completed automatically when you upgrade the components in the basic APM system architecture.

Update the Query Parameter Type

About This Task

After the database for APM is upgraded, if the entity key fields are of the type string, you must modify the catalog query parameters to use the correct type by performing the following steps:

Procedure

Access the Query page.
Select Browse.
The Select a query from the catalog window appears.
Navigate to the folder containing the query that you want to update, and select the link for the query.
The Results workspace appears.
Select the SQL tab.
The SQL workspace appears, where you can modify the SQL code.
Modify all the entity key numeric parameters to :k.
For example, (? :n) must be updated to (? :k).
Select Save.
The modified query is saved.