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)

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

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

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

The new PVSS panel raises queries to the database and displays the errors when it is needed, is ready.

-- ClaudioBortolin - 18 Mar 2009

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2009-04-17 - ClaudioBortolin
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    AliceSPD All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 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