Open topic with navigation

Upgrade Records with Schedules Containing End Dates

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.

When upgrading from any V3.x version to a V4.x version, follow these steps to ensure that schedules for the following record types are upgraded successfully:

• Checkpoint Task
• Measurement Location
• Lubrication Requirement
• Measurement Location Template
• Lubrication Requirement Template

These steps are required to ensure that any records containing schedules with end dates are upgraded successfully.

Note: If preferred, instead of completing the following steps prior to upgrading, you can instead upgrade your database as normal. When you do so, the log for the Rounds upgrade utility will record entries for schedules that failed to upgrade. You can then use this information to recreate the schedules in V4.2.0.0.

Steps

Prior to Upgrading

1. Review the affected record types to determine if there are any schedules containing end dates.

   You can use the following queries to locate these records:

   • Checkpoint Templates (i.e., Measurement Template and Lubrication Requirement Template records)

     SELECT ENTY_KEY, ENTY_ID, MI_ML_TMPLT_SCHEDULE_C FROM MIV_MI_CP_TMPLT WHERE MI_ML_TMPLT_SCHEDULE_C LIKE '<?xml%' AND MI_ML_TMPLT_SCHEDULE_C NOT LIKE '%<EndDate xsi:nil="true" />%'

   • Checkpoints (i.e., Measurement Location and Lubrication Requirement records)

     SELECT MI_MEAS_LOC_SCHEDULE_C FROM MIV_MI_CHECK_PT WHERE MI_MEAS_LOC_SCHEDULE_C LIKE '<?xml%' AND MI_MEAS_LOC_SCHEDULE_C NOT LIKE '%<EndDate xsi:nil="true" />%'

   • Checkpoint Tasks

     SELECT ENTY_KEY, ENTY_ID, MI_TASK_SCHEDULE_C FROM MIV_MI_CP_TASK0 WHERE MI_TASK_SCHEDULE_C LIKE '<?xml%' AND MI_TASK_SCHEDULE_C NOT LIKE '%<EndDate xsi:nil="true" />%'

2. For each record with a schedule containing an end date:

   1. Note the record and the end date value.

   2. In the Schedule field, select the […] button to open the Schedule window.

   3. In the Range of recurrence section, select No end date, and then select OK.

3. Proceed with the database upgrade as normal.

After upgrading:

1. In GE Digital APM, locate the records you noted in the previous section.
2. In each record, update the schedule to set the required end date.

• GE Digital APM Installation and Upgrade

Copyright © 2018 General Electric Company. All rights reserved.