Muon search rehearsal B40796

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)

Credentials

Brick Analisys Follower:
BERNDIS
Zj9rrL

opita01:
bern
neutrino

opfra:
BERN
bern_brick


bern4:
opera
Appearance2


OPERAPUB
neutrino

File:DBPUB1.JPG

OperaPublicationManager

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.

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

Contents

Event info

Predictions

Scan Log

DB Publication

Publishing into the central DB (OPFRA01)

Problems

Navigation menu

Muon search rehearsal B40796

Event info

Predictions

Scan Log

DB Publication

Publishing into the central DB (OPFRA01)

Problems

Navigation menu

Search