Risk Based Inspection 581 Upgrade

Upgrade RBI

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
1Revert the following catalog items to baseline to improve the performance:
  • Public\Meridium\Modules\Risk Based Inspection\ Queries\Assets with No Recommendations

  • Public \Meridium\Modules\Risk Based Inspection\ Queries\Process Unit Asset View

  • Public\Meridium\Modules\Risk Based Inspection\Queries\Inspections More Current Than All Analysis
This step is required only if you have previously modified the catalog items.

This step will be completed automatically when you upgrade the components in the basic APM system architecture.

2Revert the RBI 581 Consequence Evaluation datasheet to baseline.This step is required only if you have previously modified the RBI 581 Consequence Evaluation datasheet and you want to override the SHE Consequence with a user-defined value.

If you have not modified the datasheet previously, it is updated automatically when you upgrade the components in the basic APM system architecture.

3Revert the policy ActionMappingToInspectionTask to baseline in APM Policy Manager.This step is required only if you have modified the policy and you would like the Last Inspection Date to be mapped to the Last Date for recurring inspection tasks.
4Add data mapping for Date in Service field in RBI 581 HE Bundle Damage Evaluation from Component Date in Service field in RBI Components. For more information, refer to KBA 000071057.This step is only required if you are using RBI 581 HE Bundle Damage Evaluation and you want to automatically set the Date in Service field from the related RBI Component.

Update Query Parameter Type

After the database upgrade for APM, if the entity key fields are used as a parameter, 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 keys.
    For example, (? :n) should be updated as (? :k).
  6. Select Save.
    The modified query is saved.

Revert the Risk Based Inspection 581 Queries to Baseline

This action is required only if you have modified the Risk Based Inspection 581 queries.

About This Task

If you have modified the Risk Based Inspection 581 query, 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 Risk Based Inspection 581, the public queries are stored in the following folder:
    Public/Meridium/Modules/RBI 581/Queries
  3. Select the check box next to the query that you want to revert, and then select .
    The Confirm Delete window appears, asking 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 Risk Based Inspection 581, the baseline queries are stored in the following folder:
    Baseline/Meridium/Modules/RBI 581/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.

Add FMLY_KEY column to Query

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 Design tab.
    The Design workspace appears, where you can modify the query.
  5. Scroll through the Field list to get to the end.
  6. Add a new column with the following options:

    Alias: FMLY_KEY

    Table: rbianalyses

    Sort: None

    Sort Index: 0

    Include: Checked

    Display: Unchecked

    Hyperlink: (Don’t modify)

    Criteria: (Don’t modify)

    Or: (Don’t modify)

  7. Select Save.
    The modified query is saved.

Add RBI Component Types

Procedure

  1. Log in to APM as an administrator.
  2. Go to Admin > Configuration Manager > System Codes and Tables.
  3. Search for MI RBI COMPONENT TYPES.
  4. In the System Code section, select .
    The Create System Code window appears.
  5. Add the RBI Component Types to the system code table.
  6. Select Save.
  7. Log out of APM and log in.
  8. To add existing RBI Component Types to the MI RBI COMPONENT TYPES system code table, perform the following steps:
    1. Select , and enter EquipmentTypes.
      A blank EquipmentTypes datasheet appears.
    2. In the CriticalityItemType box, select the existing RBI Component Type that you have added.
    3. Enter values in the required boxes, and then select to save the record.

Revert Datasheets to Baseline

About This Task

If you have customized the default datasheet, then you must perform the following steps.
Note: Running this utility overwrites your current datasheet and replaces it with the baseline version. You must be a super user in APM to run the Revert to Baseline utility.

Procedure

  1. Log in to the APM Server.
  2. Navigate to the \Meridium\Upgrade\DBUpgrade folder.
  3. Run the RevertToBaselineApp.exe file as an administrator.
    The Revert To Baseline Login Screen window appears.

  4. In the Meridium Data Source box, enter the data source name that you want to access.
  5. Enter your login credentials, and then select Next.
    The available families that can be reverted to baseline appear.
  6. Select Design tab.
    The available families that can be reverted to baseline appear.
  7. Select the family and then select Revert to Baseline.
    The Various Options For Revert window appears.

  8. Select Datasheets.
  9. Select the default datasheet from the drop-down list box, and then select Ok.

Add the RBI-581 Tab to Criticality RBI Component Datasheets

Before You Begin

Note: You must repeat this procedure for each Criticality RBI Component datasheet that you have customized.
If you have customized the datasheet for one or more of the Criticality RBI Components, after activating the RBI 581 license, you must perform the following procedure to add the RBI-581 section to those customized datasheets. The following table indicates the fields that must appear on each datasheet.
CaptionField IDCriticality RBI Component - Cylindrical ShellCriticality RBI Component - Exchanger BundleCriticality RBI Component - Exchanger HeaderCriticality RBI Component - Exchanger TubeCriticality RBI Component - PipingCriticality RBI Component - Tank Bottom
Base MaterialBase MaterialMI_CCRBICOM_BASE_MATER_C
Cladding MaterialMI_CCRBICOM_CLADDING_MATERIL_C
Cladding PresentMI_CCRBICOM_CLADDING_PRESENT_L
CM Corrosion RateMI_CCRBICOM_CM_COR_RT_C
Coefficient Y MaterialMI_CCRBICOM_COEFFICNT_Y_MTRL_C
Corrosion AllowMI_RBICOMPO_CORRO_ALLOW_N
Detection SystemMI_CCRBICOM_DETECTION_SYSTEM_C
Fluid VelocityMI_CCRBICOM_FLUID_VELOCITY_N
Furnished Cladding ThkMI_CCRBICOM_FRNSHD_CLDDG_THK_N
Geometry TypeMI_CCRBICOM_GEOMETRY_TYPE_C
GFF Component TypeMI_CCRBICOM_GFF_COMPO_TYPE_CHR
Has Release Prevention Barrier?MI_CCRBICTB_HAS_RELEA_PREVE_F
Is Intrusive?MI_RBICOMPO_IS_INTRU_CHR
Isolation SystemMI_CCRBICOM_ISOLA_SYSTE_CHR
Liner PresentMI_CCRBICOM_LINER_PRESE_CHR
Liner TypeMI_CCRBICOM_LINER_TP_C
Minimum Structural ThicknessMI_CCRBICOM_MNMM_STRCTRL_THS_N
Mitigation SystemMI_CCRBICOM_MITIGATION_SYSTM_C
Percent Liquid VolumeMI_RBICOMPO_PER_LIQ_VOL_N
pH of WaterMI_CCRBICOM_PH_OF_WATER_N
Specified TminMI_CCRBICOM_SPECIFIED_TMIN_N
Total Acid NumberMI_CCRBICOM_TOTAL_ACID_NUMBR_N

Procedure

  1. Access the Family Management page.
  2. In the left section, select the Criticality RBI Component whose datasheet you want to modify.
    In the workspace, the corresponding Criticality RBI Component family appears, displaying the Information section.
  3. In the workspace, select the Datasheets tab, and then select Manage Datasheets.
    The Datasheet Builder page appears, displaying the datasheet layout of the selected Criticality RBI Component family.
  4. In the upper-right corner of the page, select
    A new section tab appears at the top of the workspace, displaying a blank section.
  5. On the new tab, rename new section to RBI-581.
  6. In the RBI-581 section, select .
  7. In the right column, in the top cell, enter Value(s).
  8. In the left pane, locate a field that corresponds to the table at the beginning of this topic, and then add that field into the empty cell in the Value(s) column using the drag-and-drop method.
    In the cell, an input box that corresponds to the selected field appears.
  9. In the left column, enter the caption that corresponds to the field. For example, if you added the Coefficient Y Material field to the Value(s) column, then enter Coefficient Y Material in the corresponding cell in the left column.
  10. In the upper-right corner of the page, select .
    In the RBI-581 section, in the table, a new row appears.
  11. Repeat steps 8 to 10 for each of the fields specified in the table at the beginning of this topic.
  12. In the upper-right corner of the page, select Save.
    The datasheet for the Criticality RBI Component that you selected in step 2 is saved, and the RBI-581 tab appears on the selected Criticality RBI Component datasheet.