Database at MACs
A joint DB and MACs meeting
Minutes MACs & DB 30/10
Goals of the meeting
Review central DB status with respect to preparation for CMSR aka (pre)production
Update on Postgres
Update from each MAC on DB progress:
1.What can we do to help?
2. Are there any show-stoppers for using the Postgres system at your MAC?
Ludivine’s talk
Proposal of having SERIAL_NUMBER to BARCODE for several parts -> check if all ok?
Update on CMSR.
Baseplate: modify the documentation to have location 2 characters like KA(for KIT) instead of VB
Sindhu’s
Q from Ludivine:. hexaboard ROC version: why do you want to enter it in Labview if already on hexaboard label?
procedure documented in one place?
Problem with latest LabView and the Gantry code from NTU: might break
Reasonable solution: if some part of an already prepared package does not work for a MAC, they should create their own link between local machine and Postgres
CMU requests more shipping contacts in shipment tracking tool -> being followed-up with new CMU address
CMU notes Pascal does not work well with Postgres -> issue on Gitlab?
Alethea’s
UCSB: list of pre-series that made it to INT2R to the DB group
Alethea: email IHEP and ask them to give update/fill out slides all other MACs filled out
Alethea: follow up with Prashant at TIFR who was present but had not filled out slides
UCSB needs to finish setting up Postgres
NTU: Rong-Shyang
xml rejected with
my question: uploaded with IHEP but he can only see his location on STT
TTU: Yongbin
Restarting efforts with database. Recommend set up Postgres system.
TIFR: Prashant
Has not tried Postgres → will set up.
Additional Notes:
We should have shared the conclusions of the last Sensor Meeting Alethea and I attended (minutes are attached to the indico): https://indico.cern.ch/event/1456852/
The list of bad channels in the QC tables from the sensors IS NOT a list of channels to be grounded (= not to be wired to ASICS).
Candidates of cells to be grounded could be the ones with crystal damage.
Test either and see which modules behave better.
This was actually mentioned in the last MAC meeting.
That was an exercise thought for pre-series. Any follow-up on this?
It will have to be an exercise for pre-production because the pre-series is over.
See issue https://gitlab.cern.ch/hgcal-database/interfaces/-/issues/1 for followup on the QC tables name from the sensors.
Other tidbits learned:
Labels produced by HGCAL will be datamatrix
Reminder to create a GitLab issue ANY TIME an xml is rejected
MACs have a mattermost channel for MAC related DB questions/discussion