Hazards Analysis Upgrade

Upgrade or Update Hazards Analysis 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.0V5.0.6.0.0Upgrade from any version V5.0.0.0.0 through V5.0.5.0.0
V4.6.2.0.0 through V4.6.10.0.0V5.0.6.0.0Upgrade from any version V4.6.2.0.0 through V4.6.10.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.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.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.

StepTaskNotes
1Update entity key parameters from :n to :k for the following catalog queries:
  • Public\Meridium\Modules\Hazards Analysis\Queries folder.
    • Hazard Analysis Asset Query
  • Public\Meridium\Modules\Hazards Analysis\What If\Queries folder.
    • What If Analysis Query
    • What If Mitigated Risk Query
    • What If Risk Query
  • Public\Meridium\Modules\Hazards Analysis\HAZOP\Queries folder.
    • Hazards Analysis Deviation Mitigated Risk Query
    • Hazards Analysis Mitigated Risk Query
    • Hazards Analysis Query
    • Hazop_Reference_Documents_Query
    • Hazop_Team_Member_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\Hazards Analysis\Queries folder.
    • HAZOP_ANALYSIS_ASSET_OVERVIEW
    • Hazards Analysis Risk Overview Query
    • WHATIF_ANALYSIS_ASSET_OVERVIEW
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.

3Following queries have been modified to improve the performance. Revert these queries to Baseline to see the improved performance.
  • Public\Meridium\Modules\Hazards Analysis\Queries folder.
    • HAZOP_ANALYSIS_ASSET_OVERVIEW
    • WHATIF_ANALYSIS_ASSET_OVERVIEW
This step is required only if you have previously modified the queries.

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

  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.

Revert the Hazard Analysis Queries to Baseline

This action is required only if you have modified the Hazard Analysis queries.

About This Task

If you have modified the Hazard Analysis queries, perform the following steps to revert the query to baseline.

Procedure

  1. Access the Catalog page.
  2. Navigate to the Public folder for the query that you want to revert.
    For Hazard Analysis, the public queries are stored in the following folder:
    Public\Meridium\Modules\Hazards Analysis\Queries
  3. Select the check box next to the query that you want to revert, and then select .
    The Confirm Delete window appears, prompting you to confirm if you want to delete the selected query.
  4. Select OK.
    The selected query is deleted.
  5. Navigate to the Baseline folder for queries.
    For Hazard Analysis, the baseline queries are stored in the following folder:
    Baseline/Meridium/Modules/Hazards Analysis/Queries
  6. Select the check box next to the query that you want to revert, and then select .
    The Catalog Folder Browser window appears.
  7. Navigate to the folder containing the public query that you deleted in step 3.
  8. Select OK.
    A success message appears indicating that the selected item has been copied successfully.
  9. Repeat Steps 2-8 for each query that you want to revert to baseline.