View source for 1088929

Back to [[Bern Bricks]] or [[OPERA]]

===General Informations===

 - Brick: brick number
 - Type: Muon

 - Person: Igor,Ciro
 - Mic: 2
 - light level: value
 - cutoff 0: value
 - cutoff 1: value
 

 - [http://lheppc46.unibe.ch/EventPictures/Event222169577_vertex.gif Event Viewer]
 - [http://141.108.7.20/opitaweb/secure/EventProcess.aspx?evID=82000000000081130 Analysis Follower of the OPERA Experiment]

===Loogbook===
Start: 2008-08-22, 
<pre>
Trying to copy predictions from OPITA01 by "Lasy shifters script".
Error:
SQL Error: ORA-02291: integrity constraint (OPERA.FK_PROGSETS_PROCOPS)
violated - parent key not found
It seems, the SYSTEM is not copied from OPITA01 to local DB (must be done before copying new brick or CSD)

Trying by hands... 

</pre>
[[Problem solving log is here]]
Finally 

call pp_download_predictions(88929,'OPITA01'); 
worked well.

Continuing.
<pre>
[scanner@lheppc56 ONLINE]$ root -l
vt++ version /1-35 loaded (Fri Jan 18 14:33:54 2002).
libEmath        loaded...
libEOracle      loaded (Unux)
root [0] .L LibScanToOracle.h
root [1] .L b088929.h
root [2] .L b088929.0.1.100.operation.h
root [3] .L LibScanToOracle7.C
root [4] .L utils.C
root [5] create_brick()
Creating brick directory and its subdirectories...
Creating brick geometry...
file:
/terabig/scan/MICROSCOPE2/ONLINE/b088929/b088929.geometry
created
Get CS X marks from DB...
Connection Opened
Server info: Oracle
Connection Closed
Get CS predictions from DB...
Connection Opened
Server info: Oracle
Connection Closed
Copying the header files...
Everything succesfully done!
root [6] .q
</pre>

Changed in machine defaults for MIC2 the ZReference from 220 to 283.
XYReference from 137625, 47210 to -133261, 47888
<pre>

Measure corners

-1304, 166,
124197, 99066,

Measure optical marks:
1 8699, 10098,
2 8867, 90285,
3 114103, 90139,



root [4] .L utils.C
root [5] create_mapfile(-1304, 166,124197, 99066,8699, 10098,8867, 90285,114103, 90139,'S')
root [6]  


</pre>

<pre>

Manual chacks gave no evident results...
Starting scanback pl 57 only

Prediction cand BT is found, but not confirmed manually (a lot of grains around)
When trying to scan IC area systematic Odyssey crash happens.
Working on this....
No solution found,
moving to MIC1.

MIC1: ZGlassReference from 140 to 174
      XYReference from -126918, 35072 to -123320, 35561


Marks on pl57 found OK
Same cand is found as on MIC2

#### Found a BT!!!!!!!!!!!!!!!!!
ID = (88929.57.1.100). You searched for 1 paths
Path    5: Prediction: 708.619995 31374.599609 0.084400 0.094000
  Status 0: BT found
  BT :      662.0    31395.4     0.0931     0.0854    19     0.4179 0.000000
  Res:      -46.6       20.8     0.0087    -0.0086
  MT1:      672.0    31404.6     0.0304    -0.0054    11     2.4329 0.000000
  Res:      -36.7       30.0    -0.0540    -0.0994
  MT2:      652.0    31386.3     0.0308     0.0165     8     1.9962 0.000000
  Res:      -56.6       11.7    -0.0536    -0.0775


Pl56 IC OK, prediction missed
Pl55..missed
Pl54 out of the plate!
Tracks lives the brick volume by side.

</pre>


== DB local ==
 root [12] DumpListOfHeaderOperations()                                    
 DumpListOfHeaderOperations started
 Operation: 5000000003120004, start time: 08-SEP-08, notes: IC57-53
 Operation: 5000000003120010, start time: 08-SEP-08, notes: SB
 DumpListOfHeaderOperations completed

 SQL> select * from tb_cs_candidates where id_eventbrick=3088929;

       ID_EVENTBRICK  ID_PROCESSOPERATION             ID_EVENT            CANDIDATE                   ID
 -------------------- -------------------- -------------------- -------------------- --------------------
             3088929     9000000044553510    82000000000081130                    5     9000000050993514


== DB central ==

 PUB_SYSTEM - OK.

 Starting publication IC...OK
 Starting SB..

 Error ORA-02291: integrity constraint (OPERA.FK_CSCANDS_CSCANDPATHS) violated - parent key not found
 ORA-02063: preceding line from OPFRA01 in PP_PUBLISH_OP


 Cristiano informed, waiting for solution...