The ErrorHandler general table contains all the details about all the errors stored in the database (Router number, run number...).
Foreign Keys (Error_class, Error_number) references ErrorhandlerClass (Error_class, Error_number)
To complete the report about the errors I created a virtual table containing the fields of the two tables. This way, in future, it will be possible to add other kind of errors without changing the main structure of the tables
The new PVSS panel raises queries to the database and displays the errors when it is needed, is ready.
-- ClaudioBortolin - 18 Mar 2009
ErrorHandlerTable
ErrorHandler fields |
|
|---|---|
Router_Number |
number (2) |
Run_Number |
number (10) |
Bunch_Crossing |
number (4) |
Error_Class |
number (7) |
Error_Number |
number (7) |
Order_Number |
number (4) |
Details1 |
number (10) |
Details2 |
number (10) |
Created |
date |
ErrorHandlerClass table
This table defines the correspondence between the error class and the error class name. It contains any possible error. ErrorHandlerClass fields |
|
|---|---|
Error_Class |
number (7) |
Error_Class_Name |
Varchar (100) |
Error_Number |
number (7) |
Error_Name |
Varchar (100) |
| keys | |
primary key (Error_Class, Error_Number) validate |
|
ERRORSVIEW fields and Reference table |
|
|---|---|
ROUTER_NUMBER |
ERRORHANDLERTABLE |
RUN_NUMBER |
ERRORHANDLERTABLE |
BUNCH_CROSSING |
ERRORHANDLERTABLE |
ERROR_CLASS |
ERRORHANDLERTABLE |
ERROR_CLASS_NAME |
ERRORHANDLERCLASS |
ERROR_NUMBER |
ERRORHANDLERTABLE |
ERROR_NAME |
ERRORHANDLERCLASS |
ORDER_NUMBER |
ERRORHANDLERTABLE |
DETAILS_1 |
ERRORHANDLERTABLE |
DETAILS_2 |
ERRORHANDLERTABLE |
CREATED |
ERRORHANDLERTABLE |
Topic revision: r3 - 2009-04-17 - ClaudioBortolin
- AliceSPD Web
- SPD Home
- ArticlesPublications
- Cooling System
- SpdDcsSoftware
- SpdElectronics
- SpdProduction
- SpdMeetings
- ThePeople
- PictureGalery
- Sector Tests
- DcsForum
Log books
Browse
- ABATBEA
- ACPP
- ADCgroup
- AEGIS
- AfricaMap
- AgileInfrastructure
- ALICE
- AliceEbyE
- AliceSPD
- AliceSSD
- AliceTOF
- AliFemto
- ALPHA
- Altair
- ArdaGrid
- ASACUSA
- AthenaFCalTBAna
- Atlas
- AtlasLBNL
- AXIALPET
- CAE
- CALICE
- CDS
- CENF
- CERNSearch
- CLIC
- Cloud
- CloudServices
- CMS
- Controls
- CTA
- CvmFS
- DB
- DefaultWeb
- DESgroup
- DPHEP
- DM-LHC
- DSSGroup
- EGEE
- EgeePtf
- ELFms
- EMI
- ETICS
- FIOgroup
- FlukaTeam
- Frontier
- Gaudi
- GeneratorServices
- GuidesInfo
- HardwareLabs
- HCC
- HEPIX
- ILCBDSColl
- ILCTPC
- IMWG
- Inspire
- IPv6
- IT
- ItCommTeam
- ITCoord
- ITdeptTechForum
- ITDRP
- ITGT
- ITSDC
- LAr
- LCG
- LCGAAWorkbook
- Leade
- LHCAccess
- LHCAtHome
- LHCb
- LHCgas
- LHCONE
- LHCOPN
- LinuxSupport
- Main
- Medipix
- Messaging
- MPGD
- NA49
- NA61
- NA62
- NTOF
- Openlab
- PDBService
- Persistency
- PESgroup
- Plugins
- PSAccess
- PSBUpgrade
- R2Eproject
- RCTF
- RD42
- RFCond12
- RFLowLevel
- ROXIE
- Sandbox
- SocialActivities
- SPI
- SRMDev
- SSM
- Student
- SuperComputing
- Support
- SwfCatalogue
- TMVA
- TOTEM
- TWiki
- UNOSAT
- Virtualization
- VOBox
- WITCH
- XTCA
 |
|
Copyright &© 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors. or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback