GIS PORTAL RACKS Integration of Equipment Racks in

GIS PORTAL RACKS Integration of Equipment Racks in the Geographic Information Service (GS/ SE) https: //gis. cern. ch/gisportal/Racks. htm Barriere O, Le Roux P 26. 02. 2015

GIS Portal Racks Status Summary � Context � Phase 1 data Integration � Phase 2 update � Proposals � Summary 2

GIS Portal Racks Status Summary � Context � Phase 1 data Integration � Phase 2 update � Proposals � Summary 3

Context � GIS PORTAL Racks was born following an ACCOR study � To improve cabling, cabling documentation & data sharing � => For BE/CO best effort service team. � To reduce accelerators downtime 4

Before System: Equipment Location Building 361 Room: 1 -012 Rack: BCER 677 Controls Configuration 5

Current System: Map CERN Lite MAP CERN LITE 6

Before System: GIS Portals 7

Current system: GIS Portal 8

Before system: GIS Portal Before system limitations: We didn’t know the exact location of the rack 9

Before system: Equipment Cabling Document 10

Before where to find information? Infor EAM DB EDMS DB IT Net. Ops DB Controls Configuration DB GESMAR DFS DB Databases not linked Layout DB 11

Study conclusions � We lack a global infrastructure to document our huge installations. � Each equipment group provides its own solution Locating the equipment 2. Finding the corresponding documentation 1. 12

GIS Portal Racks prototype � Integrate equipment racks in GIS Portal � Search by rack � Direct link to the technical documentation and databases � In databases, add links to GIS PORTAL RACKS 13

Context history � ACCOR study in 2011 � Prototype in 2012 � Accelerator Sector management agreement to start the project (BE, EN, TE) June 2013 � Started the project in September 2013 14

GIS Portal Racks Status Summary � Context � Phase 1 data Integration � Phase 2 update � Proposals � Summary 15

Phase 1 data integration � BPMN (Business Process Model Notification) data flow (Coralie Perollini from MFIO (Maintenance Framework Implementation Office), Pascal, Olivier) https: //edms. cern. ch/document/1308160/1 � Rack Inventory APEX interface & PL/SQL API to import/publish (Pascal) https: //apex. cern. ch/pls/htmldb_accdb/f? p=rackinventory � Racks models inventory (Keith) Racks inventory (Keith) Check on site (Keith, Olivier, )(LHC U help of Didier & Pascal C) Arc GIS drawings (Keith) Coordination with EL-EN, EN-CV, GS-ASE, GS-SE, IT-CS, TE-EPC (Olivier) Data update in CCDB (Alexander & Eve) � � � 16

Infrastructure and data flow "Demande d’installation de cables" EN/EL Cablothèque Gesmar Layout DB Layout core tables Combine with already existing layout data TE/CRG EN/CV GS/ASE … Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS DB GS/SE/DOP 17

Infrastructure and data flow "Demande d’installation de cables" APEX Interface on RACK IMPORTS EN/EL table Cablothèque Inventory of the distinctto rack models manage thewith inventory by building photos Gesmar Layout DB Layout core tables Combine with already existing layout data TE/CRG EN/CV GS/ASE … Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS DB GS/SE/DOP 18

Infrastructure and data flow "Demande d’installation de cables" EN/EL Cablothèque Gesmar Layout DB Layout core tables TE/CRG EN/CV GS/ASE … Inventory status report by. Sync building, highlighting to Layout demand missing/incorrect data inonlayout, MTF or GIS Combine with already existing layout data Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS DB GS/SE/DOP 19

Infrastructure and data flow "Demande d’installation de cables" EN/EL Cablothèque Gesmar Layout DB Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand Creation not fully automated yet GIS info Panel View GIS DB GS/SE/DOP 20

Infrastructure and data flow "Demande d’installation de cables" EN/EL Cablothèque ESRI Arc. GIS Interface to draw the rack shapes on top of the building/floor schematics Gesmar Layout DB Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS info Panel View GIS DB GS/SE/DOP 21

Infrastructure and data flow "Demande d’installation de cables" EN/EL Cablothèque Gesmar Layout DB Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS info Panel View Provide rack data to GIS DB GS/SE/DOP Match GIS Shapes with Layout data using Labels & LAYOUT_ID Automatic since April 2014 22

Results in Layout web interface Rack in the building hierarchy Link to MTF GIS integration 45 U Empty rack to be filled in Link to GIS 23

Results in MTF / INFOR. EAM Slot available for documentation 24

Process done & to be done "Demande d’installation de cables" EN/EL Cablothèque Gesmar Layout DB Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand NETWORK DB IT sockets in racks IT-CS Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS info Panel View Provide rack data to GIS DB GS/SE/DOP Match GIS Shapes with Layout data using Labels & LAYOUT_ID Automatic since April 2014 25

Results in GIS Portal Racks IT Socket list by rack done by IT First Line IT Socket Status: Free Assigned Portable …. Zoom 1: 10 26

Process done & to be done "Demande d’installation de cables" EN/EL Cablothèque Gesmar CCDB Diamon BE-CO Layout DB Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand NETWORK DB IT sockets in racks IT-CS Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS info Panel View Provide rack data to GIS DB GS/SE/DOP Match GIS Shapes with Layout data using Labels & LAYOUT_ID Automatic since April 2014 27

Results in CCDB & Diamon GIS Portal Racks links Building Room Rack 28

Process done & to be done "Demande d’installation de cables" EN/EL Cablothèque Gesmar E ON Layout DB TO CCDB Diamon BE-CO D BE Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand NETWORK DB IT sockets in racks IT-CS Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS info Panel View Provide rack data to GIS DB GS/SE/DOP Match GIS Shapes with Layout data using Labels & LAYOUT_ID Automatic since April 2014 29

Process to be done Link FEC’s to racks 30

Process done & to be done "Demande d’installation de cables" EN/EL Cablothèque TO BE TO Gesmar D O ED TO NE B E ON Layout DB Equipment groups DB E ON CCDB Diamon BE-CO D BE Layout core tables Update LAYOUT_ID or create new rack TE/CRG EN/CV GS/ASE … Combine with already existing layout data Sync to Layout on demand NETWORK DB IT sockets in racks IT-CS Infor. EAM GS/ASE RACK IMPORTS Staging table Import API running daily or on demand GIS info Panel View Provide rack data to GIS DB GS/SE/DOP Match GIS Shapes with Layout data using Labels & LAYOUT_ID Automatic since April 2014 31

Planning Necessary Resources Estimation (1 st Phase Based on Prototype) Service Number of buildings Number of racks Only BE/CO racks 301 4’ 811 All the racks in the buildings For BE, EN, TE All CERN racks for BE, EN, TE + GS, IT, PH, 301 496 16’ 888 25’ 174 Total (manpower/month) Database Work Total (manpower/month) Installations Teams 12 m. m 14 m. m (temp. Resource, PJAS) (temp. Resource, FSU) 19 m. m (temp. resource) 22 m. m (temp. resource) 32

Planning � � � Started September 2013 (but only 14 months of work done) PS Complex & LHC Underground done To finish LHC Surface -> 1 month SPS -> 3 months Finally we are on time 33

GIS Portal Racks Status Summary � Context � Phase 1 data Integration � Phase 2 update � Proposals � Summary 34

Phase 2 Update � Validate data imported � Maintain data up to date 35

Validate data: LIU PSB Pilot (LHC Injector Upgrade) Names of racks to be changed In Infor EAM, Gesmar, MTF… Check of equipment responsible done by BE-OP Machine Coordinator (K. Hanke & F. Chapuis) 36

Data Maintenance Proposal � Use BE-OP Machines coordinators to validate imported data � EN-EL is creating a DIR (Demande d’Installation de Rack) form � EN-EL is creating a DDR (Demande de Désafectation de Rack) form � Include GIS Portal Racks in the ECR (Equipment Change Request) workflow � Develop a GIS Portal application to report errors, to GIS Portal Rack support � One person for all equipment groups to make changes in GIS Portal Racks � Each equipment groups will be able to make updates � Strategy to be defined 37

GIS Portal Racks Status Summary � Context � Phase 1 data Integration � Phase 2 update � Proposals � Summary 38

Proposals to extend GIS Portal Racks � Automatically draw racks & electrical panels in LHC Tunnel � Automatically draw FIP Bus in LHC Tunnel � Display 1553 bus & Timing distribution in ‘GIS Portal Racks’ � Search and display cables in ‘GIS Portal Racks’ � Display Racks power distribution 39

Display Racks Power distribution Links between: Racks & power distribution 40

GIS Portal Racks is the first step 41

Racks Layout automatic Application for Racks Layout: Link to CCDB to import data & Draw equipment not in CCDB 42

Cabling Layout automatic Application for cabling Layout: Link to CCDB & Draw equipment not in CCDB 43

summary Context Situation before & now � � � Before it took time to locate a rack & find cabling documentation Before databases were not linked together Now, thank to GIS Portal Racks & geolocalisation Rapidly locate equipment racks Provide a standardized solution and easy access to cabling documentation & databases => To reduce accelerators downtime 1 st Phase Data integration � Data flow & Infrastructure are in place but there are still some links to be done � Collecting data: PS Complex, LHC underground & LHC surface in 15 months SPS 3 months to do it 2 nd Phase Data maintenance � Validate imported data in collaboration with BE-OP Machines Coordinators � Maintain data up to date: Discussion on going with EN/EL (DIR, DDR) Strategy to be discussed Tools & procedures to be developed Proposals: � To extend ‘GIS PORTAL Racks’ in LHC tunnel, FIP bus, 1553 bus, cables… ○ Put them in place � GIS Portal Racks is only the first step � Next steps: ○ Develop tools to display rack & cabling Layout, synchronised with DB 44

Demonstration https: //gis. cern. ch/gisportal/Racks. htm 45