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  Discussions  General  Back Up Error...
 Back Up Error
 
 12/18/2008 7:00:16 AM
User is offlinejay221182
66 posts


Back Up Error

Hi All,

I am working on SPI 06.00.07.03 with Oracle 9i. While Taking back up i got following error.

1 :

SQLDBcode: -194: alter table COMPONENT_FUNCTION_TYPE add foreign key hook_up(HU_ID) references

HOOK_UP (HU_ID) ON DELETE SET DEFAULT &&& SQLSTATE = 23000

[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: No primary key value for foreign key ‘hook_up’ in table ‘COMPONENT_FUNCTION_TYPE’

Do you want to continue the Initialization?

2 :

SQLDBcode: -194: alter table HOOK_UP_COMPONENT add foreign key hook_up(HU_ID) references

HOOK_UP (HU_ID) ON DELETE CASCADE &&& SQLSTATE = 23000

[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrity constraint violation: No primary key value for foreign key ‘hook_up’ in table ‘HOOK_UP_COMPONENT’

Do you want to continue the Initialization?

What can be the problem?

 

Any Solution.

 

Regards,

Jay

 12/18/2008 7:33:04 AM
User is offlinewijnand
5 posts
www.intellidata.nl


Re: Back Up Error

You probably assigned a hook-up in the profile of an instrument type, but the hookup doesn’t exists anymore.

If you check your profiles, you will see a number instead of the name of a hookup. When you fix these problems, you can try to create the FK again.

 

Regards,

 

Wijnand

 

http://www.intellidata.nl

http://www.smartplantforum.com


www.intellidata.nl www.smartplantforum.com
  Aggregated  Discussions  General  Back Up Error...
Intools
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank