Risk Based Inspection 581 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 581 queries.

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.

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.

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. 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.

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.