--------------------------------------------------------------------------------------------------------------- 10-jan-2007 -- Update executed on 10/01/2007 by request of Per Hagen update mmsma.wmf2_meas_env set meas_date = to_date('01-JAN-2001','DD-MON-YYYY') where meas_date = to_date('01-JAN-1950','DD-MON-YYYY'); 14 records updated commit; --------------------------------------------------------------------------------------------------------------- 12-jan-2007 -- Measurement results for the dipole 2339, step='WP08-FID', meas_id=23957 removed from the tables by request of Elena Wildner. -- For the action I took file Z:\tests\Geometric_data\Jerome'sWork\DipoleGeometry\Database\SQL scripts\delete.sql from repository -- and modified it to delete only one measurement. -- New file I put to Z:\tests\Geometric_data\database\MMSMA\cryogeo\SQL_scripts\delete_meas_from_CRYOGEO_EC.sql SQL> set serveroutput on SQL> @delete_from_CRYOGEO.sql 81 / 117 records deleted from CRYOGEO_AXIS. 0 records deleted from CRYOGEO_CORRECTORS. 1 records deleted from CRYOGEO_CM_CFP. 2 records deleted from CRYOGEO_END_COVERS. 4 records deleted from CRYOGEO_FLANGES. 4 records deleted from CRYOGEO_FIDUCIALS. 2 records deleted from CRYOGEO_CARTOGRAPHY. 0 records deleted from CRYOGEO_CURVATURE_CHANGE. 0 records deleted from CRYOGEO_D_POINTS. 2 records deleted from CRYOGEO_STABILITY_HORIZONTAL. 0 records deleted from CRYOGEO_STABILITY_FIDUCIALS. 0 records deleted from CRYOGEO_STABILITY_END_COVERS. 2 records deleted from CRYOGEO_DERIVED_DATA. 1 records deleted from CRYOGEO_CLASSIFICATION. 117 records deleted from CRYOGEO_RACETRACK. 1 records deleted from CRYOGEO_TWIST. Problem occured : -2292 ORA-02292: integrity constraint (MMSMA.CRYOGEO_D_POINTS_FKEY3) violated - child record found PL/SQL procedure successfully completed. -- To delete record with meas_id = 23957 from the table CRYOGEO_MEAS_ENV I also deleted records with reference_meas = 23957 from table CRYOGEO_D_POINTS SQL> @delete_from_CRYOGEO.sql 81 / 117 records deleted from CRYOGEO_AXIS. 0 records deleted from CRYOGEO_CORRECTORS. 1 records deleted from CRYOGEO_CM_CFP. 2 records deleted from CRYOGEO_END_COVERS. 4 records deleted from CRYOGEO_FLANGES. 4 records deleted from CRYOGEO_FIDUCIALS. 2 records deleted from CRYOGEO_CARTOGRAPHY. 0 records deleted from CRYOGEO_CURVATURE_CHANGE. 8 records deleted from CRYOGEO_D_POINTS. 2 records deleted from CRYOGEO_STABILITY_HORIZONTAL. 0 records deleted from CRYOGEO_STABILITY_FIDUCIALS. 0 records deleted from CRYOGEO_STABILITY_END_COVERS. 2 records deleted from CRYOGEO_DERIVED_DATA. 1 records deleted from CRYOGEO_CLASSIFICATION. 117 records deleted from CRYOGEO_RACETRACK. 1 records deleted from CRYOGEO_TWIST. 1 records deleted from CRYOGEO_MEAS_ENV. PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 19-jan-2007 -- Measurement results for the dipole 2339, step='WP09-WELD', meas_id=25847 and step='WP09B-WELD', meas_id=25888 -- removed from the tables by request of Elena Wildner. SQL> set serveroutput on SQL> @delete_meas_from_CRYOGEO_EC.sql 82 / 0 records deleted from CRYOGEO_AXIS. 0 records deleted from CRYOGEO_CORRECTORS. 0 records deleted from CRYOGEO_CM_CFP. 0 records deleted from CRYOGEO_END_COVERS. 0 records deleted from CRYOGEO_FLANGES. 4 records deleted from CRYOGEO_FIDUCIALS. 2 records deleted from CRYOGEO_CARTOGRAPHY. 1 records deleted from CRYOGEO_CURVATURE_CHANGE. 0 records deleted from CRYOGEO_D_POINTS. 0 records deleted from CRYOGEO_STABILITY_HORIZONTAL. 0 records deleted from CRYOGEO_STABILITY_FIDUCIALS. 0 records deleted from CRYOGEO_STABILITY_END_COVERS. 0 records deleted from CRYOGEO_DERIVED_DATA. 0 records deleted from CRYOGEO_CLASSIFICATION. 0 records deleted from CRYOGEO_RACETRACK. 0 records deleted from CRYOGEO_TWIST. 1 records deleted from CRYOGEO_MEAS_ENV. PL/SQL procedure successfully completed. SQL> @delete_meas_from_CRYOGEO_EC.sql 82 / 0 records deleted from CRYOGEO_AXIS. 0 records deleted from CRYOGEO_CORRECTORS. 0 records deleted from CRYOGEO_CM_CFP. 0 records deleted from CRYOGEO_END_COVERS. 0 records deleted from CRYOGEO_FLANGES. 4 records deleted from CRYOGEO_FIDUCIALS. 2 records deleted from CRYOGEO_CARTOGRAPHY. 1 records deleted from CRYOGEO_CURVATURE_CHANGE. 0 records deleted from CRYOGEO_D_POINTS. 0 records deleted from CRYOGEO_STABILITY_HORIZONTAL. 0 records deleted from CRYOGEO_STABILITY_FIDUCIALS. 0 records deleted from CRYOGEO_STABILITY_END_COVERS. 0 records deleted from CRYOGEO_DERIVED_DATA. 0 records deleted from CRYOGEO_CLASSIFICATION. 0 records deleted from CRYOGEO_RACETRACK. 0 records deleted from CRYOGEO_TWIST. 1 records deleted from CRYOGEO_MEAS_ENV. PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 23-jan-2007 -- Update executed on 23/01/2007 by request of Patrick Bestmann -- SQL> update CRYOGEO_D_POINTS 2 set reference_meas = '27569', 3 reference_step = 'WP08-FID' 4 where magnet_nu = 2339; update CRYOGEO_D_POINTS * ERROR at line 1: ORA-20201: Error during trigger execution RefMeas_GEO_DPoints : ORA-20201: The fiducialisation indicated is not the last one. ORA-06512: at "MMSMA.REFMEAS_GEO_DPOINTS", line 15 ORA-04088: error during execution of trigger 'MMSMA.REFMEAS_GEO_DPOINTS' SQL> alter trigger RefMeas_GEO_DPoints disable; Trigger altered. SQL> update CRYOGEO_D_POINTS 2 set reference_meas = '27569', 3 reference_step = 'WP08-FID' 4 where magnet_nu = 2339; 8 rows updated. SQL> commit; Commit complete. SQL> alter trigger RefMeas_GEO_DPoints enable; Trigger altered. --------------------------------------------------------------------------------------------------------------- 06-feb-2007 -- Update and grant executed by request of Patrick Bestmann update CRYOGEO_MEAS_ENV set BLOCKAGE_STATUS = 'itp20' where magnet_nu = 2197 and BLOCKAGE_STATUS = 'other'; 1 record updated commit; Commit complete. grant select on SSSGEO2_BEAM_LINE_EXTREMITIES to TANIS; Grant succeeded --------------------------------------------------------------------------------------------------------------- 27-feb-2007 -- Update executed by request of Patrick Bestmann -- Removal of duplicate and wrong data for LQXC07 magnet SQL> DELETE FROM LOWBETAGEO_AXIS WHERE meas_id= '7Q3_CERN-FIDX_2'; 38 rows deleted. SQL> DELETE FROM LOWBETAGEO_AXIS WHERE meas_id= '7Q3_CERN-MECHX_2'; 47 rows deleted. SQL> DELETE FROM LOWBETAGEO_AXIS WHERE meas_id= '7Q3_CERN-MAGX_2'; 36 rows deleted. SQL> DELETE FROM LOWBETAGEO_AXIS WHERE meas_id= '7Q3_CERN-FIDX_3'; 38 rows deleted. SQL> DELETE FROM LOWBETAGEO_AXIS WHERE meas_id= '7Q3_CERN-MECHX_3'; 47 rows deleted. SQL> DELETE FROM LOWBETAGEO_AXIS WHERE meas_id= '7Q3_CERN-MAGX_3'; 36 rows deleted. SQL> commit; Commit complete. SQL> DELETE FROM LOWBETAGEO_CARTOGRAPHY WHERE meas_id= '7Q3_CERN-MECHX_2'; 2 rows deleted. SQL> DELETE FROM LOWBETAGEO_CARTOGRAPHY WHERE meas_id= '7Q3_CERN-FIDX_3'; 2 rows deleted. SQL> commit; Commit complete. SQL> DELETE FROM LOWBETAGEO_CM_REF_POINTS WHERE meas_id= '7Q3_CERN-MECHX_2'; 2 rows deleted. SQL> DELETE FROM LOWBETAGEO_CM_REF_POINTS WHERE meas_id= '7Q3_CERN-FIDX_3'; 2 rows deleted. SQL> commit 2 ; Commit complete. SQL> DELETE FROM LOWBETAGEO_BEAM_LINE_EXTREMITI WHERE meas_id= '7Q3_CERN-MECHX_2'; 2 rows deleted. SQL> DELETE FROM LOWBETAGEO_BEAM_LINE_EXTREMITI WHERE meas_id= '7Q3_CERN-FIDX_3'; 2 rows deleted. SQL> commit; Commit complete. SQL> DELETE FROM LOWBETAGEO_MEAS_APERTURE WHERE meas_id= '7Q3_CERN-FIDX_2'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_APERTURE WHERE meas_id= '7Q3_CERN-MAGX_2'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_APERTURE WHERE meas_id= '7Q3_CERN-MECHX_2'; 1 row deleted. SQL> commit; Commit complete. SQL> DELETE FROM LOWBETAGEO_MEAS_APERTURE WHERE meas_id= '7Q3_CERN-FIDX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_APERTURE WHERE meas_id= '7Q3_CERN-MAGX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_APERTURE WHERE meas_id= '7Q3_CERN-MECHX_3'; 1 row deleted. SQL> commit 2 / Commit complete. SQL> DELETE FROM LOWBETAGEO_FIDUCIALS WHERE meas_id= '7Q3_CERN-FIDX_2'; 8 rows deleted. SQL> DELETE FROM LOWBETAGEO_FIDUCIALS WHERE meas_id= '7Q3_CERN-MAGX_2'; 8 rows deleted. SQL> DELETE FROM LOWBETAGEO_FIDUCIALS WHERE meas_id= '7Q3_CERN-MECHX_2'; 8 rows deleted. SQL> DELETE FROM LOWBETAGEO_FIDUCIALS WHERE meas_id= '7Q3_CERN-FIDX_3'; 8 rows deleted. SQL> DELETE FROM LOWBETAGEO_FIDUCIALS WHERE meas_id= '7Q3_CERN-MAGX_3'; 8 rows deleted. SQL> DELETE FROM LOWBETAGEO_FIDUCIALS WHERE meas_id= '7Q3_CERN-MECHX_3'; 8 rows deleted. SQL> commit; Commit complete. SQL> DELETE FROM LOWBETAGEO_MEAS_INSTRUMENTS WHERE meas_id= '7Q3_CERN-FIDX_2'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_INSTRUMENTS WHERE meas_id= '7Q3_CERN-MAGX_2'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_INSTRUMENTS WHERE meas_id= '7Q3_CERN-MECHX_2'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_INSTRUMENTS WHERE meas_id= '7Q3_CERN-FIDX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_INSTRUMENTS WHERE meas_id= '7Q3_CERN-MAGX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_INSTRUMENTS WHERE meas_id= '7Q3_CERN-MECHX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_ENV WHERE meas_id= '7Q3_CERN-FIDX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_ENV WHERE meas_id= '7Q3_CERN-MAGX_3'; 1 row deleted. SQL> DELETE FROM LOWBETAGEO_MEAS_ENV WHERE meas_id= '7Q3_CERN-MECHX_3'; 1 row deleted. SQL> commit; Commit complete. SQL> delete from LOWBETAGEO_MEAS_ENV 2 where magnet_name = 'HCLQXC_001-FL000007' 3 and step like '%3'; 3 rows deleted. SQL> commit; Commit complete. SQL> delete from LOWBETAGEO_MAG_STEP_CAT 2 where magnet_name = 'HCLQXC_001-FL000007' 3 and valid_meas_id like '%2'; 3 rows deleted. SQL> commit; Commit complete. SQL> update LOWBETAGEO_MAG_STEP_CAT 2 set valid_meas_id = '7Q3_CERN-FIDX_1' 3 where valid_meas_id = '7Q3_CERN-FIDX_3'; 1 row updated. SQL> update LOWBETAGEO_MAG_STEP_CAT 2 set valid_meas_id = '7Q3_CERN-FIDX_1' 3 where valid_meas_id = '7Q3_CERN-FIDX_3'; 1 row updated. SQL> update LOWBETAGEO_MAG_STEP_CAT 2 set valid_meas_id = '7Q3_CERN-MECHX_1' 3 where valid_meas_id = '7Q3_CERN-MECHX_3'; 1 row updated. SQL> update LOWBETAGEO_MAG_STEP_CAT 2 set valid_meas_id = '7Q3_CERN-MAGX_1' 3 where valid_meas_id = '7Q3_CERN-MAGX_3'; 1 row updated. SQL> commit 2 / Commit complete. SQL> insert into LOWBETAGEO_FINAL_MEAS_CAT 2 values 3 ('HCLQXC_001-FL000007','CERN-FIDX','7Q3_CERN-FIDX_1','echarif','loaded as final',''); 1 row created. SQL> commit; Commit complete. SQL> delete from LOWBETAGEO_MEAS_CAT 2 where meas_id like '7Q3%' 3 and loader_name = 'gaozw'; 6 rows deleted. SQL> commit 2 / Commit complete. SQL> update LOWBETAGEO_FINAL_MEAS_CAT 2 set align_id = 'LQXC07_3' 3 where magnet_name = 'HCLQXC_001-FL000007' 4 and step_category = 'CERN-FIDX'; 1 row updated. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 27-feb-2007 -- Update executed by request of Dominique Missiaen -- ...you should modify the naming of the following SSSs : -- - 601 has to have the name HCLQNCE001-CR000601 for steps WP19-SPOTW and WP19-VBPM -- - 604 HCLQNFI001-CR000604 for step WP19-VBPM -- - 613 HCLQNJF001-CR000613 for step WP19-VBPM -- - 619 HCLQNDD001-CR000619 for step WP19-SPOTW -- - 642 HCLQNJC001-CR000642 for step WP15-CSSW -- - 690 HCLQNFK001-CR000690 for steps WP18-FID, WP18-MECH and WP18-MAG SQL> update sssgeo2_mag_step_cat 2 set magnet_name = 'HCLQNCE001-CR000601' 3 where magnet_nu = 601 4 and magnet_name != 'HCLQNCE001-CR000601'; 2 rows updated. SQL> update sssgeo2_mag_step_cat 2 set magnet_name = 'HCLQNFI001-CR000604' 3 where magnet_nu = 604 4 and magnet_name != 'HCLQNFI001-CR000604'; 1 row updated. SQL> update sssgeo2_mag_step_cat 2 set magnet_name = 'HCLQNJF001-CR000613' 3 where magnet_nu = 613 4 and magnet_name != 'HCLQNJF001-CR000613'; 1 row updated. SQL> update sssgeo2_mag_step_cat 2 set magnet_name = 'HCLQNDD001-CR000619' 3 where magnet_nu = 619 4 and magnet_name != 'HCLQNDD001-CR000619'; 1 row updated. SQL> update sssgeo2_mag_step_cat 2 set magnet_name = 'HCLQNJC001-CR000642' 3 where magnet_nu = 642 4 and magnet_name != 'HCLQNJC001-CR000642'; 1 row updated. SQL> update sssgeo2_mag_step_cat 2 set magnet_name = 'HCLQNFK001-CR000690' 3 where magnet_nu = 690 4 and magnet_name != 'HCLQNFK001-CR000690'; 3 rows updated. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 01-MAR-2006 The blockage status of the MB 2326, was changed on request of E.Wildner from 'itp20' to 'as is': SQL> UPDATE CRYOGEO_MEAS_ENV 2 SET BLOCKAGE_STATUS = 'as is' 3 where meas_id = 28327 4 and BLOCKAGE_STATUS = 'itp20'; 1 row updated. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 02-MAR-2007 -- Additional fiducial for LQXC-07 by request of Patrick Bestmann SQL> insert into lowbetageo_fiducials 2 values 3 ('7Q3_CERN-FIDX_1', 'NIP_D', '-0.42448', '0.85211', '0.54281', null, null, null, null); 1 row created. SQL> insert into lowbetageo_fiducials 2 values 3 ('7Q3_CERN-MAGX_1', 'NIP_D', '-0.42448', '0.85211', '0.54281', null, null, null, null); 1 row created. SQL> insert into lowbetageo_fiducials 2 values 3 ('7Q3_CERN-MECHX_1', 'NIP_D', '-0.42448', '0.85211', '0.54281', null, null, null, null); 1 row created. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 05-MAR-2007 -- Shifts and Measurement results for LQXB03, step='3Q2_CERN-MAGX_2', step='3Q2_CERN-MECHX_2' and step='3Q2_CERN-FIDX_2' -- removed from the tables by request of Patrick Bestmann. -- For the action I've: -- 1) Added name "echarif" to the procedure shifts_admin.INVALIDATE_SHIFT, executed the procedure; -- 2) Took file Z:\tests\Geometric_data\Jerome'sWork\LowBeta\Database\sql script\delete.sql from repository -- and modified it to avoid processing of not existing table LOWBETAGEO_CALC_BEAM_LINE_EX. -- New file I put to Z:\tests\Geometric_data\database\MMSMA\lowbeta\SQL_scripts\delete_meas_from_LOWB_EC.sql SQL> execute shifts_admin.INVALIDATE_SHIFT('LQXB03', 'invalidated on request of Patrick Bestmann'); PL/SQL procedure successfully completed. SQL> @delete_3Q2.sql -- Cond:='''3Q2_CERN-MAGX_2'''; 86 / 0 records deleted from LOWBETAGEO_CALC_ANGLE_SSW. 0 records deleted from LOWBETAGEO_CALC_AXIS_SSW. 0 records deleted from LOWBETAGEO_CALC_AXIS. 0 records deleted from LOWBETAGEO_CALC_APERTURE. 0 records deleted from LOWBETAGEO_CALC_FIDUCIALS. 0 records deleted from LOWBETAGEO_CALC_CATALOG. 0 records deleted from LOWBETAGEO_ANGLE_SSW. 0 records deleted from LOWBETAGEO_AXIS_SSW. 0 records deleted from LOWBETAGEO_DATA_SOURCE_SSW. 47 records deleted from LOWBETAGEO_AXIS. 0 records deleted from LOWBETAGEO_CARTOGRAPHY. 0 records deleted from LOWBETAGEO_END_COVERS. 0 records deleted from LOWBETAGEO_BEAM_LINE_EXTREMITIES. 2 records deleted from LOWBETAGEO_MEAS_APERTURE. 12 records deleted from LOWBETAGEO_FIDUCIALS. 1 records deleted from LOWBETAGEO_MEAS_INSTRUMENTS. 1 records deleted from LOWBETAGEO_MEAS_ENV. 1 records deleted from LOWBETAGEO_FINAL_MEAS_CAT. 1 records deleted from LOWBETAGEO_MAG_STEP_CAT. 1 records deleted from LOWBETAGEO_MEAS_CAT. PL/SQL procedure successfully completed. SQL> @delete_3Q2.sql -- Cond:='''3Q2_CERN-MECHX_2'''; 86 / 0 records deleted from LOWBETAGEO_CALC_ANGLE_SSW. 0 records deleted from LOWBETAGEO_CALC_AXIS_SSW. 0 records deleted from LOWBETAGEO_CALC_AXIS. 0 records deleted from LOWBETAGEO_CALC_APERTURE. 0 records deleted from LOWBETAGEO_CALC_FIDUCIALS. 0 records deleted from LOWBETAGEO_CALC_CATALOG. 0 records deleted from LOWBETAGEO_ANGLE_SSW. 0 records deleted from LOWBETAGEO_AXIS_SSW. 0 records deleted from LOWBETAGEO_DATA_SOURCE_SSW. 56 records deleted from LOWBETAGEO_AXIS. 0 records deleted from LOWBETAGEO_CARTOGRAPHY. 0 records deleted from LOWBETAGEO_END_COVERS. 0 records deleted from LOWBETAGEO_BEAM_LINE_EXTREMITIES. 1 records deleted from LOWBETAGEO_MEAS_APERTURE. 12 records deleted from LOWBETAGEO_FIDUCIALS. 1 records deleted from LOWBETAGEO_MEAS_INSTRUMENTS. 1 records deleted from LOWBETAGEO_MEAS_ENV. 1 records deleted from LOWBETAGEO_FINAL_MEAS_CAT. 1 records deleted from LOWBETAGEO_MAG_STEP_CAT. 1 records deleted from LOWBETAGEO_MEAS_CAT. PL/SQL procedure successfully completed. SQL> @delete_3Q2.sql -- Cond:='''3Q2_CERN-FIDX_2'''; 86 / 0 records deleted from LOWBETAGEO_CALC_ANGLE_SSW. 0 records deleted from LOWBETAGEO_CALC_AXIS_SSW. 0 records deleted from LOWBETAGEO_CALC_AXIS. 0 records deleted from LOWBETAGEO_CALC_APERTURE. 0 records deleted from LOWBETAGEO_CALC_FIDUCIALS. 0 records deleted from LOWBETAGEO_CALC_CATALOG. 0 records deleted from LOWBETAGEO_ANGLE_SSW. 0 records deleted from LOWBETAGEO_AXIS_SSW. 0 records deleted from LOWBETAGEO_DATA_SOURCE_SSW. 54 records deleted from LOWBETAGEO_AXIS. 2 records deleted from LOWBETAGEO_CARTOGRAPHY. 2 records deleted from LOWBETAGEO_END_COVERS. 2 records deleted from LOWBETAGEO_BEAM_LINE_EXTREMITIES. 1 records deleted from LOWBETAGEO_MEAS_APERTURE. 12 records deleted from LOWBETAGEO_FIDUCIALS. 1 records deleted from LOWBETAGEO_MEAS_INSTRUMENTS. 1 records deleted from LOWBETAGEO_MEAS_ENV. 1 records deleted from LOWBETAGEO_FINAL_MEAS_CAT. 1 records deleted from LOWBETAGEO_MAG_STEP_CAT. 1 records deleted from LOWBETAGEO_MEAS_CAT. PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. -- Measurement results for SSS529, step='529_WP18X-MAG_1', step='529_WP18X-FID_1' and step='529_WP18X-MECH_1' -- removed from the tables by request of Patrick Bestmann. -- For the action I used file Z:\tests\Geometric_data\Jerome'sWork\SSSGeometry\Database\sql script\delete2modif.sql from repository SQL> @delete2modif.sql -- Cond:='''529_WP18X-MAG_1'''; 92 / 0 records deleted from SSSGEO2_CALC_ANGLE_SSW. 0 records deleted from SSSGEO2_CALC_AXIS_SSW. 0 records deleted from SSSGEO2_CALC_AXIS. 0 records deleted from SSSGEO2_CALC_BEAM_LINE_EX. 0 records deleted from SSSGEO2_CALC_APERTURE. 0 records deleted from SSSGEO2_CALC_FIDUCIALS. 0 records deleted from SSSGEO2_CALC_CATALOG. 0 records deleted from SSSGEO2_ANGLE_SSW. 0 records deleted from SSSGEO2_AXIS_SSW. 0 records deleted from SSSGEO2_DATA_SOURCE_SSW. 68 records deleted from SSSGEO2_AXIS. 0 records deleted from SSSGEO2_CARTOGRAPHY. 0 records deleted from SSSGEO2_END_COVERS. 0 records deleted from SSSGEO2_BEAM_LINE_EXTREMITIES. 0 records deleted from SSSGEO2_D_POINTS. 0 records deleted from SSSGEO2_BOSSES. 6 records deleted from SSSGEO2_MEAS_APERTURE. 3 records deleted from SSSGEO2_FIDUCIALS. 1 records deleted from SSSGEO2_MEAS_INSTRUMENTS. 1 records deleted from SSSGEO2_MEAS_ENV. 1 records deleted from SSSGEO2_FINAL_MEAS_CAT. 1 records deleted from SSSGEO2_MAG_STEP_CAT. 1 records deleted from SSSGEO2_MEAS_CAT. PL/SQL procedure successfully completed. SQL> @delete2modif.sql -- Cond:='''529_WP18X-FID_1'''; 92 / 0 records deleted from SSSGEO2_CALC_ANGLE_SSW. 0 records deleted from SSSGEO2_CALC_AXIS_SSW. 0 records deleted from SSSGEO2_CALC_AXIS. 0 records deleted from SSSGEO2_CALC_BEAM_LINE_EX. 0 records deleted from SSSGEO2_CALC_APERTURE. 0 records deleted from SSSGEO2_CALC_FIDUCIALS. 0 records deleted from SSSGEO2_CALC_CATALOG. 0 records deleted from SSSGEO2_ANGLE_SSW. 0 records deleted from SSSGEO2_AXIS_SSW. 0 records deleted from SSSGEO2_DATA_SOURCE_SSW. 60 records deleted from SSSGEO2_AXIS. 0 records deleted from SSSGEO2_CARTOGRAPHY. 0 records deleted from SSSGEO2_END_COVERS. 0 records deleted from SSSGEO2_BEAM_LINE_EXTREMITIES. 0 records deleted from SSSGEO2_D_POINTS. 0 records deleted from SSSGEO2_BOSSES. 2 records deleted from SSSGEO2_MEAS_APERTURE. 3 records deleted from SSSGEO2_FIDUCIALS. 1 records deleted from SSSGEO2_MEAS_INSTRUMENTS. 1 records deleted from SSSGEO2_MEAS_ENV. 1 records deleted from SSSGEO2_FINAL_MEAS_CAT. 1 records deleted from SSSGEO2_MAG_STEP_CAT. 1 records deleted from SSSGEO2_MEAS_CAT. PL/SQL procedure successfully completed. SQL> @delete2modif.sql -- Cond:='''529_WP18X-MECH_1'''; 92 / 0 records deleted from SSSGEO2_CALC_ANGLE_SSW. 0 records deleted from SSSGEO2_CALC_AXIS_SSW. 0 records deleted from SSSGEO2_CALC_AXIS. 0 records deleted from SSSGEO2_CALC_BEAM_LINE_EX. 0 records deleted from SSSGEO2_CALC_APERTURE. 0 records deleted from SSSGEO2_CALC_FIDUCIALS. 0 records deleted from SSSGEO2_CALC_CATALOG. 0 records deleted from SSSGEO2_ANGLE_SSW. 0 records deleted from SSSGEO2_AXIS_SSW. 0 records deleted from SSSGEO2_DATA_SOURCE_SSW. 88 records deleted from SSSGEO2_AXIS. 1 records deleted from SSSGEO2_CARTOGRAPHY. 2 records deleted from SSSGEO2_END_COVERS. 3 records deleted from SSSGEO2_BEAM_LINE_EXTREMITIES. 0 records deleted from SSSGEO2_D_POINTS. 0 records deleted from SSSGEO2_BOSSES. 2 records deleted from SSSGEO2_MEAS_APERTURE. 3 records deleted from SSSGEO2_FIDUCIALS. 1 records deleted from SSSGEO2_MEAS_INSTRUMENTS. 1 records deleted from SSSGEO2_MEAS_ENV. 1 records deleted from SSSGEO2_FINAL_MEAS_CAT. 1 records deleted from SSSGEO2_MAG_STEP_CAT. 1 records deleted from SSSGEO2_MEAS_CAT. PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 08-MAR-2007 -- Measurement results for the dipole 1414, step='WP08', meas_id=27298 removed from the tables by request of Elena Wildner. -- File delete_meas_from_CRYOGEO_EC.sql from Z:\tests\Geometric_data\database\MMSMA\cryogeo\SQL_scripts\delete_meas_from_CRYOGEO_EC.sql SQL> execute shifts_admin.INVALIDATE_SHIFT('1414', 'invalidated on request of Patrick Bestmann'); PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. SQL> @delete_meas_from_CRYOGEO_EC.sql; -- meas_id=27298 73 / 117 records deleted from CRYOGEO_AXIS. 0 records deleted from CRYOGEO_CORRECTORS. 1 records deleted from CRYOGEO_CM_CFP. 2 records deleted from CRYOGEO_END_COVERS. 4 records deleted from CRYOGEO_FLANGES. 4 records deleted from CRYOGEO_FIDUCIALS. 2 records deleted from CRYOGEO_CARTOGRAPHY. 0 records deleted from CRYOGEO_CURVATURE_CHANGE. 4 records deleted from CRYOGEO_D_POINTS. 2 records deleted from CRYOGEO_STABILITY_HORIZONTAL. 0 records deleted from CRYOGEO_STABILITY_FIDUCIALS. 0 records deleted from CRYOGEO_STABILITY_END_COVERS. 2 records deleted from CRYOGEO_DERIVED_DATA. 1 records deleted from CRYOGEO_CLASSIFICATION. 117 records deleted from CRYOGEO_RACETRACK. 1 records deleted from CRYOGEO_TWIST. 1 records deleted from CRYOGEO_MEAS_ENV. PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. SQL> @delete_meas_from_CRYOGEO_EC.sql; -- meas_id=28568 (WP09) 73 / 0 records deleted from CRYOGEO_AXIS. 0 records deleted from CRYOGEO_CORRECTORS. 0 records deleted from CRYOGEO_CM_CFP. 0 records deleted from CRYOGEO_END_COVERS. 0 records deleted from CRYOGEO_FLANGES. 4 records deleted from CRYOGEO_FIDUCIALS. 2 records deleted from CRYOGEO_CARTOGRAPHY. 1 records deleted from CRYOGEO_CURVATURE_CHANGE. 0 records deleted from CRYOGEO_D_POINTS. 0 records deleted from CRYOGEO_STABILITY_HORIZONTAL. 0 records deleted from CRYOGEO_STABILITY_FIDUCIALS. 0 records deleted from CRYOGEO_STABILITY_END_COVERS. 0 records deleted from CRYOGEO_DERIVED_DATA. 0 records deleted from CRYOGEO_CLASSIFICATION. 0 records deleted from CRYOGEO_RACETRACK. 0 records deleted from CRYOGEO_TWIST. 1 records deleted from CRYOGEO_MEAS_ENV. PL/SQL procedure successfully completed. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 08-MAR-2007 -- Values in "approved_by" and "approval_date" were updated to null for magnet_nu = 1219 and applied_to = 'alignment'; -- The update became necessary after the shifts invalidation for the magnet (03-NOV-2006, execute -- MMSMA.SHIFTS_ADMIN.invalidate_shift('1219', 'ipack remained stored since aug-2005 while magnet was de-qualified')) -- and due to absence of new shifts. SQL> update CRYOGEO_STEP_CHOICE 2 set approved_by = null, 3 approval_date = null 4 where magnet_nu = 1219 5 and applied_to = 'alignment'; 1 row updated. SQL> commit 2 / Commit complete. --------------------------------------------------------------------------------------------------------------- 04-MAY-2007 -- By request of Ptarick Bestmann new columns are created in the table SSSGEO2_FIDUCIALS. -- Values from the columns fidu_x, fidu_y, fidu_z are transfered to the columns -- fidu_x_grav, fidu_y_grav, fidu_z_grav for the measurements "WP19...". SQL> update SSSGEO2_FIDUCIALS 2 set fidu_x_grav = fidu_x, 3 fidu_y_grav = fidu_y, 4 fidu_z_grav = fidu_z 5 where meas_id like '%WP19%'; 3293 rows updated. SQL> commit 2 / Commit complete. SQL> update SSSGEO2_FIDUCIALS 2 set fidu_x = null, 3 fidu_y = null, 4 fidu_z = null 5 where meas_id like '%WP19%'; 3293 rows updated. SQL> commit; Commit complete. --------------------------------------------------------------------------------------------------------------- 10-MAY-2007 -- By request of Patrick Bestmann value in the column GA_ON is changed to '629_WP19X-VBPM_2' from '629_WP18X-MECH_1' -- for the SSS 629. -- That was done to get final_choice = 'T' associated with measurement '629_WP19X-VBPM_2' exclusively chosen -- for this magnet as a package for alignment. SQL> update SSSGEO2_MEAS_ENV 2 set ga_on = '629_WP19X-VBPM_2' 3 where meas_id = '629_WP19X-VBPM_2'; 1 row updated. SQL> update SSSGEO2_MEAS_ENV 2 set ga_on = '629_WP19X-VBPM_2' 3 where meas_id in ('629_WP18X-MECH_1','629_WP18X-MAG_1','629_WP18X-FID_1'); 3 rows updated. SQL> commit; Commit complete. -- View SSS_GEO_MEAS_ENV modified to show value 'AC mole' in the column 'GA_ON' for SSS 626. CREATE OR REPLACE VIEW SSS_GEO_MEAS_ENV (MAGNET_NU, STEP, FINAL_CHOICE, MAGNET_NAME, STAGE, MEAS_DATE, TREAT_DATE, GA_ON, BUNDLE_RMS, OPERATOR, GEOREF, ROOM_TEMPERATURE, MAGNET_TEMPERATURE, BEST_FIT_ON_BOSSES, BEST_FIT_ON_FIDUCIALS, REFERENCE_MEAS, MEAS_PROCEDURE, COMMENTS, LOADER_NAME, LOADING_DATE, MEAS_ID) AS SELECT valid.magnet_nu, valid.step, (CASE WHEN final.final_meas_id is NOT null THEN 'T' ELSE NULL END), valid.magnet_name, valid.stage, env.meas_date, env.treat_date, (CASE WHEN env.GA_ON like '%WP18X-FID%' THEN 'GEO mole' WHEN env.GA_ON like '%WP18X-MECH%' or env.GA_ON like '%WP19%' THEN 'AC mole' END), -------------------------- env.bundle_rms, env.operator, env.georef, env.room_temperature, env.magnet_temperature, env.BEST_FIT_ON_BOSSES, env.best_fit_on_fiducials, env.reference_meas, env.MEAS_PROCEDURE, env.comments, meascat.loader_name,meascat.loading_date, env.meas_id FROM SSSGEO2_MAG_STEP_CAT valid, SSSGEO2_MEAS_ENV env , SSSGEO2_MEAS_CAT MeasCat, SSSGEO2_FINAL_MEAS_CAT final WHERE env.meas_id=MeasCat.Meas_Id AND env.meas_id=valid.valid_Meas_Id AND env.meas_id=final.final_Meas_Id(+) AND env.ga_on=final.final_Meas_Id(+) with read only; --------------------------------------------------------------------------------------------------------------- 07-JULY-2007 -- Old shifts are invalidated for MQX-C02 and new shifts are loaded according to Patrick Bestmann request. --------------------------------------------------------------------------------------------------------------- 10-JULY-2007 -- Update executed by request of Patrick Bestmann except the last value (L_DY should be "-172.20") -- which can not be loaded due to the table structure -- "I could load the fiducialisation CERN-FID3 for the LQXC-02. But there are some cells -- I had to modify in order to load the file and I would ask you to correct this.... -- - in the view MMSMA.LOWBGEO_MEAS_INSTRUMENTS the value of Mole_name for CERN-FID3 is "63" -- and ist should be "BS 63" for Beam Screen Mole -- - in the view MMSMA.LOWBGEO_MEAS_ENV we should add the comment "Remeasured with installed Beam Screen; -- Best Fit done on Geo Mole from Fiducialisation 2!!" -- - in the view MMSMA.LOWBGEO_BEAM_LINE_EXTREMITIES the values for ANLE are "0" -- for IP and NIP side and they should be NULL -- - in the view MMSMA.LOWBGEO_CARTOGRAPHY the value for L_DY is NULL ans it should be "-172.20" -- (it was a trigger which denied these big value....)" Patrick update lowbetageo_meas_instruments set mole_name = 'BS 63' where meas_id = '2Q3_CERN-FIDX_3'; 1 record updated update lowbetageo_meas_env set comments = 'Remeasured with installed Beam Screen; Best Fit done on Geo Mole from Fiducialisation 2!!' where meas_id = '2Q3_CERN-FIDX_3'; 1 record updated update lowbetageo_beam_line_extremiti set angle = null where meas_id = '2Q3_CERN-FIDX_3'; 2 records updated commit; Commit complete. --------------------------------------------------------------------------------------------------------------- 25-JULY-2007 -- Update executed by request of Elena Wildner -- to delete information about shifts (not invalidate!) for the magnet 523 from DB update SSSGEO2_FINAL_MEAS_CAT set align_id = null where align_id = '523_1'; 1 record updated delete from SSSGEO2_ALIGNMENT where align_id = '523_1'; 1 record deleted commit; commit complete