Calibration Management Upgrade

Upgrade Calibration Management

The following tables outline the steps that you must complete to upgrade this module to the latest version. These instructions assume that you have completed the steps for upgrading the basic 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.

StepTaskNotes
1Following query has been modified to display overview count to match with number of records in the result grid under calibration queue tab. Revert these queries to Baseline to avoid any issues while loading overview count:
  • Public\Meridium\Modules\Calibration Management\Queries folder.
    • Calibration Queue Overview
This step is required only if you have previously modified the queries.
2
Following queries have been modified to fix the error when you attempt to open a Calibration Profile record with more than 2100 assets linked to it:
  • Public\Meridium\Modules\Calibration Management\Queries folder
    • Manage Calibration Task Query
    • Manage Calibration Task With Task Assigned Query
    • Manage Calibration Task Without Task Assigned Query
This step is required only if you have previously modified the queries.

Install the GE Device Service

Before You Begin

You need administrative access to the machine on which you want to install the service.
Important: You must repeat this procedure on every machine to which a calibrator will be connected.

About This Task

For APM to communicate with physical devices connected to your machine, the GE Device Service must be installed.

You can download the installer from KBA 000059233.

Procedure

  1. Access the Calibration Management Overview page.
    Note: A calibrator does not need to be connected.
  2. Select the Calibration Tools tab.
    The Calibration Tools section appears, displaying a list of test equipment and standard gas cylinders.
  3. In the upper-right corner of the page, select Calibrator Settings.
    The Calibrator Settings window appears.
  4. In the Select Device box, select the required device.
  5. If you selected the CMX Calibration Management software, enter values in the following fields:
    • If you want to test the connection of the CMX Calibration Management software, select the Perform Connection Test check box.

    • In the Device Service Settings Service Port box, enter the value of the service port number that you have configured. The default value in the Device Service Settings Service Port box is 2014.

    If you selected a Fluke documenting process calibrator, enter values in the following fields:

    • In the COM Port box, select the communication port number to which the calibrator is connected.

      Important: APM supports port numbers in the range of COM1 through COM4. If the communication port number of the calibrator does not fall within this range, you must change the value in the Device Manager, or connect the calibrator to a different port.

    • If you want to test the connection of the Fluke documenting process calibrator, select the Perform Connection Test check box.

      Note: The Baud Rate box contains the value 9600. You cannot change this value.

    • In the Device Service Settings Service Port box, enter the value of the service port number that you have configured. The default value in the Device Service Settings Service Port box is 2014.

    If you selected a GE Druck documenting process calibrator, enter values in the following fields:

    • If you want to test the connection of the GE Druck documenting process calibrator, select the Perform Connection Test check box.
    • In the Device Service Settings Service Port box, enter the value of the service port number that you have configured. The default value in the Device Service Settings Service Port box is 2014.
  6. Select Done.
    The Calibrator Settings window appears, indicating that the GE Device Service is not installed.
  7. Download the latest GE Device Service installer from KBA 000059233.
  8. Run MeridiumDevices.exe, and then follow the instructions in the installer.
    The GE Device Service is installed.

What To Do Next

If you want to use an HTTPS connection or a port number other than the default one (2014), configure the GE Device Service.

Configure the GE Device Service

Before You Begin

  • You need administrative access to the machine on which you want to configure the service.
  • Install the GE Device Service.
Important: You must repeat this procedure on every machine to which a datalogger will be connected.

About This Task

In most cases, the default configuration of the GE Device Service will suffice. However, depending on how you access APM and your computer’s port configuration, you may need to change the configuration.
This topic describes how to configure the settings, which is required only if:
  • Your APM connection uses HTTPS.
  • The default port 2014 is not available.
If using HTTP or the default port, changes to the configuration are not required.

Procedure

  1. In Windows Explorer, navigate to C:\Program Files\Meridium\Services.
  2. Using a text editor, open the Meridium.Service.Devices.exe.config file.
  3. In the appSettings section:
    1. If using a port other than 2014, update the entry for UrlPort with a port number that is available on your computer.
    2. If using HTTPS, update the value for BaseURL with https://*.
    3. On line 26, edit the timeout value in milliseconds. By default, the value for this setting is 60000, or 1 minute.
  4. Save your changes, and restart the GE Device Service.
    The GE Device Service configuration settings are updated.

Results

On initial startup, the service will attempt to install an SSL certificate required to communicate with APM when using an HTTPS connection. It will also bind the certificate with the configured port on the machine and add an entry in the hosts file in order to use the meridium.device.local URL. If you change the port number again, restarting the service will remove any current binding to the previous port and recreate a binding to the newly configured port.

Update the Query Parameter Type

About This Task

After the database for APM is upgraded, if the entity key fields are of the type string, you must modify the catalog query parameters to use the correct type.

Procedure

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

Revert the Calibration Management Queries to Baseline

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

About This Task

If you have modified the Calibration Management queries, perform the following steps to revert the query to baseline.

Procedure

  1. Access the Catalog page.
  2. Navigate to the Public folder for the query that you want to revert.
    For Calibration Management, the public queries are stored in the following folder:
    Public\Meridium\Modules\Calibration Management\Queries
  3. Select the check box next to the query that you want to revert, and then select .
    The Confirm Delete window appears, prompting 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 Calibration Management, the baseline queries are stored in the following folder:
    Baseline/Meridium/Modules/Calibration Management/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.