Register  ::  Login
 
Update : February 06, 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  Intools Ver 6  Error while Upg...
 Error while Upgrading
 
 3/18/2009 6:38:17 AM
User is offlinekedar
18 posts


Error while Upgrading
Hi All,

While upgrading the INTools Database from version 05.03.09.03 to version 06.00.06.06 Admin is successfully upgraded while upgrading Domain It is giving error message " Integrity constraint violation: Column 'CABLE_SET_ID' in table 'COMPONENT_PROFILE_WIRING' cannot be NULL. I have also attached a snap of this error message. And hence upgrading procedure is terminated.

I have already run the checkdb of version 5 Database.

Is anybody knows about this error.

Thanks,
Kedar
 3/18/2009 10:09:33 AM
User is offlineadmin
177 posts
5th


Re: Error while Upgrading

Hi,

I think you have in the profile cable that not exists.

Please connect to the domain schema and run the following:

select cf.cmpnt_func_type_name,cp.cable_id from component_function_type cf,component_profile_wiring cp where cf.cmpnt_func_type_id = cp.cmpnt_func_type_id and cp.cable_id not in(select cable_id from cable);

save the results as Excel file and send it to: admin@asbuilt-dba.com

Ilan

 


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 3/18/2009 2:05:34 PM
User is offlinekedar
18 posts


Re: Error while Upgrading

Hi Ilan,

Thanx for your reply.

 I have executed the query sent by you using the 6 ver upgraded (with errors) .DB file. Its result is 0 rows.

Please give your advice.

Kedar

 3/18/2009 2:58:36 PM
User is offlineadmin
177 posts
5th


Re: Error while Upgrading

hi,

 

It might be cable without cable set lets run the following:

select cf.cmpnt_func_type_name,cp.cable_id from component_function_type cf,component_profile_wiring cp where cf.cmpnt_func_type_id = cp.cmpnt_func_type_id and cp.cable_id not in(select cable_id from cable_set);

Ilan

 


Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 3/19/2009 6:42:01 AM
User is offlinekedar
18 posts


Re: Error while Upgrading

Hi,

Thanx Ilan.

I run the query sent by you and found that, the Cable Set and hence Cable_Set_ID is not available for the Cable_ID 70941. This cable is assigned to the profile of Instrument Type XE.

Please advice for the further actions.

Thanx,

Kedar

  Aggregated  Discussions  Intools Ver 6  Error while Upg...
Intools
 Search   Forum Home     

Search Engine Optimization and SEO Tools
My Google Pagerank