Hazards Analysis Upgrade

Upgrade Hazards Analysis

The following tables outline the steps that you must complete to upgrade this module to the latest version of APM.

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
1Following queries have been modified to fix search related errors. Revert the Hazard Analysis Queries to Baseline to see the search related fixes working.
Public\Meridium\Modules\Hazards Analysis\What If\Queries folder.
  • What If Mitigated Risk Query
  • What If Risk Query
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.