View source for 1072289

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

[[Image:Event23180166.gif|thumb|Detector view]]
[[Image:Event23180166 gen.gif|thumb|Detector view]]

===General Informations===

 - Brick: 1072289
 - Type: CC with 2 confirmed predictions

 - Person: 
 - Mic:
 - light level: value
 - cutoff 0: value
 - cutoff 1: value
 
 - [http://141.108.7.20/opitaweb/secure/EventProcess.aspx?evID=82000000000080277 Analysis Follower of the OPERA Experiment]
 - [[Image:Disp 23180166.pdf | Event Display PDF]]
 - [http://lheppc46.unibe.ch/EventPictures/Event23180166_vertex.gif Event Viewer]

=== Predictions ===
[[Still obtained in non-automatic way: here]]


===Loogbook===
Start: on 22/07/08 at 10 o clock. (Ariga, Ciro, Igor, Tomoko & Frank)

* Took extracted CS predictions from the predictions on the wiki pagen , not directly from DB. 

* Started calibration & search prediction for plates 57 to plate 36, started with 3 tracks, manual check succesfull with the 1st one (muon).

* Stopped at plate 48, continued with second calibration, but was ok, seems to be the real stopping point at plate 48.

* Made some important modifications in scan.C which we were in contact with Luca. Frank will write also to Luca and notificate him of some update in the ScanningTutorial to be made.

* Started then totalscanscript (after modification in thresholds in sysal)  

Comments:

* Alignment: about 14 in the alignment peak.
* Grains: in avreage 24 Grains / BT


=== Some PLots ===

* Plots from TotalScan Volume (5x5mm2): 
[[Image:Csurf.jpg]]


== DB Publication ==
<pre>
Substituted spaces by underscores in [http://lheppc46.unibe.ch/MICROSCOPE1/ONLINE/b072289/b072289.map.XG b072289.map.XG].

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

Started @15:00
 root [0] .L b072289.h                       
 root [1] .L b072289.0.1.100.operation.h     
 root [2] .L LibScanToOracle7.C              
 root [3] #define MIC_NAME MIC1              
 root [4] #define USER KRESLO                
 root [5] Add()                                      
 root [6] AddHeaderOperation("Intercalibration")
 root [7] DumpListOfHeaderOperations()          
 DumpListOfHeaderOperations started
 Operation: 5000000001100008, start time: 24-JUL-08, notes: 
 Operation: 5000000001110004, start time: 24-JUL-08, notes: Intercalibration
 DumpListOfHeaderOperations completed
 Elapsed time = 0 seconds
 (int)0
 root [8] AddCalibrationOperation("5000000001110004")
 ...
 AddCalibrationOperation completed
 Elapsed time = 3953 seconds
 (int)28

root [13] AddHeaderOperation("Scanback")             
AddHeaderOperation started
AddHeaderOperation completed
Elapsed time = 1 seconds
(int)25
root [14] DumpListOfHeaderOperations()  
DumpListOfHeaderOperations started
Operation: 5000000001100008, start time: 24-JUL-08, notes: 
Operation: 5000000001110004, start time: 24-JUL-08, notes: Intercalibration
Operation: 5000000001130001, start time: 24-JUL-08, notes: Scanback
DumpListOfHeaderOperations completed
Elapsed time = 0 seconds
(int)0


root [15] AddPredictionOperation("5000000001130001","5000000001110004");
AddPredictionOperation started
GetEntries = 13 12
EdbScanSet:
Brick 72289 with 13 plates:
 57          0.00        1.000000  0.000000  0.000000  1.000000        0.000000        0.000000
 56      -1285.50        1.000000  0.000534 -0.000534  1.000000      -37.878155       17.525036
 55      -2553.50        1.000000 -0.000020  0.000020  1.000000     -106.927460      -29.037109
 54      -3831.94        0.999999 -0.000448  0.000448  0.999999      146.480820      -95.745857
 53      -5131.94        0.999999 -0.000174  0.000174  0.999999      195.890625      -72.170227
 52      -6416.17        1.000000 -0.000934  0.000934  1.000000      260.525024     -200.365875
 51      -7692.82        0.999999 -0.002005  0.002005  0.999999      415.427887     -314.546295
 50      -8961.33        1.000000 -0.001309  0.001309  1.000000      224.509995     -220.809540
 49     -10239.93        1.000000 -0.000891  0.000891  1.000000      173.558960     -184.694183
 48     -11504.97        1.000000 -0.000213  0.000213  1.000000      321.967590     -140.934967
 47     -12804.97        1.000000 -0.000842  0.000842  1.000000      219.261688     -216.249115
 46     -14090.57        0.999999  0.000728 -0.000728  0.999999      174.020233     -116.045219
 45     -15350.22        0.999999 -0.000445  0.000445  0.999999      288.870178     -106.019646
for this brick 13 identifiers are defined:
72289 57 1 100
72289 56 1 100
72289 55 1 100
72289 54 1 100
72289 53 1 100
72289 52 1 100
72289 51 1 100
72289 50 1 100
72289 49 1 100
72289 48 1 100
72289 47 1 100
72289 46 1 100
72289 45 1 100
***
Copying plate 57
***
...
Copying plate 45
***
id calibration operation associate = 5000000001120023
id prediction operation = 5000000001130039
In plate 45 you have 0 predictions
AddPredictionOperation completed
Elapsed time = 23 seconds


AddVolumeOperation started
s->ID() 1 1 49
ReadPiecePar    : ERROR open file: /terabig/scan/MICROSCOPE1/ONLINE/b072289/AFF/72289.56.1.1000_72289.55.1.1000.aff.par
Please run "Alignment" procedure first

GetEntries = 12 0
EdbScanSet:
Brick 72289 with 0 plates:
for this brick 12 identifiers are defined:
72289 56 1 1000
72289 55 1 1000
72289 54 1 1000
72289 53 1 1000
72289 52 1 1000
72289 51 1 1000
72289 50 1 1000
72289 49 1 1000
72289 48 1 1000
72289 47 1 1000
72289 46 1 1000
72289 45 1 1000
id volume = 5000000001130041
Error: Can't call TOracleServerE2W::AddProcessOperation(MIC_NAME,LIBSCAN_VOLUME,USER,id_header_operation,id_eventbrick,id_
plate,"1","NULL",date,date,"'Y'","Volume area") in current scope /terabig/fedra/macros/LibScanToOracle7.C:1068:
Possible candidates are...
(in TOracleServerE2W)
/terabig/fedra/lib/libEOracle.so  -1:-1   0 public: Int_t TOracleServerE2W::AddProcessOperation(char* id_machine,char* id_
programsettings,char* id_requester,char* id_parent_operation,char* id_eventbrick,char* id_plate,char* driverlevel,char* id
_calibration,char* starttime,char* finishtime,char* success,char* notes);
(in TOracleServerE2)
(in TOracleServer)
(in TSQLServer)
*** Interpreter error recovered ***
root [24] .q

Copy AFF's by hands..... to include into scan.C! <---------------------------------------------------------------------------------TODO

scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.56.1.10
72289.56.1.100_72289.55.1.100.aff.par  72289.56.1.10_72289.55.1.10.aff.par    
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.56.1.10_72289.55.1.10.aff.par AFF/72289.56.1.1000_72289.55.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.55.1.10_72289.54.1.10.aff.par AFF/72289.55.1.1000_72289.54.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.54.1.10_72289.53.1.10.aff.par AFF/72289.54.1.1000_72289.53.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.53.1.10_72289.52.1.10.aff.par AFF/72289.53.1.1000_72289.52.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.52.1.10_72289.51.1.10.aff.par AFF/72289.52.1.1000_72289.51.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.51.1.10_72289.50.1.10.aff.par AFF/72289.51.1.1000_72289.50.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.50.1.10_72289.49.1.10.aff.par AFF/72289.50.1.1000_72289.49.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.49.1.10_72289.48.1.10.aff.par AFF/72289.49.1.1000_72289.48.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.48.1.10_72289.47.1.10.aff.par AFF/72289.48.1.1000_72289.47.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.47.1.10_72289.46.1.10.aff.par AFF/72289.47.1.1000_72289.46.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.46.1.10_72289.45.1.10.aff.par AFF/72289.46.1.1000_72289.45.1.1000.aff.par 
scanner@lheppc46:/terabig/scan/MICROSCOPE1/ONLINE/b072289> cp AFF/72289.45.1.10_72289.44.1.10.aff.par AFF/72289.45.1.1000_72289.44.1.1000.aff.par 

</pre>

<pre>
@16:30

Initialized...
root [12] DeleteOperation("5000000001130040")  // To clean old remainders
DeleteOperation started
DeleteOperation completed
Elapsed time = 1 seconds
(int)25
root [13] AddHeaderOperation(
int AddHeaderOperation(const char* notes = "")
root [13] AddHeaderOperation("Totalscan1000")
AddHeaderOperation started
AddHeaderOperation completed
Elapsed time = 0 seconds
(int)25
root [14] DumpListOfHeaderOperations()       
DumpListOfHeaderOperations started
Operation: 5000000001100008, start time: 24-JUL-08, notes: 
Operation: 5000000001110004, start time: 24-JUL-08, notes: Intercalibration
Operation: 5000000001130001, start time: 24-JUL-08, notes: Scanback
Operation: 5000000001130042, start time: 24-JUL-08, notes: Totalscan1000
DumpListOfHeaderOperations completed
Elapsed time = 0 seconds
(int)0
root [15] AddVolumeOperation("5000000001130042","5000000001130001",1,1)
AddVolumeOperation started
s->ID() 1 1 49
GetEntries = 12 11
EdbScanSet:
Brick 72289 with 12 plates:
 56          0.00        1.000000  0.000000  0.000000  1.000000        0.000000        0.000000
 55      -1268.00        1.000000 -0.000554  0.000554  1.000000      -69.024437      -46.599014
 54      -2546.44        0.999999 -0.000982  0.000982  0.999999      184.419464     -113.172440
 53      -3846.44        0.999999 -0.000708  0.000708  0.999999      233.816666      -89.570427
 52      -5130.67        0.999999 -0.001468  0.001468  0.999999      298.519531     -217.731567
 51      -6407.32        0.999998 -0.002539  0.002539  0.999998      453.483368     -331.829254
 50      -7675.83        0.999999 -0.001843  0.001843  0.999999      262.515442     -238.194458
 49      -8954.43        1.000000 -0.001425  0.001425  1.000000      211.545120     -202.106308
 48     -10219.47        1.000000 -0.000747  0.000747  1.000000      359.930389     -158.267838
 47     -11519.47        0.999999 -0.001376  0.001376  0.999999      257.264679     -233.636841
 46     -12805.07        1.000000  0.000194 -0.000194  1.000000      211.969711     -133.457092
 45     -14064.72        0.999999 -0.000979  0.000979  0.999999      326.814301     -123.370193
for this brick 12 identifiers are defined:
72289 56 1 1000
72289 55 1 1000
72289 54 1 1000
72289 53 1 1000
72289 52 1 1000
72289 51 1 1000
72289 50 1 1000
72289 49 1 1000
72289 48 1 1000
72289 47 1 1000
72289 46 1 1000
72289 45 1 1000
id volume = 5000000001130043
***
Copying plate 56
***
id volume operation = 5000000001130044
id volume zone = 5000000001130045

...some time passed

***
Copying plate 45
***
id volume operation = 5000000001160005
id volume zone = 5000000001160006
Adding view 600/600
buffer 1/4: filling basetrack buffers... 33%
buffer 2/4: filling basetrack buffers... 66%
buffer 3/4: filling basetrack buffers... 100%
buffer 4/4: filling basetrack buffers... 100%
AddVolumeOperation completed
Elapsed time = 3522 seconds
(int)28

</pre>

Similar for Totalscan - 1100 (1x1cm):
 AddVolumeOperation("5000000001170001","5000000001130001",1,2) 
 ...
 AddVolumeOperation completed
 Elapsed time = 14771 seconds
 (int)29


=== Central DB communications===


* Download predictions and create link to SB path as described [[How to copy predictions from OPITA01 to local DB | here]] :

** In lheppc35 by SQL Developer connect to bern4 as OPERAPUB,
<pre>

execute in SQLDeveloper the following command:
call pp_download_predictions(3072289,'OPITA01');          
commit;
(press F5)
Result:

call pp_download_predictions(3072289,'OPITA01') succeeded.
commit succeeded.
</pre>

** Check it:
<pre>
select * from tb_cs_candidates;

 Result:
ID_EVENTBRICK          ID_PROCESSOPERATION    ID_EVENT               CANDIDATE              ID                     
---------------------- ---------------------- ---------------------- ---------------------- ---------------------- 
3072289                9000000000723563       82000000000080277      1                      9000000000724825       
3072289                9000000000723563       82000000000080277      2                      9000000000724826       

2 rows selected
</pre>


** Link CS candidate to SB operation:

<pre>

INSERT INTO "OPERA"."TB_B_CSCANDS_SBPATHS" (ID_CS_EVENTBRICK, ID_CANDIDATE, ID_EVENTBRICK, ID_SCANBACK_PROCOPID, PATH) VALUES ('3072289', '9000000000724825', '1072289', '5000000001130001', '1');
Commit;

Here 3072289 - CS eventbrick (starts with 3!), 
9000000000724825 - ID of CS candidate (see above)
1072289 - ID eventbrick (starts from 1)
5000000001130001 - id of scanback operation (get when execute AddHeaderOperation during publication procedure)
1 - ID of SB path (set in .operation.h file)

</pre>

** Publication to central DB (OPFRA01)

In lheppc35 open C:\Documents and Settings\scanner\Desktop\DistributionExe_NET20\ExeRepository\OperaPublicationManager.exe

 Brick geometry published with no problems
 IC - no problem.
 Durind SB publishing observed Oracle errror. After investigation with the help of Cristiano,
 some bug in OPFRA01 was fixed. Restarted SB publishing - done.
 TS zone 1000 publishing - finished.
 TS zone 1100 publishing - complete.

 Brick publishing complete!