Risk Based Inspection 580 Upgrade

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.

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.

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

1. Access the Catalog page.
2. Navigate to the Public folder for the query that you want to revert.
   For Risk Based Inspection 580, the public queries are stored in the following folder:
   Public/Meridium/Modules/Risk Based Inspection/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 580, the baseline queries are stored in the following folder:
   Baseline/Meridium/Modules/Risk Based Inspection/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.

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.

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.

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.

The MIExecution Service,on each APM Server serves RBI, Inspection and Thickness Monitoring module queues. This service is configured to use a single shared ActiveMQ queue service across APM. Available queue configuration options include retries and concurrency limit.

1. On the APM Server, access the folder that contains the MIExecution Service files.
   Note: If you have installed APM in the default location, you can locate the folder in C:\Program Files\Meridium\ApplicationServer\mi-execution
2. Access the appsettings.json file in an application that can be used to modify JSON files (for example, Notepad++).
3. In the file, locate the following text:

   "Queue_Config": {
   	    "Queues": [
   	      {
   	        "Name": "MI_RBI_Queue", 
   	        "ConcurrencyLimit": 100,
   	        "Retries": 5,
                  "LimitPerTenantRequired": true 
   	      }
   	    ]
             }

   Note: ConcurrencyLimit indicates the maximum number of messages that will be consumed concurrently. Retries indicates the number of times it retries to send the messages to ActiveMQ if it fails. LimitPerTenantRequired indicates whether Maximum Concurrency limit per Tenant is specified in scheduler service for the queue.
4. Update the key values as desired.
5. Save and close the file.
   The updated settings will be applied when the MIExecution Service is stopped and restarted.

This action is required only if you want to use the RBI Inspection Grouping functionality.

1. Access the Catalog page.
2. Navigate to the following Public folder:
   Public/Meridium/Modules/Inspection/Compliance/Queries/
3. Select the check box next to the Recommended Actions by Selected Plans query, 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 following Baseline folder.
   Baseline/Meridium/Modules/Inspection/Compliance/Queries/
6. Select the check box next to the Recommended Actions by Selected Plans query, and then select .
   The Catalog Folder Browser window appears.
7. Navigate to the Public folder containing the query that you deleted in step 3.
8. Select OK.
   A success message appears indicating that the selected item has been copied successfully.

1. In the Applications menu, navigate to ADMIN > Configuration Manager > Family Management.
   The Family Management page appears, displaying the list of already existing families.
2. In the left pane, in the Entity section, select the RBI Recommendation entity.
   The workspace for the RBI Recommendation entity appears.
3. In the workspace, select the Datasheets tabs.
4. Select Manage Datasheets.
   The Datasheet Builder page appears.
5. On the Datasheet Caption drop-down menu, select the RBI Recommendation datasheet.
   The datasheet appears in the Datasheet Builder workspace.

   Note: If you have a custom datasheet, select the custom datasheet.
6. In the Available Items pane, select the Completion Comments field and drag it into the Datasheet Builder workspace.
   The field is added to that datasheet.
7. Select Save.
   The datasheet is saved.

1. Using the global search, search for RBI-CNAFC SHARED-MI_MRBIANAL, and then select the data mapping query.
2. In the Record Explorer, select All Possible Families.
3. Select Data Mapping Column-Field Pair.
4. In the Source Query box, verify the value. It must be Public\Meridium\Modules\Risk Based Inspection\Queries\Mapping Queries\RBI-CNAFC Query MI_CCRBICOM.
5. In the Datasheet ID box, select Mapping Query Details.
   
   
6. Select the Detail tab.
7. Verify if the Specified Tmin mapping is available in the list.
   
   
8. If the Specified Tmin mapping query is not available, Add Specified Tmin Mapping manually.

1. In the Applications menu, navigate to the TOOLS section, and then select Catalog.
2. Navigate to Public\Meridium\Modules\Risk Based Inspection\Queries\Mapping Queries.
   
   
3. Select the RBI-CNAFC Query MI_CCRBICOM data mapping query.

   The Enter Parameter Values dialog box appears.

   
   
   
4. Select Cancel.
5. Select Design tab.
6. In the Field row of the table, verify if Specified Tmin is available.
   
   
7. If Specified Tmin is available in the table, proceed to step 10.
8. If Specified Tmin is not available, select Specified Tmin from the Fields pane.

   Specified Tmin is added to the table.

9. Select .
10. Using the global search, search for RBI-CNAFC SHARED-MI_MRBIANAL, and then select the data mapping query.
11. In the Record Explorer, select Data Mapping Column-Field Pair.
12. In the Source Query box, verify the value. It must be Public\Meridium\Modules\Risk Based Inspection\Queries\Mapping Queries\RBI-CNAFC Query MI_CCRBICOM.
    
    
13. In the workspace, select , and then select Add New Record.
    
    
14. Select Specified Tmin in both Source and Target fields.
    
    
15. Select Save.

    The Specified Tmin mapping is added.

16. Repeat steps 10 through 15 for the following data mapping queries:

    • RBI-CNAFC MI_CCRBICEB-MI_MRBIANAL by Component

    • RBI-CNAFC MI_CCRBICTB-MI_MRBIANAL by Component

    • RBI-CNAFC SHARED-MI_RBIPIPEANLY

This action is required only if you have modified the Process Units Overview queries.

1. Access the Query page.
2. Select Browse.

   The Select a query from the catalog window appears.

3. Navigate to the Baseline/Meridium/Modules/Risk Based Inspection/Queries/ folder.
4. Select the link for the Asset Counts for Units baseline query.
   The Results workspace appears.
5. Select the SQL tab.
6. Copy the code from the SQL workspace.
7. From the Catalog, navigate to the Public/Meridium/Modules/Risk Based Inspection/Queries/ folder.
8. Select the link for the Asset Counts for Units query.
   The Results workspace appears.
9. Select the SQL tab.
10. Replace the code in the SQL workspace with the code that you have copied.
11. Repeat Steps 3-10 for the Process Unit Query.

This step is required only if you have modified the queries that are used for the Finalize Risk button in the Assets section of the Risk Based Inspection Overview page and the Unit Summary page.

1. Access the Query page.
2. Select Browse.

   The Select a query from the catalog window appears.

3. Navigate to the Baseline/Meridium/Modules/Risk Based Inspection/Queries/ folder.
4. Select the link for the Review Analyses by Asset 580 baseline query.
   The Results workspace appears.
5. Select the SQL tab.
6. Copy the code from the SQL workspace.
7. From the Catalog, navigate to the Public/Meridium/Modules/Risk Based Inspection/Queries/ folder.
8. Select the link for the Review Analyses by Asset 580 query.
   The Results workspace appears.
9. Select the SQL tab.
10. Replace the code in the SQL workspace with the code that you have copied.
11. Repeat Steps 3-10 for the Review Analyses by Corrosion Loop 580 query.