Register  ::  Login
 
Update : May 20, 2012
Google AdSense Minimize
  
Welcome to Asbuilt-DBA forum ! Minimize

Here you can find a community of professionals who work with INtools® (SPI) and want to interact and exchange information, including problems encountered, offer solutions, and raise new topics.

This forum is composed of two main sections:
1.      Discussions, which is an open discussion forum where you can talk about any related topic to INtools.
2.      FAQ section that offers a variety of questions and answers regarding INtools.
We hope that you will enjoy participating in this forum. Participation in the forum is free of charge.
If you want to start a new forum, please contact the Webmaster.
Add to Google
INtools is trademark of Intergraph corporation
Forum Groups Minimize
SearchForum Home
  Aggregated  FAQ  Wiring  Fieldbus Tag no...
 Re: Fieldbus Tag not display in Fieldbus Browser Tag List
 
 3/18/2009 1:02:34 AM
User is offlinefba_sen57
73 posts
www.shell.com


Re: Fieldbus Tag not display in Fieldbus Browser Tag List

Hi Ilan,

Just to share. Manage to find out what has caused to the problem. Via internal set-up, it was noticed that the tags belong to fieldbus are listed (in component table) but not in INtools (in index list nor in fieldbus tag browser list).

Run a sql to check the segment name of the missing tags in Segment Wiring browser. Take note of the wire_group_id. In my case, there are two records for the segment after the "copy unit" option is used. Somehow the "copy unit" duplicate the wire_group_id of the source database and hence the tags were not displayed.

Example in my case show of the 2 project (source and target) and the segment where the missing tags occur:

select * from wire_group where eng_proj_id in (525243, 525244) and group_name in ('S8','S9','S10','S11','S12','S13','S14','S15','S16') order by group_name;

Wire_Group_Id Group_Name Plant_Id Eng_Proj_Id
538484 S8 520990 525243
574792 S8 84434 525244

select cmpnt_name, wire_group_id, eng_proj_id from component where wire_group_id in (538484,574792);

The result after the sql is executed (see below) where wire_group_id in the component table shows the same = 538484. Therefore another sql to correct the wire_group_id must = 574792 for eng_proj_id=525244 from the above result.

Cmpnt_Id Cmpnt_Name Wire_Group_Id Plant_Id Eng_Proj_Id
529520 01HY   -001 538484 520990 525243
546856 01HY   -001 538484 84434 525244
529550 01PT   -005 538484 520990 525243
546861 01PT   -005 538484 84434 525244
529533 01PT   -009 538484 520990 525243
546859 01PT   -009 538484 84434 525244
529557 01PT   -301 538484 520990 525243
546862 01PT   -301 538484 84434 525244

alter table component disable all triggers;
update component set wire_group_id = 574792 where wire_group_id=538484 and eng_proj_id=525244;
alter table component enable all triggers;

As a result, all the fieldbus tags that were missing from the Segment Wiring are now displayed.

This solution may not be applicable to other type of similar problem as it may differ slightly and may have other related tables to look at.

Hope it will benefit others. Thanks.

  Aggregated  FAQ  Wiring  Fieldbus Tag no...
Intools
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank