SIS Management Upgrade

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\SIS Management\Queries folder.
    • Add_SIS_Trip_Report_Detail_Search
    • IF_Proof_Test_Tasks
    • LS_Proof_Test_Tasks
    • PIL Search for Reports
    • SIL_Anaysis_Doc_Query
    • SIS Find ASM Actions for IF
    • SRS_Report_Query

  • Public\Meridium\Modules\SIS Management\Queries\Dashboard Queries folder.
    • SIS Proof Tests Summary Failed
    • SIS Proof Tests Summary Failed LS
    • SIS Proof Tests Summary Passed
    • SIS Proof Tests Summary Passed LS

  • Public\Meridium\Modules\SIS Management\SIL\Queries folder.
    • SIL Analysis Risk Query
    • SIL Analysis Query
    • SIL Assignment Summary Query
  • Public\Meridium\Modules\SIS Management\Proof Tests\Queries folder.
    • SIS Proof Test Query
  • Public\Meridium\Modules\SIS Management\Proof Test Templates\Queries\ folder.
    • Proof Test Template Query
  • Public\Meridium\Modules\SIS Management\SIS Trip Report\Queries folder.
    • SIS Trip Reports Query
  • Public\Meridium\Modules\SIS Management\LOPA\Queries folder.
    • LOPA_Analysis_Search
    • LOPA ILP Search
  • Public\Meridium\Modules\SIS Management\PIF\Queries folder.
    • PIF Risk Matrix Result Query
    • PIF Query
  • Public\Meridium\Modules\SIS Management\Protective Instrument Loop\Queries folder.
    • Protective Instrument Loop 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\SIS Management\Dashboard Queries folder.
    • Overdue Hazards Analysis
    • SIL Distribution for Graph
    • SIS Proof Tests Failed
    • SIS Proof Tests Failed LS
    • SIS Proof Tests Passed
    • SIS ProofTests Passed LS
  • Public\Meridium\Modules\SIS Management\Queries folder.
    • All SIL Analyses Tasks Base Query
    • SIL_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\SIS Management\Queries folder.
    • All SIL Analyses Tasks Base Query
    • SIL_ANALYSIS_ASSET_OVERVIEW
  • Public\Meridium\Modules\SIS Management\Queries\Dashboard Queries folder.
    • SIL Distribution for Graph
    • SIS Proof Tests Failed
    • SIS Proof Tests Failed LS
    • SIS Proof Tests Passed
    • SIS Proof Tests Passed LS
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 SIS Management Queries to Baseline

This action is required only if you have modified the SIS Management queries.

About This Task

If you have modified the SIS Management 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 SIS Management, the public queries are stored in the following folder:
    Public\Meridium\Modules\SIS Management
  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 SIS Management, the baseline queries are stored in the following folder:
    Baseline/Meridium/Modules/SIS Management
  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.