Upgrade or Update Thickness Monitoring (TM) to V4.3.0.5.0
The following tables outline the steps that you must complete to upgrade this module to V4.3.0.5.0. These instructions assume that you have completed the steps for upgrading the basic GE Digital 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.
Uninstall the previous version of the GE Digital APM Device Service on all of the machines that will connect to devices that will be used with Thickness Monitoring.
This step is required only if you will use any device to collect data that you
transfer to Thickness Monitoring.
This step is required only if you will use any device to collect data that you
transfer to Thickness Monitoring. If you are using HTTPS to connect to GE Digital APM, follow the instructions in KBA 2850.
Manually update TM Analyses for which you used custom corrosion rates. To do so:
Locate the records that you will need to update by running the following query:
SELECT [MI_EQUIP000].[MI_EQUIP000_EQUIP_ID_C] "Equipment ID", [MI_TMLGROUP].[MI_TMLGROUP_ID_C]
"TML Group ID", [MI Thickness Measurement Location].[MI_DP_ASSET_ID_CHR] "TML Asset
ID", [MI Thickness Measurement Location].[MI_DP_ID_CHR] "TML ID", [MI TML Corrosion
Analysis].[MI_TML_CA_A_CR_N] "Custom Calculation A Corros", [MI TML Corrosion Analysis].[MI_TML_CA_B_CR_N]
"Custom Calculation B Corros" FROM [MI_EQUIP000] JOIN_SUCC [MI_TMLGROUP] JOIN_SUCC
[MI Thickness Measurement Location] JOIN_SUCC [MI TML Corrosion Analysis] ON {MI
Has Corrosion Analyses} ON {MI Has Datapoints} ON {MIR_HSTMLGP} WHERE ([MI TML Corrosion
Analysis].[MI_TML_CA_A_CR_N] > 0 AND [MI TML Corrosion Analysis].[MI_TML_CA_B_CR_N]
> 0)
Use the Bulk Analyze tool to update TM Analyses associated with the Equipment and
TML Group records returned by this query.
Note: These instructions assume that you are using the baseline Equipment and
TML Group families. If you use custom equipment families, you must replace the following
values before running the query in order to identify the records requiring update:
MI_EQUIP000 and MI_TMLGROUP with your custom family IDs.
MI_EQUIP000_EQUIP_ID_C and MI_TMLGROUP_ID_C with the field IDs used to identify these
custom equipment records.
Run the Bulk Analyze tool using your custom records.
This step is required only if, in previous versions of Meridium APM, you used custom corrosion rates in your
TM Analyses. If you did so, certain fields in the associated TML Corrosion Analysis records were
populated with values using the unit of measure (UOM) inches per day instead of IN/YR
(TM) (i.e., inches per year), which is the UOM that is specified in the properties
of the fields. To correct this issue in existing records, you must perform
this step to manually update TM Analyses. For more information about this issue,
see the V3.5.1 Release Notes.
2
If you are using HTTPS to connect to GE Digital APM, follow the instructions in KBA 2850.
Update certain TM Analyses to correct TML Corrosion Analyses for which you
performed measurement variance evaluation prior to V4.3.0.5.0. To do so:
Locate the records that you will need to update by creating a query that returns
TML Corrosion Analyses whose:
Short Term Corrosion Rate field contains the value 0 (zero).
Allowable Measurement Variance Applied field is set to True.
Use the Bulk Analyze tool to update TM Analyses that are associated with
TML Corrosion Analyses returned by the query you created in step a.
This step is required.
2
Manually update TM Analyses for which you used custom corrosion rates. To do so:
Locate the records that you will need to update by running the following query:
SELECT [MI_EQUIP000].[MI_EQUIP000_EQUIP_ID_C] "Equipment ID", [MI_TMLGROUP].[MI_TMLGROUP_ID_C]
"TML Group ID", [MI Thickness Measurement Location].[MI_DP_ASSET_ID_CHR] "TML Asset
ID", [MI Thickness Measurement Location].[MI_DP_ID_CHR] "TML ID", [MI TML Corrosion
Analysis].[MI_TML_CA_A_CR_N] "Custom Calculation A Corros", [MI TML Corrosion Analysis].[MI_TML_CA_B_CR_N]
"Custom Calculation B Corros" FROM [MI_EQUIP000] JOIN_SUCC [MI_TMLGROUP] JOIN_SUCC
[MI Thickness Measurement Location] JOIN_SUCC [MI TML Corrosion Analysis] ON {MI
Has Corrosion Analyses} ON {MI Has Datapoints} ON {MIR_HSTMLGP} WHERE ([MI TML Corrosion
Analysis].[MI_TML_CA_A_CR_N] > 0 AND [MI TML Corrosion Analysis].[MI_TML_CA_B_CR_N]
> 0)
Use the Bulk Analyze tool to update TM Analyses associated with the Equipment and
TML Group records returned by this query.
Note: These instructions assume that you are using the baseline Equipment and
TML Group families. If you use custom equipment families, you must replace the following
values before running the query in order to identify the records requiring update:
MI_EQUIP000 and MI_TMLGROUP with your custom family IDs.
MI_EQUIP000_EQUIP_ID_C and MI_TMLGROUP_ID_C with the field IDs used to identify these
custom equipment records.
Run the Bulk Analyze tool using your custom records.
This step is required only if, in previous versions of Meridium APM, you used custom corrosion rates in your
TM Analyses. If you did so, certain fields in the associated TML Corrosion Analysis records were
populated with values using the unit of measure (UOM) inches per day instead of IN/YR
(TM) (i.e., inches per year), which is the UOM that is specified in the properties
of the fields. To correct this issue in existing records, you must perform
this step to manually update TM Analyses. For more information about this issue,
see the V3.5.1 Release Notes.
2
If you are using HTTPS to connect to GE Digital APM, follow the instructions in KBA 2850.
