Tips to investigate the SCT defect issue

---

LOG 19/Feb/2021: I can't access the pc-sct-mon-72. There is no directory, "/work/pc-sct-mon-41/sctdaq/tdaq-08-01-01"
05/Mar/2021: Thanks to Bruce's help, DataDisplayer works well.
19/Mar/2021: Thanks to Dave's help, MySQL works well.
26/Apr/2021: update some points.
11/Oct/2021: Add some links.

Want to check the defects! [COOL database] (not work now)

I put the script to dump the information about defects from the COOL database. The original code was made by Daniel James Lewis. Thank you very much.

"/afs/cern.ch/user/n/nyamaguc/work/public/getDefectsPerModule.py"

and following tool is also useful. https://twiki.cern.ch/twiki/bin/view/Sandbox/TestTopic11111272

Want to check the raw results of calibration such as S-curve plots [DataDisplayer]

!!Attention!! You need permission to access the pc-sct-mon-71

1st step: Get the analyzing data

Calibration data is located at "/eos/atlas/atlascerngroupdisk/det-sct/calibration/[year]/[month]/[run number]/" . Copy the file (ex. "SCTCalibration_Run353390_Scan1_Crate0.tar") to your directory. The file name is constructed from run number, scan number and crate number. Run number is calibration run number which can be checked at "".

Scan number is calibration scan number which can be checked at "".

Crate number is hoge hoge which can be checked at "".

The copied file should be converted from "tar" to "gz" file as follows.

tar -xvf filename.tar

After converting, a folder will be created (ex. run353390). For the next step, copy the file path+ (ex. /work/wrokingDir/run353390/scan1) and check the fileName. If you check the contents in the folder, you can find many files (ex. SctData::RawScanResult.353390.1.20220380200319.gz). Remember the file name included the module S/N which you want to check. Usually I use the "SctData::RawScanResult.******"

2nd step: Run the "DataDisplayer"

ssh pc-sct-mon-41
#I use Bruce's setup files. Thank you very much.
source /work/pc-sct-mon-71/sctdaq/tdaq-09-02-01/setups/setup_bruce.sh
#you should set the file pass which you would like to check.
DirPath =< gz file pass >
#i.e; DirPath =/work/wrokingDir/run353390/scan1

##start the DataDisplayer (normal)
#you should fill the file name in the <>
DataDisplayer -try IOManagerArchiveFile:$DirPath:$DirPath <fileName>
#i.e.;DataDisplayer -try IOManagerArchiveFile:$DirPath:$DirPath SctData::RawScanResult.353390.1.20220380200319.gz

##start the DataDisplayer (in case of checking the strip by strip)
DataDisplayer -chan <Beginning of strip number> <End of strip number> -try IOManagerArchiveFile:$DirPath:$DirPath <fileName>
#i.e.; DataDisplayer -chan 0 10 -try IOManagerArchiveFile:$DirPath:$DirPath SctData::RawScanResult.353390.1.20220380200319.gz

# control+C (when you want to finish)

You can get following histograms.

Want to check the calibration results [calibration database, mySQL]

The detail is described following the link in case of using a script. If you want to use the script, you should fix some points. https://indico.cern.ch/event/830978/contributions/3480611/attachments/1868948/3076385/ny190626_CalibSemi_v2.pdf

When you don't use the script, you can check the parameters with the following commands.

mysql -h dbod-sct-test.cern.ch --port=5504  -u sctroddq -p
#(password is )

#at first, you should select a database with following command.
mysql&gt; use <database name>;
#if you want to check the name of database, you should hit following command
#mysql&gt; show databases;

#if you want to check the name of table, you should hit following command
#mysql&gt; show tables;

#if you want to check the name of column, you should hit following command

#mysql&gt; show columns in

;  mysql&gt;select TESTS.test_no,test_date,test_name,defect_name,chan_1st,locn_name,initls from DEFECTS,TESTS where DEFECTS.TEST_NO=TESTS.TEST_NO and SER_NO=20220130000521;<br />

Example

following commands displays runNumber, scanNumber, s/n, defectName, stripNumber(first), stripNumber(last). If you would like to check all runs, delete "sum.run=367623". If you would like to check a particular module, add "sum.module=<s/n>"

mysql -h dbod-sct-test.cern.ch --port=5504  -u sctroddq -p
use calibration2018;
select sum.run, sum.scan, sum.module, def.name,def.firststrip, def.laststrip from nptgain_summary as sum, nptgain_defects as def where def.summaryid=sum.id and sum.run=367623;

a part of screenshot in the case of processing the commands.

You can dump the data using following script. Before you use this script, you should fill the password in the script to connect the database. /afs/cern.ch/user/n/nyamaguc/work/public/dumpScriptCalibDB_DoD.pl

Tips

summarize the tips related to mySQL command.

limit: you can set the number of printed line. e.g.

select run from nptgain_summary limit 10;

Want to check the detector parameters [geometryDump]

ssh atlasgw <br />#connect to pc-atlas-cr-sct  source /det/sct/tdaq-07-01-00/setup.SCTCalibration01.sh export CORAL_AUTH_PATH=/det/sct/confDB/coral export CORAL_DBLOOKUP_PATH=/det/sct/confDB/coral ALIAS=sctOnlCool SCHEMA=CONDBR2 export SCT_CONF_COOL_DONT_WRITE=1  
#geometryDump -b Cool -f -f $ALIAS/$SCHEMA -s <serial number> <parameters you want to dump such as sn(serial number), trims (trim value of each strip)> geometryDump -b Cool -f $ALIAS/$SCHEMA -s 20220240100387 sn trims

You can check the following parameters. Available parameters: Want to check the hit efficiency with setting the ignore defect!

command	meanings	command	meanings	command	meanings
sn	module serial number	barrel	barrel number (barrel)	row	row on barrel (barrel)
disk	disk number (endcap)	quadrant	quadrant on disk (endcap)	number	number on (barrel) row or (endcap) quadrant
mur	minimal unit of readout number	murpos	position within MUR	offline	an offline identifier
splitoffline	offline params	cablemapping	nearly the rod-robid and cable mapping format	pscrate	power supply crate number
pschannel	power supply channel number	dummy	prints and underscore "_"	partition	DAQ partion
crate	DAQ crate in partition	rod	ROD in DAQ crate	slot	ROD slot in DAQ crate
channel	ROD channel	redundant	DAQ channel for redundant tx	fibre	ROD fibre mappings (rx is base 12)
fibreoffset	Offset of fibres within MUR	links	link numbers (base 0x10)	errormask	error mask (per link)
coarse	Coarse delay on BOC channel	fine	Fine delay on BOC channel	group	DAQ group
groupConf	DAQ group from Config (for debugging only)	select	Select line	calfac	Calibration correction factor (1 per chip)
threshold	Chip threshold setting (1 per chip)	ttarget	Trim target (1 per chip)	calcthresh	Threshold for 1fC calculated from RC (1 per chip)
threshinfc	Chip threshold setting converted to fC using RC (1 per chip)	throff	Offset between threshold and trim target (1 per chip)	compression	Compression mode (1 per chip)
edgedetect	Edge detect (1 per chip)	trimrange	Trim range (1 per chip)	preamp	Preamp bias DAC counts (1 per chip)
shaper	Shaper current DAC counts (1 per chip)	chipConfig	Chip configuration register (1 per chip)	trims	Trims in hex (128 hex digits per chip)
rodid	RODid of ROD	robid	ROBid connected to	hexrodid	RODid of ROD in hex
hexrobid	ROBid connected to in hex	bypass	Report bypass chains for module	modified	What kind of bypass does this have
masked	Count of masked channels on chip

Useful Links

- Information about run https://atlas.web.cern.ch/Atlas/GROUPS/DATAPREPARATION/DataSummary/2018/run.py?run=355995

- Twiki (details of SCT tools) https://twiki.cern.ch/twiki/bin/view/Atlas/SCTOfflineMonitoringExperts

NaokiYamaguchi - 2021-10-20