Manually Launching the Attribute Name to ID Conversion Tool - Metasys - LIT-12012254 - Software Application - Metasys Database Manager - 13.0

Database Tools Commissioning Guide

Product name
Metasys Database Manager
Document type
Commissioning Guide
Document number
LIT-12012254
Version
13.0
Revision date
2023-10-13
Product status
Active

About this task

Note: The Attribute Name to ID Conversion tool runs during the Metasys Server installation or upgrade process without interaction from the user. You only need to launch the tool if the database conversion is unable to automatically process the conversion without user interaction.
Figure 1. JCIHistorian Database Exception Error

Click View log for more details for more information regarding the conversion failure. The Editor dialog box appears.

Figure 2. Editor Dialog Box

The following procedure outlines how to manually launch the tool when the Metasys Server installation or upgrade process fails.

Procedure

  1. Launch the Attribute Name to ID Conversion tool using Windows File Explorer. Browse to C:\Program Files (x86)\Johnson Controls\MetasysIII\Tools.
  2. Double-click the Convert Attribute Names to IDs for Trend executable file. The MPI dialog box for resolving point trends appears. The tool performs a short analysis of the current trend database.
    Figure 3. MPI Dialog Box for Resolving Point Trends

  3. Click Yes to bring up the Attribute Name to ID Conversion Wizard's main window.
    Note: If no update is necessary, a second MPI dialog box appears to confirm that no updates are required. Click OK. Restart the Metasys system if it stopped before launching the MPI tool.
    Figure 4. MPI Dialog Box for Confirming No Updates Required

    Figure 5. The Attribute Name to ID Conversion Wizard Window

    Note: The Attribute Name to ID Conversion Wizard window shows the number of point trends with named attributes in US English that resolved automatically.
  4. Click Update Database and Exit if the remaining number of point trends that need resolving is 0. Changes are then written back to the database.
    Figure 6. No Remaining Point Trends to Resolve

  5. If additional point names require resolution and you know the language configured for the Metasys network, go to Resolving Point Names for Known Languages. If you do not know the language, go to Resolving Point Names for Unknown Languages.