Modify Checkpoints Linked to Multiple Assets

Note: The steps in this section are required only if you are upgrading from a version of Meridium Enterprise APM prior to V4.0.0.0.

In GE Digital APM V4.3.0.5.0, a Checkpoint can be linked to one asset. During upgrade from versions V3.x to V4.3.0.5.0, the related asset entity key is added to a field on the Checkpoint family. Therefore, if you have Checkpoints that are linked to more than one asset, then you must remove the links to the additional assets prior to upgrading.

Steps

Using an appropriate database management tool, prior to upgrading your database to V4.3.0.5.0, run a query to locate checkpoints that are linked to multiple assets.

For example, run the following query:

For Measurement Location in the database:

SELECT

MI_MEAS_LOC.ENTY_KEY as "ML_KEY",

MI_ENTITIES.ENTY_ID as "ML ID",

MIV_MIR_HS_MEASLOC.PRED_ENTY_KEY as "Asset Key"

FROM MI_MEAS_LOC

JOIN MIV_MIR_HS_MEASLOC ON MI_MEAS_LOC.ENTY_KEY = MIV_MIR_HS_MEASLOC.SUCC_ENTY_KEY

JOIN MI_ENTITIES on MIV_MIR_HS_MEASLOC.SUCC_ENTY_KEY = MI_ENTITIES.ENTY_KEY

AND SUCC_ENTY_KEY IN

(

SELECT

SUCC_ENTY_KEY

FROM MIV_MIR_HS_MEASLOC

GROUP BY SUCC_ENTY_KEY

HAVING COUNT( * ) > 1

)

ORDER BY 1,2;

For Lubrication Requirement in the database:

SELECT

MI_LUBR_REQ.ENTY_KEY as "LR_KEY",

MI_ENTITIES.ENTY_ID as "LR ID",

MIV_MIR_HS_MEASLOC.PRED_ENTY_KEY as "Asset Key"

FROM MI_LUBR_REQ

JOIN MIV_MIR_HS_MEASLOC ON MI_LUBR_REQ.ENTY_KEY = MIV_MIR_HS_MEASLOC.SUCC_ENTY_KEY

JOIN MI_ENTITIES on MIV_MIR_HS_MEASLOC.SUCC_ENTY_KEY = MI_ENTITIES.ENTY_KEY

AND SUCC_ENTY_KEY IN

(

SELECT

SUCC_ENTY_KEY

FROM MIV_MIR_HS_MEASLOC

GROUP BY SUCC_ENTY_KEY

HAVING COUNT( * ) > 1

)

ORDER BY 1,2;

A list of Checkpoints that are linked to multiple assets appears, providing the Checkpoint key, Checkpoint ID, and the Asset Key of the assets linked to the Checkpoint.

Access each Checkpoint in Record Manager in the current version of GE Digital APM.

The left pane displays the records that are related to the Checkpoint.

Unlink the additional assets from the Checkpoint so that it is linked only to one asset (e.g., either a Functional Location or an Equipment if you are using the default asset families).