Register  ::  Login
 
Home

Forum

About Us

Contact Us

Services

Jobs
  Forum 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  General  Changing UOM De...
 Changing UOM Defaults
 
 1/5/2007 4:17:27 PM
User is offlinegreg.brueckner.b
2 posts


Changing UOM Defaults

Is this a know problem? Trying to change default UOM in the Unit of Measure and Accurcy dialog and selecting the Apply to all units option - I am getting the Oracle error

ORA-00001: unique constraint (IN_BTOWN.PK_CALC_PD_PROPERTY_PAU) violated

No changes made to database.
 1/5/2007 5:14:44 PM
User is offlineadmin
177 posts
5th


Re: Changing UOM Defaults

Looks like a problem with the FK between the tables calc_pd_property_pau and calc_pd_property

Please add in Intools.ini section database TRACE=1 reproduce the problem in intools application and send me the trace file  to the following e-mail adress ihills@asbuilt-dba.com

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 1/5/2007 7:00:16 PM
User is offlineadmin
177 posts
5th


Re: Changing UOM Defaults

You can run the following SQL to find the problematic rows:

select distinct unit_id,CALC_PD_PROP_CID,count(CALC_PD_PROP_CID) from CALC_PD_PROPERTY_PAU group by unit_id,CALC_PD_PROP_CID having count(CALC_PD_PROP_CID) >1;

select distinct unit_id,CALC_PD_PROP_CID,count(rtrim(CALC_PD_PROP_CID)) from CALC_PD_PROPERTY_PAU group by unit_id,CALC_PD_PROP_CID having count(rtrim(CALC_PD_PROP_CID)) >1;

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com
 10/30/2007 3:42:14 AM
User is offlinefba_sen57
73 posts
www.shell.com


Re: Changing UOM Defaults

In version 6, there are about 43 uom and accuracy properties. I have the insert statement in order to update the properties. In some of the domain I work with, I had similar problem and had execute the update through sql environment. Prior to the update, I need the plant_id, area_id and unit_id as these are required in the insert statement and if necessary I need to delete the old property first. xxxx is the domain name and for plant_id, area_id, and unit_id get from step 2.

1. delete from xxxx.calc_pd_property_pau where unit_id=204624 and plant_id=1 and area_id=62316;

2. select p.plant_id, p.plant_name, pa.area_id, pa.area_name, pau.unit_id, pau.unit_name from xxxx.plant p, xxxx.plant_area pa, xxxx.plant_area_unit pau where p.plant_id=pa.plant_id and pa.plant_id=pau.plant_id and pau.plant_id=p.plant_id and pa.area_id=pau.area_id order by p.plant_id, pa.area_id, pau.unit_name;

3.

alter table xxxx.calc_pd_property_pau disable all triggers;

insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Ambient Temperature ', ':F ', 2, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '68');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Area ', 'in2 ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Barometric Pressure ', 'atm(stand)', 5, 'A', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '1');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Base Pressure ', 'psi ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '14.696');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Base Temperature ', ':F ', 2, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '60');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Beta Ratio ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Calibration Settings ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '0');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Compressibility factor ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Conductivity ', 'S/cm ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Control Valve Coefficients ', ' ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Control Valve Cv and Kv ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Control Valve Opening ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Density ', 'kg/m3 ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Design Pressure ', 'bar ', 3, 'G', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Diameter ', 'in ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Diff. Pressure (Control Valve)', 'psi ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Diff. Pressure (DP instrument)', 'psi ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Diff. Range (Flow) ', 'inH2O ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Flow Meter Coefficients ', ' ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Frequency ', ' ', 2, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Gas Flow ', 'ft3/h ', 4, 'A', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Latent Heat ', 'kcal IT/kg', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Length ', 'mm ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Liquid Flow ', 'US gal/min', 4, 'A', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Molecular Mass ', ' ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Other ', ' ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Percentage ', '% ', 5, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Pressure ', 'bar ', 4, 'G', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Relief Valve Coefficients ', ' ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Resistance/Length ', 'MOhm/km ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Return Pressure ', 'bar ', 4, 'G', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Return Temperature ', ':C ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Sound Level ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Specific Gravity ', ' ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Specific Heat ', 'BtuIT/lb:F', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Specific Heats Ratio ', ' ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Steam Flow ', 'lb/h ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Temperature ', ':C ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Thermowell Coefficients ', ' ', 2, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Thermowell Length ', 'in ', 4, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Vapour Pressure ', 'Pa ', 4, 'A', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Velocity ', 'ft/s ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');
insert into TRAINING_DOMAIN.calc_pd_property_pau values (204624, 'Viscosity ', 'cP ', 3, ' ', 146, 8497, 1, 62316 , 0, 'DBA' , 'W', sysdate, '');

alter table TRAINING_DOMAIN.calc_pd_property_pau enable all triggers;
---------------------------------------------------

Hope the sharing is of beneficial to all.
 Page 1 of 1
NextPreviousNo Rating
  Aggregated  Discussions  General  Changing UOM De...
Intools
 Search   Forum Home     
website monitored by
host-tracker.com
website monitoring service

Search Engine Optimization and SEO Tools
My Google Pagerank
Copyright 2005 by AsBuilt - DBA   ::  AsBuilt-DBA  ::  Privacy Statement  ::  Terms Of Use