Lhep: 1 revision imported

2015-03-18T07:49:27Z

1 revision imported

← Older revision	Revision as of 07:49, 18 March 2015
(No difference)

Lhep: /* Publishing into the central DB (OPFRA01) */

2008-07-20T09:13:30Z

Publishing into the central DB (OPFRA01)

New page

== Event info ==
[[Image:Ev183582134.gif|thumb|Detector view]]

Rock muon

Event 183582134

09/10/2007

Brick 3040796, Side -1 Row 35 Cell 12 Wall 12 SM 1

== Predictions ==
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/from_luillo.txt from_luillo.txt]

== Scan Log ==
18:30

Starting scan using [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/tutorial.txt Tutorial]

Created [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map.XG b040796.map.XG] with spaces.

Removed unnecessary digits after commas, removed 4th mark, left only 3.

No CR must be at the end of string!

Executed translate_mapfile(), [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map.XL b040796.map.XL] generated.

Copied [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map.XL b040796.map.XL] to [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map b040796.map], loaded plate 57. Marks are found easily.

Measured corner and optival marks (bottom layer)

create_mapfile(436.6, -37.9, 10406.4,10172.4, 10459.5, 90554.0, 115799.3, 90526.6)

Copied [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map.OL b040796.map.OL] to [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map b040796.map]

Created [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.0.1.100.operation.h b040796.0.1.100.operation.h]

Created [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.0.1.100.pred.txt.XG b040796.0.1.100.pred.txt.XG]

executed create_predictions(), created [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p057/40796.57.1.100.pred.txt 40796.57.1.100.pred.txt]

[[Image:Path.png|thumb|Muon path]] [[Image:grains.png|thumb|Grains]] [[Image:Historsiduals.png|thumb|Residuals]]

Manual checks.... load brick with optical marks... Found at (82692,26868), angles 0.0044, 0.0456 (very close to TT LINEAR fit)

19:55 Starting scanback.. (.L scan.C, scanback())

From the first attempt wrong track is found... renewed FlatField, adjusted thresholds.

pl57 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p057/40796.57.1.100.man.pred.txt 40796.57.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p057/40796.57.1.100.man.found.txt 40796.57.1.100.man.found.txt ]
Going on...

Pl56 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p056/40796.56.1.100.man.pred.txt 40796.56.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p056/40796.56.1.100.man.found.txt 40796.56.1.100.man.found.txt ]

Pl55 intercalibration failed...the brick was exposed to CR vertically????...not clear.

Increased IC zone up to 1x1cm. (set DX:CALIB DY_CALIB and START_PLATE=56 to re-generate zones)

Rescan IC for pl56 and pl55, 55-56 -> 43 matches

Pl55 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p055/40796.55.1.100.man.pred.txt 40796.55.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p055/40796.55.1.100.man.found.txt 40796.55.1.100.man.found.txt ]

Pl54 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p054/40796.54.1.100.man.pred.txt 40796.54.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p054/40796.54.1.100.man.found.txt 40796.54.1.100.man.found.txt ]

Pl53 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p053/40796.53.1.100.man.pred.txt 40796.53.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p053/40796.53.1.100.man.found.txt 40796.53.1.100.man.found.txt ]

Pl52 PlateChanger failure (double separator in pile) Solved remotely, re-started.

Pl52 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p052/40796.52.1.100.man.pred.txt 40796.52.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p052/40796.52.1.100.man.found.txt 40796.52.1.100.man.found.txt ]

Pl51 PlateChanger failure. Goind to lab to check...took separator with emulsion glued below.

Re-shuffled all emulsions.

Reduced IC area to 8x8mm

Restarted from IC pl51. 22 matches

Pl51 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p051/40796.51.1.100.man.pred.txt 40796.51.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p051/40796.51.1.100.man.found.txt 40796.51.1.100.man.found.txt ]

Pl50 found...
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p050/40796.50.1.100.man.pred.txt 40796.50.1.100.man.pred.txt ]
[http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/p050/40796.50.1.100.man.found.txt 40796.50.1.100.man.found.txt ]

Pl17 found ... goes on...

Pl1, found, finished.

Other plots are [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/plots/ here]

== DB Publication ==

Substituted spaces by underscores in [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.map.XG b040796.map.XG].

Make sure that in [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b040796/b040796.0.1.100.operation.h b040796.0.1.100.operation.h] file FROM_PLATE=57, TO_PLATE=1

Started @12:15

root [0] .L b040796.h
root [1] .L b040796.0.1.100.operation.h
root [2] .L LibScanToOracle7.C
root [3] #define MIC_NAME MIC1
root [4] #define USER KRESLO
root [5] Add()
Server info: Oracle
AddBrick started
40796 'OPERA BE BK01'
Error in <TOracleServerE2W::TOracleServerE2W>: AddBrick_Space; failed: (error: ORA-14312: Value 1040796 already exists in partition 3
ORA-06512: at "OPERA.PC_ADD_BRICK_SPACE", line 21
)
Warning! Wrong format in the file /terabig/scan/MICROSCOPE1/ONLINE/b040796/b040796.geometry
AddHeaderOperation started
AddHeaderOperation completed
Elapsed time = 1 seconds
DumpListOfHeaderOperations started
Operation: 5000000000720004, start time: 04-JUL-08, notes:
DumpListOfHeaderOperations completed
Elapsed time = 0 seconds
Connection Closed

root [6] init();
...
root [7] AddCalibrationOperation("5000000000720004"); <-------------This is probably a mistake, however publication worked. Normally this ID should be generated by AddHeaderOperation("Intercalibration")
AddCalibrationOperation started
GetEntries = 57 56
EdbScanSet:
Brick 40796 with 57 plates:
57 0.00 1.000000 0.000000 0.000000 1.000000 0.000000 0.000000
...
plate 57
id calibration operation = 5000000000720005
id calib zone = 5000000000720006
Adding view 1176/1176
buffer 1/2: filling basetrack buffers... 67%
buffer 2/2: filling basetrack buffers... 100%
...
plate 48
id calibration operation = 5000000000770001
id calib zone = 5000000000770002
Adding view 1960/1960
buffer 1/13: filling basetrack buffers... 8%
....
buffer 13/13: filling basetrack buffers... 100%
....
15:35: plate 47 started... 3h20min per 10 plates... sad.
...
plate 1
id calibration operation = 5000000001080001
id calib zone = 5000000001080002
Adding view 1960/1960
buffer 1/8: filling basetrack buffers... 14%
...
buffer 8/8: filling basetrack buffers... 100%
AddCalibrationOperation completed
Elapsed time = '''72371''' seconds
root [8]

root [10] AddHeaderOperation("Prediction SB")
AddHeaderOperation started
AddHeaderOperation completed
Elapsed time = 0 seconds
(int)25

root [11] DumpListOfHeaderOperations()
DumpListOfHeaderOperations started
Operation: 5000000000720004, start time: 04-JUL-08, notes:
Operation: 5000000001090001, start time: 05-JUL-08, notes: Prediction SB
DumpListOfHeaderOperations completed
Elapsed time = 0 seconds
(int)0
root [12] AddPredictionOperation("5000000001090001","5000000000720004")
AddPredictionOperation started
GetEntries = 57 56
EdbScanSet:
Brick 40796 with 57 plates:
57 0.00 1.000000 0.000000 0.000000 1.000000 0.000000 0.000000
...
***
Copying plate 1
***
id calibration operation associate = 5000000001080001
id prediction operation = 5000000001090115
In plate 1 you have 1 predictions
0) path number 2 saved as ID=5000000001090002
id path-prediction zone = 5000000001090116
Adding view 2/2
BT added
AddPredictionOperation completed
Elapsed time = 29 seconds
(int)26
root [13] DumpListOfHeaderOperations()
DumpListOfHeaderOperations started
Operation: 5000000000720004, start time: 04-JUL-08, notes:
Operation: 5000000001090001, start time: 05-JUL-08, notes: Prediction SB
DumpListOfHeaderOperations completed
Elapsed time = 0 seconds
(int)0
root [14]

'''20 h/brick publication to the local DB...'''

== Publishing into the central DB (OPFRA01) ==
<pre>
Credentials

Brick Analisys Follower:
BERNDIS
Zj9rrL

opita01:
bern
neutrino

opfra:
BERN
bern_brick

bern4:
opera
Appearance2

OPERAPUB
neutrino

</pre>
[[Image:DBPUB1.JPG|thumb|OperaPublicationManager]]
<pre>
Open remote desktop to lheppc35.unibe.ch
C:\Documents and Settings\scanner\Desktop\DistributionExe_NET20\ExeRepository
execute OperaPublicationManager.exe
Type in credentials (note the case!):

bern4
OPERAPUB
neutrino

The window appears: -------------------------------------------------------------------------------------------------->

Select OPFRA01 from both top windows.
Select "Publish" radiobutton on the right,
Click on "NewBrickJob"
Type in into "IDlist":
1040796
Click on "Select"
The brick appears in left top window
Select it by mouse and click ">>"
The brick appears also in right top window
Click "OK"

The job appears in "JobManagement" window with the status=TODO
Select it by mouse and click "Schedule"
Status changes to SCHEDULED, but the operation will not start untill you
select the OPFRA01 queue in right top window, click "Change Time" and click "OK" in popup window.
Now in 20 sec. operation starts.. Tha status can be seen clicking on "View Job Activity",
if aborted, the log is seen clicking at "View Related Log"..

To publish IC operation:
click on "New Operation Job"
Type in the operation ID:
5000000000720004
Then click "Select", then select by mouse in top left window and clisk ">>", then click "OK".
To start job again "Schedule" it, then "Change Time" (see above).

At the moment operation aborts with the message in the log:

Publishing TB_B_PREDTRACKS_CSCANDS with x_id = 5000000000720005 DBLINK = OPFRA01.REGRESS.RDBMS.DEV.US.ORACLE.COM
Error ORA-00942: table or view does not exist in PP_PUBLISH_OP
Elisabetta Pennacchio is working on the problem....
the public synonyms for operapub didn't exist.

in the SQL developer under user opera :

create public synonYm TB_B_PREDTRACKS_CSCANDS for OPERA.TB_B_PREDTRACKS_CSCANDS;
create public synonYm TB_CS_CANDIDATE_CHECKS for OPERA.TB_CS_CANDIDATE_CHECKS;
17:40
restarted 5000000000720004...
Going well..
finished 22:50

Same for SB operation, id=5000000001090001, 3 minutes to complete.

Done.

</pre>

== Problems ==

2 Odyssey crashes

Plate Changer failures - emulsions are VERY sticky. Solved by pre-processing emulsions (secret method, ask Igor, Jonas, Guillaume or Frederic :).

Central DB publication failed because of bugs in local DB (two synonyms were not defined). Cured, should not happen again.

Muon search rehearsal B40796 - Revision history

Lhep: 1 revision imported

Lhep: /* Publishing into the central DB (OPFRA01) */