Layers of Protection Analysis Upgrade

Upgrade or Update LOPA to V5.1.4.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.1.xV5.1.4.0.0
V5.0.xV5.1.4.0.0
V4.6.2 or a later V4.6.x releaseV5.1.4.0.0
  1. Upgrade from any version V4.6.2.0.0 through V4.6.10.0.0
  2. Upgrade from any version V5.0.1.0.0 through V5.0.6.0.0
V4.6.1.x or earlierV5.1.4.0.0
  1. Upgrade from any version V4.6.1.x or earlier to V4.6.2.0.0 or a later V4.6.x release
  2. Upgrade from any version V4.6.2.0.0 through V4.6.10.0.0
  3. Upgrade from any version V5.0.1.0.0 through V5.0.6.0.0
Note: For more information on upgrading to APM V4.6.2.0.0 or a later V4.6.x release, refer to the Upgrade documentation for the corresponding version.

Upgrade from any version V5.1.0.0.0 through V5.1.3.1.0

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

Upgrade from any version V5.0.1.0.0 through V5.0.6.0.0

This module will be upgraded to V5.1.4.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.2.0.0 through V4.6.10.0.0

The following tables outline the steps that you must complete to upgrade this module to V5.1.4.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.

StepTaskNotes
1Update entity key parameters from :n to :k for the following catalog queries:
  • Public\Meridium\Modules\LOPA\Queries folder.
    • ALL LOPA Query
    • Consequence Modifier LOPA Query
    • Safeguard LOPA 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.

2Update 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\LOPA\Queries folder.
    • LOPA_ASSET_CONTEXT_APPROVED
    • LOPA_ASSET_CONTEXT_UNDER_REVIEW
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.

Procedure

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