Register  ::  Login
 
Update : September 09, 2010
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  Discussions  Intools Ver 6  Problem in merg...
 Problem in merginig database
 
 5/25/2009 11:59:48 AM
User is offlineDP
14 posts


Problem in merginig database

Hi All,

I am merging the data of two databases i.e. ODBC(Source) and Oracle(Target)

Here ODBC is the DSN of INTOOLS.db file.

I am merging the data at unit level from both databases.

bot the databases are having same data so i have deleted some tags from target so as to get it back after merging but the log file of merger says:

CMPNT_ID not found in the source table COMPONENT for CMPNT_NAME = '111-006-PT   -169'.

But  when i checked it manually in the source database it is there.

So pls. help

Thanks in advance,

PJD

 

 5/25/2009 12:01:36 PM
User is offlineDP
14 posts


Re: Problem in merging database
 DP wrote

Hi All,

I am merging the data of two databases i.e. ODBC(Source) and Oracle(Target)

Here ODBC is the DSN of INTOOLS.db file.

I am merging the data at unit level from both databases.

bot the databases are having same data so i have deleted some tags from target so as to get it back after merging but the log file of merger says:

CMPNT_ID not found in the source table COMPONENT for CMPNT_NAME = '111-006-PT   -169'.

But  when i checked it manually in the source database it is there.

So pls. help

Thanks in advance,

PJD

 

 5/26/2009 2:42:12 PM
User is offlineadmin
177 posts
5th


Re: Problem in merginig database

Hi,

 

check the tag_trans_name for this tag in the component table and compare it with others.

 

Ilan


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 5/28/2009 6:21:02 AM
User is offlineDP
14 posts


Re: Problem in merginig database

Hi,

Thanks Ilan.

i have checked the tag_trans_name for this tag in the component table and also checked the tag_trans_name for the merged tags but i didn't find any difference.

Still anything more to compare/check ?

There is 1 more error in log file related to this tag.

Insert data. Problem with the foreign keys.
tag_trans_name = 111-006-PT   -169;
  Foreign Key : LINE_ID=0

Thanks in advance,

PJD

  Aggregated  Discussions  Intools Ver 6  Problem in merg...
Intools
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank