How to Setup Instrument Tag to Be Unique in Project Database


Applies To 
Product(s):OpenPlant PID
Version(s):08.11.10.XXX (SS5) | 08.11.11.XXX (SS6)
Environment: Windows 7/8.1/10 (64 bit)
Area: Tag Format
Subarea: 
Original Author:Kestutis Mitkus, Bentley Product Advantage Group

Background

By default Tag Uniqueness in Project with associated databases are already configured, but we have situation where user is willing to have uniqueness for Control valves same as for other Instruments. Control Valves and Instruments are Synchronized to same INSTR database table, but both classes are mapped with different TAG_TYPES, what is the cause of this situation, when Control Valves can Have same Tag names as Instruments.

This article will show the user how the schema can be modified to achieve this requirement for Control Valve and Instrument classes.

Steps to Accomplish

  1. Start Bentley Class Editor and Select to open Database Mapping


  2. If this option was never used then remove Existing Mapping and then Browse for your Projects Schema folder
  3. Select OK to open Mapping schema
  4. When schema is opened you can find all links to all mapped Classes on schema in right side of Class Editor. Select Control Valve.


  5. Select Control Valve in left side tree again and then it will load all Class mapping information in the right side. Click Edit button.


  6. In General section Select on existing Class Specification and click Edit button. In opened dialog Change AT_CVALVE value to AT_INST_ and accept changes.


  7. After changing Tag Type in General section and saving all changes Tag Type value is update in all queries, but on Insert section Default Colum Values still shows older Tag Type value.
    This should be edited and changed to Required one.
  8. Save Database Mapping changes and close all schemas


  9. Start OpenPlant PID again and test Control Valve and Discrete Instrument Tags between different models.
  10. After successful Synchronization Open INSTR Table in your database or in Data Manager and verify how Control valve and Discrete instrument has same Tag type.


    If Differentiating of Control Valve components is required you can use IINT1 Filed which contains Class names of each component.

See Video

After such changes standard View Instrument List - Control Valves wont be listing any components because it is configured to list components using TAG_TYPE criteria AT_CVALVE
This configuration can be changed by removing TAG_TYPE criteria and adding required component class in IINT1 criteria field. Full procedure with Instruction and video can be found in this wiki How to Edit Existing View and Change Criteria to List Required Components

communities.bentley.com/.../how-to-edit-existing-view-and-change-criteria-to-list-required-components

Comments or Corrections?

Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!