Deliverable D5.2 OPTIRAIL User Manual
Contents
1. Add Track Manage Sequences Notifier Geometrical Auscultation Sequence tricis Attention The Read only geometrical sequence should be used P whenever a certain track has less than four geometrical auscultations submited This is so because exponential No homogeneous segmentation regressions can only be done efficiently with four or more points Read file only Otherwise when Complete geometrical sequence option is selected it s recommended to select Read file only curvature sequence When No homogeneous segmentation geometrical Curvature Sequence sequence is selected Read file and homogeneous segmentation curvature sequence should be selected Read file and homogeneous segmentation Read file only Reset Changes Default Configuration saved FIGURE 16 OPTIRAIL MAINTENANCE TOOLKIT MANAGE SEQUENCES This allows the user to setup which sequences will run when a new curvature geometrical file is added to OptiRail It should be setup taking into account how much information there is in the database for the new file s track For instance if there is no infrastructure data previously submitted for this track then there is no point in doing homogeneous segmentation because it will just end up in an error Another possible error is if there are less than four geometrical auscultation files submitted to the database for that track an error would occur while determining the subseries because exponential regression2. OPTIRAIL SERVER ROOT config folder On the client side there is only optirail cfg in the OPTIRAIL CLIENT ROOT config folder 3 3 1 MULTI MACHINE SETUP All those files are configured by default to work with OptiRail server and client together in the same machine To configure OptiRail to work in different machines then follow the steps e Server side configuration In optirail cfg file 1 Write the server machine IP in the server address and remote host tag values 2 Adapt users cfg file and keystore file file paths to your current setup tn ik WW a EB server address 127 0 0 1 server address IUtpserver lt remote host gt 127 0 0 1 lt remote_host gt lt users cfg file gt D OptiRail Workspace Dey OptiRailWorkspace 100 Insta lt keystore file gt D OptiRail Workspace Dey OptiRailWorkspace 100 Instal lt keystore password gt password lt keystore password gt lt ftpserver gt 3 Open the ports 21 22 990 1090 1109 and 5432 on the firewall and eventually in the anti virus If the default ports present in this file are changed they should be opened in the firewall In users properties files 1 Adapt homedirectory to your current setup in ook LI NM ES Generated file don t edit please Wed Nov 26 10 Etpserver Etpserver Etpserver Etpserver Etpserver lt NAME OF DELIVERABLE gt user user user user user
3. Download jdk 8uversion linux x64 tar gz from link above PostgreSQL Recommended Version 9 3 Architecture x64 For Windows Download Link http www enterprisedb com products services trainin download NAME OF DELIVERABLE gt PAGE 27 In a SEVENTH FRAMEWORK PROGRAMME 1 3 R Required Version 3 0 2 Architecture x64 For Windows Download Link http www r project org 1 4 OptiRail Server Alpha Release Available at SourceForge OptiRail project e https sourceforge net projects optirail files OptiRail Alpha Releases OptiRail Alpha R v1 1 0 OptiRail_Server_1 1 0 zip e https sourceforge net projects optirail files OptiRail Alpha Releases OptiRail Alpha R v1 1 0 OptiRail_Client_1 1 0 zip 2 Install the download software applications 2 1 Java For Windows Download link above and install Java 8 x64 Set Java Runtime Environment Variables When the installation finishes open Java Control Panel Control Panel Programs Java On the Java tab press the button View Then add the following parameters to Runtime Parameters Xms256m Xmx5g XX UseParallelGC XX PermSize 256m XX MaxPermSize 5g These variables can be adjusted depending on the PC specs For Linux In the terminal execute sudo apt get install rpm Create the java directory if it doesn t exist sudo mkdir usr java Change to the directory cd usr java Unpack the package sudo tar zxvf lt package_dir
4. OPTIRAIL USER MANUAL Deliverable n9 D5 2 SEVENTH FRAMEWORK PROGRAMME Project full title EC GA Number 314031 Development of a Smart Framework Based on Knowledge to Support Infrastructure Maintenance Decisions in Railway Corridors TIRA 7 Work Package SEVENTH FRAMEWORK PROGRAMME Type of document Deliverable Date 23 03 2015 Transport Grant Agreement No 314031 CARTIF ES UGR ES OSTFALIA DE MERMEC IT EVOLEO PT SINTEF Partners NO Responsible EVOLEO Title D5 2 OPTIRAIL User Manual Version 1 Page 2 42 Deliverable 5 2 OPTIRAIL User Manual DUE DELIVERY DATE M24 ACTUAL DELIVERY DATE M24 Document History Vers IssueDate Content and changes Author 01 23 09 2014 First version Pedro Ribeiro Saulo Sobreiro Hugo Pereira Igor Trindade 02 23 03 2015 Updated document sections according Pedro Ribeiro Saulo Sobreiro to the actual OptiRail tool features Hugo Pereira Igor Trindade Installation Manual also updated after testing in both windows and Linux OS Document Authors Jm CARTIF Marta Galende Francisco Barrientos SINTEF Andreas Okland Dissemination level RE Document Approvers di MAME EVOLEO Pedro Ribeiro Executive Summary OPTIRAIL is a framework which aims obtain higher levels of safety and service in railway infrastructures optimal life cycle for the management of railway infrastructure maintenance
5. For each row in the table scripts replace the tag SOPTIRAIL SERVER ROOTS in column filepath with the actual value defined above 5 2 Setup Executables For Windows The executable OptiRail Server 1 1 0 launcher bat launches all OptiRail Services and the file OptiRail Server 1 1 0 OptiRail Maintenance Toolkit OptiRail Maintenance Toolkit jar At your option create a shortcut for these files in your desktop For Linux You can also copy the files in installation folder linux runnables to your desktop To run those executables you should declare them as runnable To do that execute sudo chmod 777 executable name Additionally set the file OptiRail Server 1 1 0 OptiRail Maintenance Toolkit toolkit launcher sh as executable execute the OptiRail services double click on the file server launcher sh and choose Run in Terminal You also need to install xdotool e sudo apt get install xdotool At last restart your machine NAME OF DELIVERABLE gt PAGE 36 SEVENTH FRAMEWORK PROGRAMME 3 2 OPTIRAIL CLIENT INSTALLATION The client software installation requires some simple steps in order to be successfully set up and ready to use To install it manually the steps are 1 Required software packages The required software packages for the OptiRail Client to run are 1 1 Java Recommended Version 8 Architecture x64 For Windows Download link http w
6. Server configuration file optirail cfg namely the tags db host db port db user and db password 3 3 4 TROUBLESHOOTING A typical problem in brand new setups is the firewall blocking communications between services The OptiRail Server framework was projected to use the ports 1080 to 1109 in spite of only 1080 1105 are being used in the current release more info at SOPTIRAIL SERVER ROOTS config optirail cfg Additionally PostgreSQL Service uses 5432 port by default Another typical situation may happen due to white spaces or invalid characters in file or folder paths NAME OF DELIVERABLE gt PAGE 42
7. gt jdk 8uversion linux x64 tar gz Now you must create the Java environment variables e sudo gedit etc environment e Inthe first line of the file write JAVA_HOME usr java lt java_folder gt e Inthe PATH declaration add SJAVA_HOME bin lt NAME OF DELIVERABLE gt PAGE 28 SEVENTH FRAMEWORK PROGRAMME Ex PATH usr local sbin usr local bin usr sbin usr bin sbin bin usr games SJA VA_HOME bin Save and close To load the new environment variables configuration the bhashrc must be changed sudo gedit bashrc Add at the end of file source etc environment Save and close To refresh the terminal close it and open a new one Lastly write ControlPanel on your new terminal On the Java tab press the button View Then add the following parameters to Runtime Parameters Xms256m Xmx5g XX UseParallelGC XX PermSize 256m XX MaxPermSize 5g Press Apply and Ok to close it S Java Control Panel Mi eS Runtime Parameters Enabled 18 LBO http fjavas C Program Files Java Xms256m Xmx5q X lt NAME OF DELIVERABLE gt PAGE 29 2 2 PostgreSQL For Windows Download link above and install PostgreSQL x64 Be wary of the superuser password Please provide a password for the database superuser postgres Password Retype password 5551 BitRock Installer And service port definition Please select the port number the
8. server should listen on Port 5432 BitRock Installer Open the PostgreSQL application Stack Builder NAME OF DELIVERABLE gt SEVENTH FRAMEWORK PROGRAMME PAGE 30 Select your PostgreSQL installation Select pgJDBC tool under Database Drivers Other tools may be chosen as well but this one is mandatory c NN E B Categories i Add ons tools and utilities Ee Database Drivers 7 Nposq v2 0 14 3 1 installed Database Server H B Registration required and trial products H B Replication Solutions Ea aes Spatial Extensions Gl Web Development A collection of JDBC drivers for PostgreSQL JDBC3 JDBC4 and JDBC41 Packaged by EnterpriseDB For Linux Execute in the terminal sudo gedit etc apt sources list d pgdg list Add the line deb http apt postgresql org pub repos apt precise pgdg main and save it Back in terminal execute wget quiet O https www postgresql org media keys ACCC4CF8 asc sudo apt key add After the step above is completed execute the following commands e sudo apt get update e sudo apt get install postgresql 9 3 For everything to work fine one change has to be made in the file pg hba conf To change it write the follows commands e sudo gedit path to file pg hba conf Default folder is etc postgresql lt version gt main pg_hba conf Suggestion use the command locate to find the file Ex locate pg hba c
9. 27 432 WET 2014 OoOptirail writepermission true optirail idletime U optirail userpassword D41D8CDS8FO00B204ES8800898ECF8427E optirail enableflaq true optirail homedirectory home optirail dptiRail Alpha Release_0 3 Dpl_OptiRai PAGE 41 _ SEVENTH FRAMEWORK PROGRAMME e Client side configuration In optirail cfg file 1 Write the client machine IP in the client_address tag values 2 Write the server machine IP in the server address and remote host tag values 3 Open the ports 21 22 990 and 1080 1089 on the firewall and eventually in the anti virus If the default ports present in this file are changed they should be opened in the firewall Any changes to the service ports in the server side configuration should be done in this file as well 3 3 2 WINDOWS AND CUSTOM LINUX SETUP Additionally the OptiRail default configuration setup is prepared for specific installation paths namely the ones followed in the installation for Linux video If the installation was made in the same but in Windows or for a different directory in Linux follow this steps e Server side configuration In optirail cfg file Adapt users cfg file and keystore file file paths to your current setup In users properties files Adapt homedirectory to your current setup 3 3 3 DATABASE SETUP Verify if the parameters defined during the PostgreSQL installation are the same as the ones present in the OptiRail
10. ABLE gt PAGE 8 1 OPTIRAIL ARCHITECTURE OVERVIEW This section will present an overview of the OptiRail architecture details concerning sequence processing and associated exports 1 1 OVERVIEW SERVICE ORIENTED ARCHITECTURE In the following image Figure an overview of the system architecture is presented It represents a service oriented architecture where three levels can be found as described in the D5 1 validation document These levels are related to the three layers Level A Data and Knowledge Services Level B Business Logic Services Level C User Interface Client Side Server Side OptiRail Client Application I d Selected Module Workspace Level C Level B Level A FIGURE 1 OPTIRAIL SYSTEM OVERVIEW lt NAME OF DELIVERABLE gt PAGE 9 eme amp DYNI p mm SEVENTH FRAMEWORK PROGRAMME 1 1 1 LEVEL A DATA AND KNOWLEDGE The level A Data and Knowledge Services is composed by different types of management services Database Handler Service which should grant a correct a correct access to the PostgresSQL database data for any service File Management Service in conjunction with a file transfer service to maintain and manage raw data files scripts heavier structures data exports and backups Authentication Service responsible for controlling the user sessions and permissions Scientific Engine Service which allows the execution of R scripts wit
11. AGE 33 e il nac SEVENTH FRAMEWORK PROGRAMME Import OptiRail database structure psql U USERNAME DBNAME lt path to VOptiRail Server 1 1 0 installation _supportidb_offsetloptirail_dp sql EN Administrador C Windows System32 cmd exe Microsoft Windows Vers o 6 1 7681 1 Copyright c 2669 Microsoft Corporation Todos os direitos reservados Czsyuindowz systemi gt cd C Program Files PostygreSGL 9 3 bin C2 Program Files PostgreSQL 9 Jaxbin gt pzql U postgres postgres lt C Users Pes Desktop Dlp OptiHRail Server H 1 H BHB zeruer installation support dhb offzet aptirail dh sul For Linux To import database the terminal must be used Thus write the commands First change the postgresql password e sudo u postgres psql postgres e password postgres q Then import the OptiRail database structure e sudo service postgresql restart e sudo psql U postgres d postgres f lt filename gt pgsql To manage the database could be installed the pgadmin3 GUI tool and follow the steps above To do that execute e sudo apt get install pgadmin3 e pgadmin3 lt NAME OF DELIVERABLE gt PAGE 34 PROGRAMME 5 Setup environment variables For Windows The OptiRail Server requires some environment variables in order to work properly which are described in the following table EV Value OPTIRAIL SERVER ROOT Path to the OptiRail root folder s
12. Additionally he must choose the input table with segmented track data with values like QO and b and the processing sequence that should run As the selected sequence may take a long time to run the results are not shown immediately Rather a notification should be sent when the results are ready lt NAME OF DELIVERABLE gt PAGE 18 Maintenance Plan Summary 11 12 DSSModule 13 14 1 16 17 18 19 20 21 22 LookUpModule SubmitFile Capacity Loss h T a 23 24 6 175 000 6 200 000 6 225 000 6 250 000 6 275 000 6 300 000 6 325 000 6 350 000 6 375 000 6 400 000 Maintenance Cost 25 lt Tamping Renewal Capacity Loss WO Segment vs Trimester WO Line vs Trimester Workorders along the track 6354815 6354815 6251444 6237719 6248879 6257122 6257122 6247525 6194865 6182434 6198354 6198354 6221292 6199260 6202522 118 118 165 180 169 163 163 173 285 290 241 241 235 238 236 FIGURE 10 DECISION SUPPORT SYSTEM MODULE OUTPUT INFO DISPLAY 708 709 566 545 543 573 574 541 482 463 492 493 529 493 498 _ SEVENTH FRAMEWORK PROGRAMME 9 wwe w w N hN d w Sol Costs Loss h Tamp Rene A On the other hand the user can load the results of a previously generated maintenance plan This will display all input data used as well as show data concerning each possible solution provided per maintenance plan In turn ea
13. E 21 SEVENTH FRAMEWORK PROGRAMME Segment GraphAnalysis Apr 27 May 15 Sep 02 Mar 04 Nov 03 Mar 23 2010 2010 2011 2011 2012 Track Characteristics X Axis units Segments Kilometers Sliper_typ_korr Befastn_korr isEmbankment isCutting Raltyp_korr radClass isTunnel Sliper inlagd ar isBridge amountWorkOrders Segments FIGURE 13 GRAPH ANALYSIS MODULE TRACK CHARACTERISTICS The last chart presents the track s infrastructure characteristics All available track properties are shown in the top list which the user can move to the bottom list to arrange the properties to be seen This graph also has both zoom and on mouse over functionalities NAME OF DELIVERABLE gt PAGE 22 __ SEVENTH FRAMEWORK PROGRAMME 2 6 NOTIFICATIONS The user should be able to configure a message that will be sent to him as soon as some specific event happens in the application For example the user could configure an email to be sent to him when a specific type of sequence finishes its processing which in turn could contain some information on the actual sequence success failure errors EE Optirail Notification Example Lp T RA l Name Notification Example Active w NotificationModule New File rail x Login Sequence Live Notification w R Notificati z COSMO E mail w igor trindade evoleotech com FIGURE 14 NOTIFICATIONS MOD
14. ER INTERFACE wada 13 PNFecm m 13 Pavo 14 2S LOOK UP INFORMATION 15 ZTE NCE PLAN 18 EEE EA E PFO 20 2 0 INO TIE IG TION 23 2 7 OPTIRAIE MAINTENANCE TOOLKIT seed ZEGARA JARE KEG LESKO OPOR W 24 ZALADDTINACRA Goo re A 24 2 7 2 MANAGE SEQUENCES EZ EE 25 NOTIFIER cieie aE E E m 26 m 27 3 1 OPTIRAIL SERVER INSTALLATION dU Wc Odd B G od dE rod SEA 27 32 OPTIRAIECEENT INSEAELATION idu ade utin Qa ae Ida QR OGAE cad AWAKE GO CIE 37 gt OOPIIRAJECONFIGURANON act brani anra q uq 130NRI Ces aU hands E A 41 Ez ala 41 3 3 2 WINDOWS AND CUSTOM LINUX SEV UP aoc EGO AL a G OWA das 42 3 3 3 DATABASE SETUP ET 42 SRM iei el cA 1 42 NAME OF DELIVERABLE gt PAGE 7 pris R Acronyms lt NAME OF DELIVER
15. ULE SCREEN Figure 14 shows how a user can manage his notifications Similar to sequences a notifications must have something that triggers it The contact methods are email and live notification The message itself should be automatically written depending on the matter it refers to In this example both email and live notification will be sent when a new rail type file is submitted lt NAME OF DELIVERABLE gt PAGE 23 SEVENTH FRAMEWORK PROGRAMME 2 7 OPTIRAIL MAINTENANCE TOOLKIT This toolkit is a way to configure some database parameters without the need to change them manually It can only be used in the machine where the OptiRail server is running The OptiRail Maintenance Toolkit has three functionalities 2 7 1 ADD TRACK p Optirail Management Toolkit EET Add Track Manage Sequences Notifier Create Track Current Tracks Name Aveiro Porto Start Beira Alta End Increment Configuration saved FIGURE 15 OPTIRAIL MAINTENANCE TOOLKIT ADD TRACK Allows the user to add additional tracks to the OptiRail framework The parameters Start and End should be within the limits in the geometrical files and Increment is the asset length in those files Therefore the user can define a smaller section of a real track to be analysed allowing a more focused study NAME OF DELIVERABLE gt PAGE 24 SEVENTH FRAMEWORK PROGRAMME 2 7 2 MANAGE SEQUENCES Gp ager Tosa 0000000000
16. ables e sudo gedit etc profile d myenvvars sh e Now add the following lines it bin bash source etc environment After saving the file change the file permissions NAME OF DELIVERABLE gt PAGE 39 e sudo chmod 777 etc profile d myenvvars sh 4 1 Setup Executables For Windows The executable OptiRail Client 1 1 0 OptiRailJarLoader jar launches the OptiRail Client At your option create a shortcut for this file in your desktop For Linux You can also copy the files in installation folder linux runnables to your desktop To run those executables you should declare them as runnable To do that execute sudo chmod 777 executable name Additionally set the file OptiRail Alpha R v1 1 0 OptiRail Client 1 1 0 client launcher sh as executable To execute the OptiRail client double click on the file client launcher sh and choose Run in Terminal You also need to install xdotool e sudo apt get install xdotool At last restart your machine NAME OF DELIVERABLE gt PAGE 40 SEVENTH FRAMEWORK PROGRAMME 3 3 OPTIRAIL CONFIGURATION OptiRail uses configuration files to manage server client communications as well as database access ftp and smtp configurations This allows the user to adapt OptiRail to his current infrastructure and network setups On the server side there are two configuration files optirail cfg and users properties both in the
17. ach selected table must have been in the same sequence Then the module will show the compiled information about the track The first chart presents the quality evolution off a track s segment over time The green dots indicate the measured quality at that point in time The blue lines are exponential regressions of quality values between work orders At last red lines represent known work orders To help understand what each of these components represent when the user moves the mouse over them a small tooltip screen will show additional information about that component NAME OF DELIVERABLE gt PAGE 20 _ SEVENTH FRAMEWORK PROGRAMME 1 nov 2012 Time days Track Evolution GraphAnalysis August 7 2009 Max Y value 5 Min Y value 0 X Axis units e Segments Kilometers Quality sigh 50 Segment May 15 Sep 02 Mar 04 Nov 03 Mar 29 2010 2010 2011 2011 2012 Track Characteristics X Axis units FIGURE 12 GRAPH ANALYSIS MODULE TRACK EVOLUTION The second chart is a view on track quality evolution over time It shows quality index for the entire track on a given date The play button starts an automatic presentation of this evolution The amount of information presented depends on the track length and therefore a zoom functionality was implemented so that such large amounts of data are always readable To zoom in out just scroll over the plot s x axis NAME OF DELIVERABLE gt PAG
18. better quality of service and therefore higher level of client satisfaction improved level of availability of the railway infrastructure OPTIRAIL will also ensure a more effective planning of the management and activities of infrastructure maintenance based on the information stored in the monitoring and maintenance management systems The main goal of this document is to provide an overview of the OptiRail software architecture its features user interfaces and the manual installation and configuration procedures for both Windows and Linux operating systems SZ TABLE OF CONTENTS 1 OptiRail Architecture overview SENATUS eR A 9 1 1 OVERVIEW SERVICE ORIENTED ARCHITECTURE ccccccccsssecceecesecceeceeseeccseeeeeccseeeeeeseeseeeeeeeesseeeeeeeeseees 9 1 10 1 1 2 LEVEL B BUSINESS pisa Se ERP ebat qbus cessa UP REM A E AGE 10 1 1 3 oM iz INTERFACE MR m uu T mms 11 1 2 OVERVIEW PROCESSING SEQUENCES ccccccccsssscccceenseccsceensecesseeeseccsseeesecesseeeeesesseeeesesseueeecesseeneesestenes 11 1 2 1 OVERVIEW EXPORT ea oo aa EE AA ar vie du Kii ko ira dA dac siebie 12 2 US
19. bin usr bin sbin bin usr games SJAVA _HOME bin e To load the new environment variables configuration the bhashrc must be changed sudo gedit bashrc e Add atthe end of file source etc environment e Save and close NAME OF DELIVERABLE gt PAGE 38 _ SEVENTH FRAMEWORK PROGRAMME e To refresh the terminal close it and open a new one Lastly write ControlPanel on your new terminal On the Java tab press the button View Then add the following parameters to Runtime Parameters Xms256m Xmx5g XX UseParallelGC XX PermSize 256m XX MaxPermSize 5g Press Ok and Apply to close it 3 Setup software structure In order to set up the OptiRail Client file system extract the Optirail Client folder from OptiRail Client 1 1 0 zip to any path in the file system 4 Setup environment variables For Windows The OptiRail Client requires an environment variable in order to work properly That EV is described in the following table EV Value OPTIRAIL CLIENT ROOT Path to the OptiRail root folder see above step 3 Setup software structure Ex C OptiRail Alpha 1 1 0 Dpl OptiRail Client 1 1 0 For Linux Declare environment variable e sudo gedit etc environment Addin the first line e CLIENT ROOT path to dir OptiRail Alpha R v1 1 0 OptiRail Client 1 1 0 Now is need to add a script shell file on etc profile d to load the environment vari
20. ch solution has information on the suggested tamping and renewal work orders the capacity loss along the track for each trimester and two charts with all work orders per segment or kilometre separated by trimester This module should also allow to export the results of the selected maintenance plan The data generated in each maintenance plan is available in xlsx format on the service file system more on this in chapter 1 2 1 lt NAME OF DELIVERABLE gt PAGE 19 SEVENTH FRAMEWORK PROGRAMME 2 5 GRAPHICAL ANALYSIS As this type of data in its raw format is sometimes hard to interpret there is a need to expose in a user friendly manner which is exactly the Graph Analysis Module purpose Figures Figure 11 Figure 12 and Figure 13 are examples of this module interface accessible by pressing the button on the navigation bar Optirail EET Porto infrastructure seg 2014 assets 20140907n6 ser learning 20140907n3 GraphAnalysis Segment Evolution 5 Max Y value Min Y value n Segment 2 2 0 27 abr 2007 2008 2 2012 nov 2012 2009 2010 Quality sigh Time days Track Evolution August 7 2009 Max Y value 5 Min Y value 0 FIGURE 11 GRAPH ANALYSIS MODULE SEGMENT EVOLUTION Initially the user selects the dataset he wants to analyse The server will prepare the information to be shown which may take a minute or two It is important to note that e
21. communications will be asynchronous This allows the user to run more than one request at the same time on different modules Applying the current modularity concept any developer may also add custom modules to this system with no need to fully understand how the Level B Business Logic layer works 1 2 OVERVIEW PROCESSING SEQUENCES Processing sequences are organized sets of R based algorithms whose objectives are to compile all available railway characteristics and generate new analysis on that structure Whenever new data is submitted to the application a predefined processing sequence will run analysing that data and even creating new models from it A map of all available sequences in OptiRail is shown in Figure 2 Read Only Auscultation File Submission Ingest v Auscultation and Store No homogeneous segmentation Homogeneous Dynamic Segmentation Segmentation Complete sequence Modelling Curvature File Submission Ing est Curvature and Store Read file and homogeneous segmentation Read Only Infrastructure File Submission Ingest Curvature and Store Read Only FIGURE 2 AVAILABLE SEQUENCES NAME OF DELIVERABLE gt PAGE 11 _ SEVENTH FRAMEWORK PROGRAMME It is important to note that those sequences shouldn t all be active at the same time as it would create unnecessary processing The OptiRail Maintenance Toolkit allows the user to
22. configure which sequences are active more on chapter 2 7 1 2 1 OVERVIEW EXPORT Some R based algorithms automatically generate files with data extracted from the OptiRail SQL database Such files are xlsx format files whose structure follow the templates used by RAMSYS This allows RAMSYS to integrate the data generated by OptiRail s processing sequences These files are stored on the server machine in the OPTIRAIL SERVER ROOT data files exports folder The type of files generated are e Aligned geometrical auscultation e Work Orders e Work Orders generated in the decision support system maintenance plans Other files can be found in the OPTIRAIL SERVER ROOT data files directory They are also generated during sequence runtime but do not follow any specific template being only produced to ease R processing or server client communication That being said they are human readable and contain information that can be adapted to other frameworks NAME OF DELIVERABLE gt PAGE 12 lt prinail R 2 USER INTERFACE This section shows how information can be manipulated configured and displayed in OptiRail Client application The functionalities presented are login file submission lookup information maintenance plan and notifications Additionally it is explained how the user should proceed to perform each of those steps 2 1 LOGIN The following image Figure 3 is a common one the user login panel The interface
23. ee above step 3 Setup software structure Ex C OptiRail Alpha 1 1 0 Dpl OptiRail Server 1 1 0 FZ USERS ROOT Path to the FTP users shared folder Ex C OptiRail Alpha R 1 1 0 Dpl OptiRail Server 1 1 0 data files ftp users Path Path to bin x64 folder in the R installation see above step 2 3 R Ex C Program Files R R 3 0 2 bin x64 Path Path to x64 JRI installation in the rJava package see above step 12 3 R Ex C Program Files R R 3 0 2 library rJava jri x64 R_HOME Path to root R installation see above step 2 3 R Ex C Program Files R R 3 0 2 R_LIBS_USER Path to R packages root see above step 2 3 R Ex C Program Files R R 3 0 2 library For Linux Declare environment variable e sudo gedit etc environment Add in the first line e OPTIRAIL SERVER ROOT path to dir OptiRail Alpha R v1 1 0 OptiRail Server 1 1 0 e USERS ROOT path to dir OptiRail Alpha R v1 1 0 OptiRail Server 1 1 0 data files ftp users Now is need to add a script shell file on etc profile d to load the environment variables e sudo gedit etc profile d myenvvars sh NAME OF DELIVERABLE gt PAGE 35 e Now add the following lines it bin bash source etc environment After saving the file change the file permissions e sudo chmod 777 etc profile d myenvvars sh 5 1 Replace environmental variables in database Connect to the optirail database using pgadmin3
24. entRightD2 0 88999998569488503 1 04999995231628 1 16999995708466 1 3999999761581401 1 5199999809265099 1 75 1 83000004291534 1 9900000095367401 2 0699999332428001 2 3800001144409202 2 3399999141693102 2 5699999332428001 2 5699999332428001 2 5299999713897701 6 1300001144409197 6 1700000762939498 6 1700000762939498 6 25 6 2800002098083496 6 4400000572204599 6 5999999046325701 6 6700000762939498 6 8699998855590803 6 9899997711181596 7 2199997901916504 7 3000001907348597 7 6100001335143999 7 6500000953674299 Infrastructure Parameters End To 45 849998474121101 46 2099990844 72699 46 4799995422363 46 830001831054702 47 139999389648402 47 569999694824197 48 48 349998474121101 48 819999694824197 49 209999084472699 49 720001220703097 50 069999694824197 50 659999847412102 50 970001220703097 FIGURE 5 LOOK UP MODULE SCREEN Infrastructure 2012 11 01 Homogeneous Segm 6 6700000762939498 6 6700000762939498 6 75 6 6399998664856001 6 71000003814697 6 6399998664856001 6 75 6 78999996185303 6 9099998474121103 6 78999996185303 7 0300002098083496 6 9899997711181596 7 1799998283386204 7 4200000762939498 alignmen 46 2099t 46 5200 46 8300 47 0299 47 3800 47 6100 48 48 3199 48 6699 48 8199 49 3699 49 5999 50 0699 50 5800 With the navigation bar at the top the user can select the type of data he wants to see In this example the user accesses the aligned a
25. h a previously defined sequence 1 1 2 LEVEL B BUSINESS LOGIC SERVICES The level B Business Logic Services is composed by all the services required to handle the user needs The actual services by role are Lookup Services The Lookup Services are used to retrieve any searchable rail data that can be found in the database Scheduling Services The Scheduling Services are used to prepare actions to be run after some event Those events may be for instance a date based scheduled task or the ending of some data process Decision Support Services The Decision Support Services will support the construction and adaptation of any type of maintenance plans Notification Services The Notification Services shall grant the users the ability to understand what s going on the server side of the system warning him with text messages Each user will subscribe any number of notifications according to its interests lt NAME OF DELIVERABLE gt PAGE 10 piiril L 1 1 3 LEVEL C USER INTERFACE The level C User Interface is a modular application which will load application modules into the main client interface The OptiRail Client application requires a successfully login before any module is loaded The Client will also support some native system notifications with no need of any module to be loaded In order to improve the system interoperability and to prevent the user to be held in any module workspace all the systems
26. itself is as standard as it could be in spite of providing some hidden functionalities E Username optirail Password LG wo mee Ms Ham 1 FIGURE 3 LOGIN SCREEN As soon as a user logs in successfully a navigation menu should appear in the left side off the screen containing all the functionalities available to that user From now on the most common interactions between the user and the data will be shown while explaining the application functionalities NAME OF DELIVERABLE gt PAGE 13 SEVENTH FRAMEWORK PROGRAMME 2 2 FILE SUBMISSION Next is an example in how a user can upload a given dataset like an auscultation or work order info to the application The service responsible for this functionality is Submit File accessible in the user navigation bar Type aligned auscultati v Select Tracks Auscultation date 12 09 2013 Location Browse DSSModule Send File LookUpModule SubmitFile FIGURE 4 SUBMIT FILE MODULE SCREEN To upload a document the user must fill three fields the track to which the data set belongs the local path to the document and the type of data the document refers to auscultations work orders and so on As the user submits the file and its parameters the file transfer from the client to the OptiRail server will be initiated The file will then be stored in server file system and a reference to it is saved i
27. n the SQL based database so that the application knows how to access it in the future Additionally if there are any configured processing sequences configured for the selected file type then such sequences will be automatically triggered upon file transfer completion NAME OF DELIVERABLE gt PAGE 14 SEVENTH FRAMEWORK PROGRAMME 2 3 LOOK UP INFORMATION The user can access the Look Up service to see any table stored in the database resultant from data processing Figure 5 is an example of the LookUp Module interface which can be accessed by pressing the Look Up button in the navigation bar just under the OptiRail icon xCprimi DSSModule Track GraphAnalysis LookUpModule SubmitFile marker 120000000 120000025 120000050 120000075 120000100 120000125 120000150 120000175 120000200 120000225 120000250 120000275 120000300 120000325 Measurement 3 3 3 3 3 3 3 3 3 3 3 3 3 3 E E E S E 585 E 5 E E E E E Dynamic Segm Porto Select Tables geometrical_21_2008_04_17 S alignmentLeftD1 2008 1 21000003814697 1 3200000524520901 1 5199999809265099 1 66999995708466 1 78999996185303 1 87000000476837 1 9099999666214 2 0299999713897701 2 0999999046325701 2 1800000667571999 2 1800000667571999 2 3399999141693102 2 2599999904632599 2 46000003814697 2007 04 27 alignmentLeftD2 20 alignmentLeftD3 20 alignmentRightD1 20 alignm
28. onf e Inthe file in the line local all postgres peer change peer to md5 and save Source http www postgresql org download linux ubuntu NAME OF DELIVERABLE gt PAGE 31 sP _ SEVENTH FRAMEWORK PROGRAMME For Windows Download link above and install R 3 0 2 x64 Copy R packages to the R library folder Copy all contents from server installation support packages r to your R library folder which by default is C Program Files R R 3 0 2 library For Linux Open file sources list sudo gedit etc apt sources list Add on the last line of the file deb http cran rstudio com bin linux ubuntu precise Save and close it In the terminal execute e sudo apt key adv keyserver keyserver ubuntu com recv keys E084DAB9 e sudo add apt repository ppa marutter rdev e sudo apt get update e sudo apt get upgrade e sudo apt get install r base core 3 0 2 1preciseO precise corresponds to ubuntu version e sudo apt get install libcurl4 gnutls dev e sudo apt get install libpq dev e sudo apt get install libxml2 dev e mkdir p R x86_64 pc linux gnu library 3 0 2 Copy R packages to the R library folder Copy all contents from server installation support packages linux to your R library folder which by default is home dir2 R x86 64 pc linux gnu library 3 0 2 Declare environment variable e sudo gedit etc environment Add on first line e R LIBS USER z path to dir R x86 64 pc linux gnu librar
29. requires 4 or more points To ease this process there is a small text on the screen recommending which configuration is adequate in each situation NAME OF DELIVERABLE gt PAGE 25 Chii SEVENTH FRAMEWORK PROGRAMME 2 7 3 NOTIFIER Add Track Manage Sequences Notifier Define Notification Sender Password Server smtp office365 com Save Reset Changes Configuration saved FIGURE 17 OPTIRAIL MAINTENANCE TOOLKIT NOTIFIER Allows the user to configure the OptiRail Email i e the email that will send notifications It should be devoted to this purpose only The server field is the smtp service provider address Many service providers were tested but some failed to meet the application needs thus Microsoft services are recommended here NAME OF DELIVERABLE gt PAGE 26 lt prinai 7 3 TOOL INSTALATION This chapter presents the installation method for the OptiRail Software Such is separated into two major components Client and Server having each of them their own installation procedure 3 1 OPTIRAIL SERVER INSTALLATION The server installer requires several steps in order to be successfully set up and ready to use To install it manually some steps must be followed 1 Required software packages 1 1 Java 1 2 Recommended Version 8 Architecture x64 For Windows Download link http www oracle com technetwork java javase downloads index html For Linux
30. umns to the template columns Template Column Track Location Longitudinal Level D1 L Longitudinal Level D2 L Longitudinal Level D3 L Longitudinal Level D1 R Longitudinal Level D2 R Longitudinal Level D3 R Alignment D1 L as OptiRail Column Select Column marker longitudinalLeftD1 2008 04 17 Select Column Select Column lengitudinalRightD1 2008 0 Select Column Select Column alignmentLeftD1 2008 0417 Back Export Cancel FIGURE 8 EXPORT WIZARD TEMPLATE EXPORT Additionally the user can define the export file destination and has xlsx and csv as supported file formats lt NAME OF DELIVERABLE gt PAGE 17 _ SEVENTH FRAMEWORK PROGRAMME 2 4 MAINTENANCE PLAN The Maintenance Plan service is responsible for generating all the information regarding that subject It is accessible in the user navigation bar HG Optirail p R m Maintenance Plan Maintenance_Plan BIN 4 LLL DSSModule LookUpModule SubmitFile FIGURE 9 DECISION SUPPORT SYSTEM MODULE INPUT FORM Here the user is able to generate a new maintenance plan or load one stored in the database To generate a new maintenance plan the user should fill a maintenance plan configuration form that holds information like tamping operation cost renewal operation cost number of trimesters to analyse traffic information per day and others
31. uscultation data in the database The UI is generated dynamically i e if the user selects a different track or a different time period the auscultation dates presented may change In the output a table with the selected data is shown Moreover the user can export the data he has just looked up lt NAME OF DELIVERABLE gt PAGE 15 SEVENTH FRAMEWORK PROGRAMME 8 Normal Export Use Template File Destination Define Destination geometrical 21 2008 geometrical 21 2008 04 17 FIGURE 6 EXPORT WIZARD MAIN SCREEN In case the user wants to export the geometrical data on his screen to a file he can do so by clicking in the export button on the upper right side of the screen This will open the Export Wizard The user has two main options e Export manually or normal export The user defines the table as well as which columns to export Define which columns to export Select All Clear All v marker qualityclass 2008 04 17 vi stationarea 2008 04 1 7 v alignmentLeftD1 2008 04 17 _ alignmentLeftD2 2008 04 17 _ alignmentLeftD3 2008 04 17 ignmentRightD1 2008 04 17 ignmentRight02 2008 04 1 7 ignmentRightD3 2008 04 17 v longitudinalLeftD1 2008 04 17 FIGURE 7 EXPORT WIZARD NORMAL EXPORT lt NAME OF DELIVERABLE gt PAGE 16 SEVENTH FRAMEWORK PROGRAMME e Export using Template The user selects which table to export and matches its col
32. ww oracle com technetwork java javase downloads index html For Linux Download jdk 8uversion linux x64 tar gz from link above 1 2 OptiRail Client Alpha Release Available at SourceForge OptiRail project File OptiRail Client 1 1 0 zip 2 Java For Windows Download link above and install Java 8 x64 Set Java Runtime Environment Variables When the installation finishes open Java Control Panel Control Panel Programs Java On the Java tab press the button View Then add the following parameters to Runtime Parameters Xms256m Xmx5g XX UseParallelGC XX PermSize 256m XX MaxPermSize 5g These variables can be adjusted depending on the PC specs NAME OF DELIVERABLE gt PAGE 37 SEVENTH FRAMEWORK PROGRAMME View and manage Java Runtime versions and settings for Java applications and applets Runtime Parameters Enabled o C Program FilesVJava Xms256m Xmx5g X For Linux In terminal execute sudo apt get install rpm Create the java directory if don t exist sudo mkdir usr java Change to the directory cd usr java Unpack the package sudo tar zxvf package dir jdk 8uversion linux x64 tar gz Now have to create the Java environment variables e sudo gedit etc environment e Inthe first line of the file write JAVA _HOME usr java lt java_folder gt e Inthe PATH declaration add SJAVA HOME bin Ex PATH usr local sbin usr local bin usr s
33. y 3 0 2 Path by default e Add to PATH SR LIBS USER rJava jri x64 NAME OF DELIVERABLE gt PAGE 32 LI il IRA SEVENTH FRAMEWORK PROGRAMME e R HOME cinstallation dir Ex R HOME usr lib R e Add to PATH R HOME bin Add libR so in R HOME lib and libjri so in R_LIBS_USER rjava path to LD LIBRARY PATH e Add this to environment variables LD_LIBRARY_PATH SLD_LIBRARY_PATHSR_HOME lib SR_LIBS_USER rJava jri e Save and close the file Execute the command sudo R CMD javareconf 3 Setup software structure In order to set up the OptiRail Server file system extract the Optirail Server folder from OptiRail Server 1 1 0 zip That zip has the OptirailServer folder which is the root folder that contains the base folder structure and all the needed code and configuration files and the server_installation support which contains the setup SQL scripts and required R packages Place the root folder anywhere in the file system 4 Setup the PostgreSQL database For Windows Open commandline as administrator Goto the bin folder of your PostgreSQL installation cd path to postgres bin Administrador C Windows System32 cmd exe Windows Vers o 6 1 7661 Copyright tc 2669 Microsoft Corporation Todos os direitos reservados Gzsuindowssszystemi gt cd C Program Files PostgreSQL 9 3 bin C2 Program Files PostuqgreSsQL 3 hin lt NAME OF DELIVERABLE gt P
Download Pdf Manuals
Related Search