Inspection Management Upgrade

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

1. Access the Catalog page.
2. Navigate to the Public folder for the query that you want to revert.
   The queries are stored in specific sub-folders within the Public/Meridium/Modules/Inspection/ folder.
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.
   The baseline queries are stored in specific sub-folders within the Baseline/Meridium/Modules/Inspection/ folder.
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. Log in to the server where APM is installed.
2. Navigate to <Installation Directory>\Meridium\Upgrade\DBUpgrade.
3. Run the RevertToBaselineApp.exe file as administrator.
   The Revert To Baseline Login 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 the Inspection family that you want to update, and then select Revert to Baseline.
   The Various Options For Revert window appears.
   
   
7. Select Datasheets.
   Select the Default Datasheet from the drop-down, and then select Ok.
8. Repeat steps 6-7 for each Inspection Family.

After the database upgrade for APM, 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.

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 key.
   For example, (? :n) must be updated to (? :k).
6. Select Save.
   The modified query is saved.

1. Log in to the server where APM is installed.
2. Navigate to <Installation Directory>\Meridium\Upgrade\DBUpgrade.
3. Run the RevertToBaselineApp.exe file as administrator.
   The Revert To Baseline Login 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 the Inspection Recommendation family, and then select Revert to Baseline.
   The Various Options For Revert window appears.
   
   
7. Select State Management, and then select Ok.
   The State Management Mapper window appears.
   
   
8. In the Entity Families pane, select Inspection Recommendation.
   The State Management Baseline Mapping table appears and contains the following columns:

   • Custom Source: Contains all the existing states that are available for mapping to the new states.
   • Select Target: Allows you to select the new states that you want to map to the existing states.
   • Baseline Target: Displays the newly mapped states corresponding to the existing states.
9. Using the Select Target column, select the state that you want to map to the existing state.
   Note: You can use the Auto Map button to automatically map the existing states to the new states based on the state name.
10. Repeat step 9 for all the existing states.
11. Select Save Mapping.
12. Browse for the path where you want to save the mapping file, and then select Save.
    A .xml file containing the state mappings is saved.
13. Select Revert Single Family.
14. Select the state mapping file that you saved in step 12, and then select OK.
    The mapping operation starts. After the operation is successfully completed, a success message appears.
15. Select Exit.
    The Revert to Baseline utility is closed.

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_IM_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. Access the Catalog page.
2. Navigate to the Public folder for the dashboard that you want to revert.
   The dashboards are stored within the Public/Meridium/Modules/Mechanical Integrity/Dashboards/ folder.
3. Select the check box next to the dashboard that you want to revert, and then select .
   The Confirm Delete window appears, asking you to confirm if you want to delete the selected dashboard.
4. Select OK.
   The selected dashboard is deleted.
5. Navigate to the Baseline folder for dashboards.
   The baseline dashboards are stored within the Public/Meridium/Modules/Mechanical Integrity/Dashboards/ folder.
6. Select the check box next to the dashboard that you want to revert, and then select .
   The Catalog Folder Browser window appears.
7. Navigate to the folder containing the public dashboard 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 dashboard that you want to revert to baseline.