This page contains documentation on investigating the problem with channel 1181 in the COOL database.

SQL query on PVSS offline DB

SELECT /*+ cardinality (elem 1)*/
elem.element_name
FROM atlas_pvsspix.EVENTHISTORY_00000016 hist ,
atlas_pvsspix.ELEMENTS elem
WHERE elem.element_id=hist.element_id
AND element_name LIKE '' 
AND hist.ts BETWEEN to_date('11-12-2009 20:00:00', 'DD-MM-YYYY
HH24:MI:SS')
AND to_date('11-12-2009 23:59:59', 'DD-MM-YYYY HH24:MI:SS');

Results in 7 entries: ATLPIXLCS6:Y2813S2_HV03_1A.Ch00.VMeas

AtlCoolCopy on offline COOL DB

AtlCoolCopy.exe "COOLOFL_DCS/COMP200" pixdcs.root -root -folder /PIXEL/DCS -ts 1260558000-tu 1260572399

CoralDB Standard Connectivity Tables

URL: http://atlsr1.cern.ch/web-db/replica/coraldbstdtables.cgi

Query:

• Database connection = dbi:Oracle:ATLAS_COOLPROD, user = ATLAS_COOL_READER

• ID tag PIXEL (restart with a different ID tag)
• Use connectivity tag PIT-ALL-V39
• Use data tag PIT-ALL-V39
• Use aliases tag PIT-ALL-V39
• Use table PP0-DEFAULT

Results

COOL is written much less frequently than PVSS. Can check from AtlCoolCopy ntuple for TEMPERATURE/HV/FSMSTATE/FSMSTATUS tree:

• ChannelID
• temperature / HV / FSM_state / FSM_status
• IOVSince
• IOVUntil

Considering in the following measurements from 11/12/2009 20:00:00-23:59:59 or the last entry before this time.

Checking Channel 1180/1181

Found that channel 1180 corresponds to Y3423X8_BBIM11D.Ibox3.Tempa (see above). Channel 1181 (which would be Y3423X8_BBIM11D.Ibox3.Temp9) has no temperature entries (as expected). Time shifts of one hour are due to different time settings.

Data are written to COOL directly after PVSS DB update only if significant change of temperature (about 2 degree Celsius). PVSS update every hour independent of temp change (more often if DeltaT > approx. 0.3).

Similar for other entries:

ATLPIXLCS6:Y0914A2_HV08_1A.Ch01.VMeas is linked to COOL ID 1178-1183 --> correct.

ATLPIXLCS3:L2_B11|L2_B11_S1_A6_M4A.fsm.currentState is linked to COOL ID 1181 --> correct. LOCKED_OUT

ATLPIXLCS3:L2_B11|L2_B11_S1_A6_M3A.fsm.currentState is linked to COOL ID 1180 --> correct. OK

ATLPIXLCS3:L2_B11|STATUS_L2_B11_S1_A6_M4A.fsm.currentState corresponds to COOL ID 1181 --> correct. OK

ATLPIXLCS3:L2_B11|STATUS_L2_B11_S1_A6_M3A.fsm.currentState corresponds to COOL ID 1180 --> correct. OK

FSM state and status only updated when changed.

Checking channel 1200

Channel 1200 IS linked to ATLPIXLCS12:Y3423X8_BBIM11D.Ibox1.Temp3!

Correct values found for 1199 (Temp4) and 1201 (Temp2).

ATLPIXLCS6:Y0914A2_HV08_3B.Ch00.VMeas is linked to COOL IDs 1197-1202 --> correct.

ATLPIXLCS3:L2_B12|L2_B12_S1_C7_M3C.fsm.currentState is linked to COOL ID 1200 --> correct.

ATLPIXLCS3:L2_B12|STATUS_L2_B12_S1_C7_M3C.fsm.currentState corresponds to COOL ID 1181 --> correct.

CategoryDCSProject