To Resolve Duplicate Tag Numbers Found in a project associated to an SQL Database OpenPlant PID v8i


Applies To 
Product(s):OpenPlant PID
Version(s):08.11.12.13
Environment: Windows 10 (64 bit)
Area: Synchronization
Subarea: -
Original Author:Fer Mykiel Gonzales, Bentley Technical Support Group

Problem Description

When synchronizing, an error message may pop up that says:

After clicking OK, the piping components that are flagged with duplicate tags will be shown in the Model Validation dialog:

The following steps will show how to resolve this issue in a project with an SQL Database associated to the Bentley Data Manager

Steps to Resolve

1. Take note of the Tag Numbers flagged in the Model Validation dialog

2. Open Bentley Data Manager

3. Open the appropriate Project (this contains the tagging and is associated to the SQL Database)

4. Open the TAG_REG table

4. Look for the Tag flagged in the Model Validation dialog. This should fall under TAG_NO column. Once found, take note of its KEYTAG

5. Open SQL Server Management Studio

6. In the Object Explorer pane, select the Database associated to the Project. Right-click on it and create a new query.

7. Enter the following: DELETE FROM EQUIP* WHERE KEYTAG = <KEYTAG>. Then Execute. 

*the flagged vertical centrifugal pumps belong to the EQUIP table 

8. Check Messages section if query was completed successfully.

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Global Technical Support.  Please include a list of all relevant details to get in depth analysis for a solution or workaround.

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