background image

Marker type

Shows the marker type currently in use. To change the marker
type, open a pop-up menu from the right corner arrow.

Marker type options

No marker

Rectangle

Diamond

Triangle

Ellipse

Diagonal cross

Cross

I-Beam

Vertical

Horizontal

Scaling limit type

Shows the scaling limit type currently in use. To change the
limit type, open a pop-up menu from the right corner arrow.

Scaling limit type options

Individual

Automatic

Common

Properties

Press Properties to open the Properties window.

Buttons in the lower row

Item fill style

Shows the item fill style currently in use. To change the item
fill style, open a pop-up menu from the right corner arrow.

Fill style options

The pop-up shows the fill style options and the icons related
to these options.

Solid

Horizontal Slide

Vertical slide

Upward diagonal slide

Downward diagonal slide

Upward diagonal wave slide

Downward diagonal wave slide

Highlight

Horizontal highlight

Vertical highlight

Horizontal lines

Vertical lines

60

1MRS756739

COM600 series, Version 5.0

Data Historian Operator's Manual

Summary of Contents for COM600 series

Page 1: ... COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 2: ......

Page 3: ...on cycles and lengths 19 4 Vtrin workspace 20 4 1 Menu bar 20 4 1 1 Database menu 21 4 1 2 View menu 22 4 1 3 Window menu 23 4 1 4 Help menu 23 4 2 Toolbar 24 4 3 Custom toolbar 25 4 4 Status bar 27 4 5 Tree window 27 4 5 1 Setting the root of the Tree window 29 4 5 2 Searching in the Tree window 30 4 6 Properties dialog 32 4 6 1 Searching in the Properties dialog 33 4 7 Tree window and the Proper...

Page 4: ...values of a variable in a history table 78 5 7 2 Scenario operations 90 5 7 3 History Update Log 94 5 7 4 Activating recollection of all variables in a history table 94 6 Process diagrams 96 6 1 Sub diagrams 97 6 2 Current values 97 6 3 History values 98 6 4 Bars 98 6 5 Symbols 99 6 6 Links 100 7 Lists 101 7 1 List screen 105 7 2 Variable list 110 7 3 Event and alarm tables 111 7 4 Alarm and event...

Page 5: ...king a backup of the Data historian 128 11 2 Taking a Data historian online backup 128 11 3 Restoring Data historian backup 131 Index 133 5 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 6: ...6 ...

Page 7: ... may be used copied or disclosed only in accordance with the terms of such license Copyright 2012 ABB All rights reserved Trademarks 1 2 ABB is a registered trademark of ABB Group All other brand or product names men tioned in this document may be trademarks or registered trademarks of their respective holders General information 1 3 The COM600 Data historian is a relational database designed and ...

Page 8: ...ention is used for menu operations MenuName Menu Item CascadedMenuItem For example select File New Type The Start menu name always refers to the Start menu on the Windows taskbar System prompts messages and user responses input are shown in the Courier font For example if you enter a value out of range the following message is displayed Entered value is not valid The value must be 0 to 30 You may ...

Page 9: ...tion about process data to OPC clients Data Access DA Part of a logical node object representing specific information e g status or measurement From an object oriented point of view a data object is an instance of a class data object DOs are normally used as transaction objects i e they are data struc tures Data Object DO The data set is the content basis for reporting and logging The data set con...

Page 10: ...data as they occur The reporting process continues as long as the communication is available Report Control Block ABB proprietary communication protocol used in substation automation SPA Protection and or Control Product supporting the SPA protocol version 2 5 or earlier SPA device XML based description language for configurations of electrical substation IEDs Defined in IEC 61850 standard Substat...

Page 11: ...oduct revision Document version date Document created 3 3 A 13 2 2009 Document revised 3 4 B 06 11 2009 Document revised 3 5 C 30 6 2011 Document revised 4 0 D 31 5 2012 Document revised 4 1 E 13 3 2015 Document revised 5 0 F 24 5 2017 11 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 12: ...network control centre NCC or distributed control system DCS COM600 benefits from the potential of the IEC 61850 standard by using the IEC 61850 6 substation configuration language SCL and IEC 61850 7 communications modeling regardless of protocol used As the IEC 61850 data modeling is used for all communic ation protocols the gateway cross reference is done in the same way regardless of the proto...

Page 13: ...abase in the COM600 computer History values can be displayed in graphical form for example as trends Vtrin is started from COM600 WebHMI HMI_Data_Historian_menu png Figure 3 1 Data Historian menu item shown in COM600 WebHMI Logging on connecting to the database 3 1 1 Click the Data Historian tab in WebHMI On the first logon the Vtrin client is installed 2 Click Run in the security warning dialog 1...

Page 14: ...d the database in the following format TCP computer or IP RTDB COM600 4 For normal operation login with the same user name and password as to the COM600 WebHMI Enter your user name in the User name field and your password in the Password field 5 If you want to use the credentials that you use for logging into Windows select Save Current Credentials 6 Connect by clicking OK or cancel the connection...

Page 15: ...rs and windows The windows display lists tables charts process diagrams and reports The charts in the tree are displayed in the window area on the right By default they open on top of each other in the size of the full area The titles of the windows are dis played in tabs at the top of the area For a normal Vtrin user User s Definitions and Variables are shown User s Definitions is empty by defaul...

Page 16: ...or s Tree view contains Maintenance tools such as templates for various trends and report templates Vtrin administrator defines what is shown for normal users for example predefined tai preconfigured trend views 16 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 17: ...te a new trend view 1 Right click User s Definitions in the tree view and select New Tree Item Trend New Trend object is created to the tree 2 Rename the object with a descriptive name 3 Open the trend view by selecting it in the tree When the trend view is opened for the first time it is empty 4 To assign variables to the trend view select Variables from the tree 17 COM600 series Version 5 0 1MRS...

Page 18: ...vidual limits check box Vtrin_trend_view1 bmp Figure 3 4 1 Example trend of COM600 For more information about the settings see Chapter 5 Charts 6 After you are ready with the changes save them via the Database menu An alternative way to create new trend views from the Variables list 1 Select the variables hold Ctrl key to select several variables 2 Right click the context menu and select Send to t...

Page 19: ...riables related to an object right click the object and select Send to Trend of all tags History collection cycles and lengths 3 5 By default history values are collected from the variables with following cycles and history length Table 3 5 1 History collection cycles and lengths History stored for 8 days 5 second default sampling cycle CurrentHistory History stored for 8 days 1 minute average val...

Page 20: ... Toolbar See 4 6 Properties dialog Properties dialog See 4 9 Window area Window area See 4 4 Status bar Status bar Table 4 10 1 lists the most common icons in Vtrin Menu bar 4 1 The menu bar is located under the title bar Row_menu_bar jpg Figure 4 1 1 Vtrin menu bar The menu bar includes the following Vtrin menus Table 4 1 1 Vtrin menu bar elements See 4 1 1 Database menu Database See 4 1 2 View m...

Page 21: ...ndow in the selected directory in the directory tree under the selected name Save copy as Sets the page settings for printing For further information see Windows help Page Setup Allows the user to preview the page before printing For further information see Windows help Print Preview Opens the Print dialog that allows you to print the content of the active window to the selected printer For furthe...

Page 22: ...dialog Selected by default Properties Not yet supported Data Playback Switches Vtrin to full screen leaving only the menu bar and window area including tabs in view To return to the normal view click the command again or click Close Full Screen on the right side of the menu bar Full Screen Saves the workspace layout Save Layout Locks the appearance of the workspace meaning that the relative relati...

Page 23: ... the active window to a new vertical leaf Move to a New Vertical Leaf Moves the active window to the next leaf Move to the Next Leaf Moves the active window to the previous leaf Move to the Previous Leaf Help menu 4 1 4 Menu_help jpg Figure 4 1 4 1 Help menu Table 4 1 4 1 Help menu items Description Item Not yet supported Contents Not yet supported Index Not yet supported Search Opens this manual ...

Page 24: ...k Steps forward through the window call path activating the following window Forward Refreshes the active window You can also refresh the active win dow by pressing the F5 shortcut key for Refresh Refresh Shows hides the Tree window See 4 5 Tree window and 4 7 Tree window and the Properties dialog Tree Shows hides the Properties dialog See 4 6 Properties dialog and 4 7 Tree window and the Properti...

Page 25: ...bars Row_custom_toolbar jpg Figure 4 3 1 Custom toolbar Table 4 3 1 Custom toolbar elements User specific each user can customize a toolbar according to his or her needs which are displayed whenever the user con nects to the database It is a good idea to place frequently used windows as buttons in this toolbar The windows can then be easily opened by clicking the appropriate buttons instead of hav...

Page 26: ...n the menu In the menu select the Edit button 2 To delete a button select the button and click Remove To edit buttons 1 Open the custom toolbar and right click to open the menu In the menu select the Edit button 2 You can edit the button properties and change the order of buttons To edit the button properties change the information needed in the ToolbarBu tton Properties area Click OK to submit th...

Page 27: ...indicate the priority of the alarm situation If the icon is colored the log contains active alarms and if the icon is flashing the log contains unacknowledged alarms Tree window 4 5 The Tree window shows the system s windows charts in a hierarchical tree structure Tree_window jpg Figure 4 5 1 Tree window The tree contains folders which in turn include other folders subfolders and windows The windo...

Page 28: ... name of the folder Open a window by clicking its node icon or name The tree can be defined so that the window can only be opened with a double click Table 4 10 1 shows some of the most common folder and window icons open_window jpg Figure 4 5 2 Open window Table 4 5 1 Open window items Description Item Corresponds to opening a window in the tree The command is not available for folders Open If th...

Page 29: ...ng menu tree You can display a tool tip by placing the cursor on a folder or a window The tool tip includes additional information on the selected item if the information has been defined Setting the root of the Tree window 4 5 1 Inside the tree any folder with content can be set as the root of the tree structure This cleans up the tree view for the user Any unnecessary information tree folders an...

Page 30: ... structure Description Menu item Restores the whole tree structure with the ori ginal root folder The expansion state of the tree is not restored after the root has been reset all folders are collapsed Reset Root Searching in the Tree window 4 5 2 You can search for items matching your criteria inside the Tree window The items are found based on the names of the nodes The search is started by clic...

Page 31: ...Search results in the Tree window If no item matches the criteria the tree is left empty Tree_search_empty_tree jpg Figure 4 5 3 The Tree window without matching search results All items in the tree are retrieved by erasing the Tree Search field The tree search is case insensitive and uses partial matching criteria So for example entering a single letter T in the search field returns a tree with a...

Page 32: ...operties dialog groups the data of a single variable in a vertical list and also provides an explanation for the data For information on how to display the Properties dialog and change its location see 4 7 Tree window and the Properties dialog The way you select an element in a window and display its properties in the Properties dialog depends on the type of window For example to view the properti...

Page 33: ...n the Tree window for more details about using the search tool Tree window and the Properties dialog 4 7 The Tree window and the Properties dialog are located on the left side of the workspace You can place the windows on top of each other as tabs The names of the tabs are dis played at the bottom of the area The windows shown in the window area have their own tabs see 4 9 Window area They can als...

Page 34: ...alog To detach a window Drag it from its title bar or double click the title bar You can freely resize a detached window and move it anywhere you want on the Windows desktop To restore the window to its previous fixed location Double click the title bar Reducing the Tree window and the Properties dialog into icons on the vertical bar To reduce the window into an icon on the vertical bar Click the ...

Page 35: ...s with a web browser Visited folders and nodes in the tree are accessible with the Back and Forward browsing buttons Also the window tabs visited in the window area are retrievable in the order they were accessed The state of the tree is restored to corresponding state when browsing the history The state of the tree means for example folders that have been expanded or collapsed while accessing dif...

Page 36: ...horizontal or vertical tabs Vtrin can only display either horizontal or vertical leafs each with its own tab at the top of the area In the previous figure the lower of the two leafs is marked with a red line The window placement and docking can be changed either via the Window menu or via the window tab pop up list The list can be accessed by right clicking the window tab 36 1MRS756739 COM600 seri...

Page 37: ...bs in the same tab group are left visible whereas other tab groups are hidden All tab groups are restored when Prominent selection is deactivated Prominent Resizes all visible windows The window sizes are set equal within all rows and within all columns Rebalance Creates a new horizontal tab group for the selected window If the current tab group is horizontal a new tab group is created under the c...

Page 38: ...he window tab Place the mouse cursor on top of the window tab and move the mouse while holding down the primary mouse button A docking helper will appear in the middle of the current view area Window_docking_helper jpg Figure 4 9 2 1 Docking helper The figure above shows the docking helper which is used to set a window to a new position If the window is dropped on top of any of the four directiona...

Page 39: ...ew tab group Any window can also be moved into a new tab group This is achieved by dropping the window onto any of the four docking helper rectangles on the far sides of the window area A new tab group is created to the corresponding half of the window area with the contents of the dropped window Icons 4 10 The following table lists some of the most common folder and window icons found in the tree...

Page 40: ...r variable Variable list text variable User definition General icon for an open folder or window Display Bases to New Items The icons of the variables indicate the variable type Icons are used for example in the variable s Status window The following table lists the icons that are used for variables Table 4 10 2 Variable icons Description Icon Floating point variable Binary variable Integer variab...

Page 41: ...e variable Magenta Invalid value Violet Questionable value Blue Value substituted Green Value OK Manually entered Invalid source reason for the invalid or substituted value Handling blocked reason for the invalid or substituted value An increasing value used in the variable s Status window A decreasing value used in the variable s Status window A static value used in the vari able s Status window ...

Page 42: ... based on application status If application status is not available the column color corresponds to that of the icon Stacked column application status Defines the color corresponding to application status Application status Icon for Gantt charts The color of the icon corresponds to that of the Gantt chart if no color condition has been defined or the condition is not fulfilled Gantt The color of a...

Page 43: ...he shape of the pointer depends on the task and in the chart area also on your selections The following table lists the pointer icons Table 4 10 6 Pointer icons Description Icon Pointer displayed in normal situations when you move the mouse or point at for example a current value or plot in charts Arrow selected Pointer displayed in normal situations when you move the mouse or point at for example...

Page 44: ...Description Icon Pointer displayed when you change the size of different areas on the screen 44 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 45: ...oll bar a time ruler scaling limits a plot area an interval row a legend The tab displays the name of the chart window When you point to the name the program displays a tool tip that shows the location database of the chart and its call path A close button with which you can close the active chart window is located at the right end of the tab row The title bar of the chart window shows the company...

Page 46: ...ee 5 1 Plot area Plot area The default title of the chart window is the name that the chart has in the tree You can edit the name in the title area if you have sufficient rights Chart title See 5 6 Time scale Time ruler See 5 5 Time scroll bar Time scrollbar 46 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 47: ...e plot area displays the graphs of variables such as line plots area plots and column series usually as a function of time Description of plot area The plot area is located below the time scroll bar and the time ruler A chart window can contain more than one plot area Past_and_Future_Plot_Area2 jpg Figure 5 1 1 Past and future plot area The plot area is divided into Past and Future areas with the ...

Page 48: ...ht side of the plot area You can zoom in repeatedly Zooming out cancels the effects of zooming in step by step To return to the original view zoom out as many times as you zoomed in With the chart pop up menu you can also view summary values of the plots view trend values zoom the plot area copy data to the clipboard and change the chart format to list or graph Only those options that are possible...

Page 49: ...nt to a part of the graph and wait for a moment A tool tip showing the content of the legend text column usually a description of the variable and the unit of the variable as well as the retrieved history data value time and status is displayed next to the pointer The history data is the data of the data point closest to the left of the pointer Tooltip_and_trend_value_line jpg Figure 5 1 1 1 Tool ...

Page 50: ...ommand Thus they are not automatically refreshed Table 5 1 2 1 Summary items Description Item Right click in the plot area and select Summary from the popup menu The window shown opens It shows plot values at the trend value line for all plots on the screen as well as the minimum average maximum and deviation values calculated from the plot points Summary Start time from the display call Start tim...

Page 51: ...is displayed in the location of the pointer Its location is fixed in relation to the plots and it moves with the plots when they are refreshed The time and values in the legend do not follow the pointer s movements but instead show the data pertaining to the selected point Clicking anywhere in the plot area makes the trend value line disappear The data in the legend starts following the pointer mo...

Page 52: ...ion 3 Left and right arrow keys move the turquoise line from one value point to another showing new trend value and time for each point Pointer_position_value_in_trend jpg Figure 5 1 3 1 Pointer position value in trend 52 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 53: ...mouse button 2 Drag the pointer to the right side of the selected area The selected area is highlighted 3 Release the mouse button If the text boxes displayed on the time span row show the start and end time of the selected area the history update bar has been defined and you can change the start and end times 4 Right click in the plot area and select Zoom In from the pop up menu The selected time...

Page 54: ...return to the original state zoom out until the Zoom Out command is disabled 3 Release the time span by clicking pins This re enables the refreshing of the time span and the graphs at the end double click in which case the pin statuses on the updated display should be Copying data to clipboard 5 1 6 Copy_Data_to_Clipboard jpg Figure 5 1 6 1 Copying data to clipboard 54 1MRS756739 COM600 series Ver...

Page 55: ...polated Values with sample count Exports the data to a statistical application Not applicable to raw data Statistics The interval used to sample the variable The default value is the width of the column defined in the display Time value The unit of interval Time unit The number of samples taken from the variable Number of samples No significance in the Statistical Tool selected Show status with HT...

Page 56: ...The legend is located below or to the right of the chart area There is always one legend for each chart For trend charts the legend is usually located below the chart area This positioning gives more space for multiple columns For column charts the legend is usually located on the right side of the chart area This gives more space for multiple rows The graphic type of the variable item is displaye...

Page 57: ...icon column since it has a fixed position To hide a graph temporarily from the plot area click the item type icon on the variable s row You can display the graph again by clicking the icon again Edit the variable of the plot in its column and or in the history column You can select one or several variables for editing If you select several variables they must be located next to each other in the s...

Page 58: ...unction Open a pop up menu by right clicking the row Select the desired option from the pop up menu OR from the function buttons above the menu Only options that are possible for your selection are act ive Menu_legend jpg Figure 5 2 1 1 Legend menu Table 5 2 1 1 Menu items Description Item Opens a menu with variable specific displays defined in the system Send to Startup of applications defined in...

Page 59: ...tings Legend_menu_upper jpg Figure 5 2 1 2 Functions in the legend Table 5 2 1 1 Function buttons for adjusting the chart item properties Description Button Buttons in the upper row Item visibility Shows the status of visibility on off currently in use To change the status click the button Item type Shows the item type currently in use To change the item type click the button Item type options Lin...

Page 60: ...ic Common Properties Press Properties to open the Properties window Buttons in the lower row Item fill style Shows the item fill style currently in use To change the item fill style open a pop up menu from the right corner arrow Fill style options The pop up shows the fill style options and the icons related to these options Solid Horizontal Slide Vertical slide Upward diagonal slide Downward diag...

Page 61: ...he order of legend columns You can change the order of columns by pointing a column heading and then dragging the column either to right or left in the table Exceptionally the column of the item icon and the subcolumns for the limits and statistics are fixed List_sorting_titles jpg Figure 5 2 2 2 List sorting titles The following tables describe the legend data associated with the data retrieved f...

Page 62: ...ble specifies the columns related to the second future data The columns that are typically used in a legend are related to the first history data and the respective calculated values see Table 5 2 2 2 Table 5 2 2 2 List of the generally used columns in the legend Description Column header The item s type as an icon The column position of this is fixed The icons used are described inTable 4 10 4 in...

Page 63: ...reen Deviation The minimum of the values retrieved to the screen This value is not refreshed automatically on the screen Minimum The maximum of the values retrieved to the screen This value is not refreshed automatically on the screen Maximum The filtering syntax currently applied to the variable See 5 2 3 Using the filter functionality for more information Filter Table 5 2 2 3 Activation buttons ...

Page 64: ...ple AVG1MIN MAX1H produces the hourly maximum values from the one minute average values Vtrin automatically changes history tables if this optimizes the search You can set off this optimization by starting with an empty filter that is the sign For example AVG1MIN is optimized while AVG1MIN is not optimized To enter the desired filter syntax double click the filter field of the selected variable Th...

Page 65: ...lues to User Specified Unit for example CONVERT hp can be used to get horse powers out of kilowatts CONVERT Cumulative Sum CUMSUM Cumulative Sum to Double Value CUMSUMTO DOUBLE Last Sample In Period minus First Sample In Period DELTA Time Weighted Deviation DEV Duration Period Length changes only upon daylight savings or with month periods DUR Good Duration as a TimeSpan Within Period DURG Invalid...

Page 66: ...in a Period Calculated to Double Use If There is a Risk of Overflow SUMTODOUBLE Time Weighted Variance VARIANCE Conditional fetch of values Returns requested values when given conditions are greater than zero Syntax WHEN Class Property1 Property2 etc Proper tyN xProperty yProperty Filter See Using the WHEN Filter for more detailed information WHEN Table 5 2 3 2 The set of available time identifier...

Page 67: ...in result set this is the same as x prevcy previous calculated y value result of the calculation of previous values periodlength period length in 100 nanosecond units goodtime time the value has not been invalid representativeness affects too meantime x prevx Supported functions abs x absolute value of x acos x arcus cosine of x asin x arcus sine of x atan x arcus tangent of x ceiling x x rounded ...

Page 68: ...is compulsory There can be 0 N properties of the given class used as conditions Default value for Class is ProcessHistory which is used if the Class argument is left empty Available classes are the same as the sources for a trend Properties are the same as the properties for the trend sources For example a first property can be Variable and a second property can be History for the ProcessHistory c...

Page 69: ...played as a graph Scaling limits 5 3 The limits determine the scaling of plots Description of scaling limits The scaling limits are displayed on the left side of the chart If there are several charts each has its own area for limits The scaling limits can be displayed in two ways with the upper and lower limits of scaling displayed in the boxes or by using scales whose end points correspond to the...

Page 70: ...e area If the curve exceeds the upper limit or falls below the lower limit at some intervals the graph is not drawn on these intervals If scaling is depicted using scales the common limits are displayed on a black scale The scale for graphs with individual limits is shown in the same color as the graph Limit scales Limits jpg Figure 5 3 1 Limit scales The following table lists the limit scales Tab...

Page 71: ... is used for the variable the variable s limits are calculated automatically and cannot be changed The background color of the box for automatic limit is gray Also common limits can be automatically calculated When they are automatically calculated the background color is gray and the values are defined with the help of the minimum and maximum values of the graphs For uptime variables automatic an...

Page 72: ...ized with upper and lower limits only The yellow graph uses manually set limits visible on the right side whereas the orange graph uses automatic scaling as the grey limit value boxes on the left reveal Trend_scaling_limits_upper_and_lower2 jpg Figure 5 3 3 Chart with two graphs 72 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 73: ...layed on the left of the current time are retrieved from the source table for history data They can be average or current values The plot values shown on the right of the current time are retrieved from the source table for future data which is usually a prediction table This requires that a prediction table has been configured into the system A red vertical line in the plot area signifies the cur...

Page 74: ...isplay If you change a locked time the time scale changes by an amount equal to the modified time difference The display is updated and the time scale keeps expanding If you maintain a locked time the time scale changes by an amount equal to the modified time difference and the display continues to be updated The display causes a load on the system Time bar Time_bar_row jpg Figure 5 4 2 Time bar T...

Page 75: ...licking moves time to the update status Locked pin Time scroll bar 5 5 The time scroll bar allows you to select the time for which the graphs of variables are presented in the chart Description of time scroll bar The time scroll bar is located above the plot area The location of the scroll bar indicates the location of the chart Past time is to its left and future time to its right When the chart ...

Page 76: ...ame The end time is locked the pin is pushed down and the graphs are no longer refreshed Double clicking the pin to unlock an end time returns you to the original view The pin is updated the scroll box moves to its original location and the graphs are refreshed again Scroll bar Time scale 5 6 With time scale you can set limits for the time span used in the chart Description of time scale The time ...

Page 77: ...etting time scale You can set the time span from the two drop down menus 1 Set the numerical value that shows how many of the selected units are shown To select a numerical value Select the correct value from the drop down menu on the left The options are Select the desired option by clicking its row 2 Select the unit for example seconds minutes To select the correct unit Select the option you wan...

Page 78: ...able The updating functions are adding new values replacing existing values deleting existing values From history updating point of view there are two kinds of history tables periodic and nonperiodic After you have updated the values of all variables you want to correct you can activate recollection for all variables in the history table for this time span This can be done in any chart window Depe...

Page 79: ...Display term The value used as the start value for a time span based history value updating Initialized with the value of the variable at the start time of the time span Start value The start time of the time span Start time The end time of the time span End time The value used as the end value for a time span based history value updating Initialized with the value of the variable at the end time ...

Page 80: ...pdating dialog box shows up with the following information ConfirmCurrentHistoryUpdating jpg Figure 5 7 1 3 Confirm History Updating dialog Optional Comment is stored into the history update log The maximum length for the comment is 80 characters Check box Allow overwriting the values after updating controls the later handling of the updated values If this option is selected the transformations th...

Page 81: ...n covers Updating then also adds the values specified in the value boxes If the history table to be updated is CurrentHistory and the value to be inserted is newer than the newest history value of that variable then the new value goes through the current value processing Otherwise the values are put directly into the target table CurrentHistoryTrendAfterUpdating jpg Figure 5 7 1 4 Current history ...

Page 82: ...ating there are two more ways to update history values Inserting replacing or deleting a single data value of a history table These are ini tialized with a single click on a chart The system responds by showing a vertical line on top of the chart The time and the corresponding default value are shown on the time bar Replacing or deleting a single data point of a history table To initialize these o...

Page 83: ...les is slightly different from the updating of a non periodic table The following figure shows an example of a periodic type average a value table The variable type is selected as before However while selecting the time span the system expands the time span to cover full period lengths regardless of the original selection AverageTrend2 jpg Figure 5 7 1 6 An average value table 83 COM600 series Ver...

Page 84: ... the update function produces new values for every time period using interpolation AverageTrendAfterUpdating jpg Figure 5 7 1 7 An average value table after updating 84 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 85: ...nly to the beginning of the first period within the time span AverageTrendAfterUpdatingPacked jpg Figure 5 7 1 8 An average value table after updating with new values in the beginning of the time span 85 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 86: ...d the update function removes the values covered by the time span AverageTrendAfterDeletion jpg Figure 5 7 1 9 An average value table after deletion 86 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 87: ... example of a periodic type the sum of values The default values suggested by the system are equal in this case SumTrend jpg Figure 5 7 1 10 The sum of values 87 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 88: ... 11 The sum of values after updating The following figure shows an example of updating a scenario table data The example shows three trends for the same variable one from the base table white one from the scenario table red and one which is combined from the previous two black The 88 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 89: ...rom the scenario table If there is no value available the value is taken from the base table if available there ScenarioTrend jpg Figure 5 7 1 12 Scenario table data 89 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 90: ...ario table updating some scenario specific operations are available A history table can have one or more scenario tables related to it but a scenario table can be connected to only one history table The name of a scenario table is the name of the history table with a scenario suffix as follows name of the related history table e g HT fixed scenario identifier _SC scenario number one or more numeri...

Page 91: ...The Graph Area pop up menu These operations should be activated by right clicking the legend row which has the appropriate scenario table and base table combination configured i e base table with option If activated elsewhere the user has to set the scenario and base tables properly Scenario clearing This operation completely clears all the scenario tables that have the same scenario number in the...

Page 92: ...he defined scenario and base tables within the time span and stores that data to the base table The original data in the base table is removed This operation concerns all variables ScenarioCommitment jpg Figure 5 7 2 3 Scenario commitment operation 92 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 93: ...ble is removed before copying CopyToScenario jpg Figure 5 7 2 4 Copy to scenario operation Delete from Scenario This operation removes all rows of all variables within the time span from the scenario table DeleteFromScenario jpg Figure 5 7 2 5 Deletion of all variables from the scenario table 93 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 94: ...ory table and a time stamp indication where data has been updated The recollection will then compute all variables and upper level history tables that depend on the defined source table For example when some source values in one hour average level have been modified the one hour level recalculation will cal culate the variables that depend on the source variables After that the one day average val...

Page 95: ... the RTDB definitions the recollection may be cumulated to all higher level history tables Click OK to activate the recollection or Cancel to cancel The recollection may take a while RTDB has a diagnostic variable RTDB_HRQUEUELENGTH that indicates the length of the current recollection queue When its value reaches zero the recollection is ready however if other recollection requests are constantly...

Page 96: ...ts call path A Close button used to close the active chart window is located at the right end of the tab row The diagram s title bar shows the diagram s title as well as the current date and time The process diagram area displays a fixed process background as well as updated process data in the form of values columns symbols or plots as sub diagrams It may also contain links to other figures eithe...

Page 97: ...irection of time of the series can be defined right down up or left Current values 6 2 The value field shows the current or history value of the variable In addition to the value you can indicate the unit of the variable s current value and value status with a status specific color or icon as well as the unacknowledged status of an alarm associated with 97 COM600 series Version 5 0 1MRS756739 Data...

Page 98: ...nly available from even periods The unit is correct as averages but not as sums The end of the variable name is the name of the history table History_value_and_tooltip jpg Figure 6 3 1 History value Bars 6 4 The bar shows the current or history value of the variable In addition to the value you can indicate the unit of the variable s value and value status with a status specific color or icon as w...

Page 99: ...brary so that part of the symbol is shown in the color of the state e g OK invalid replaced alarming In this case you can also define the state of the value to be indicated by a color or an icon and also color The state icon can be displayed at all times or only when the state is not OK The unac knowledged status of an alarm associated with a current value is indicated with a flash Figure 6 5 1 sh...

Page 100: ...anged When you point to the link the pointer changes to one resembling a hand and displays a ToolTip that shows the location database of the window to be opened call path and name Clicking the link opens the window on screen Link_and_path jpg Figure 6 6 1 Link and a tooltip 100 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 101: ...ort the items based on the information on 1 5 columns unless this has been prevented in the list configura tion A small triangle in the column heading indicates that the items have been sorted based on the column in question The direction of the triangle indicates whether the items have been sorted in ascending or descending order If the items have been sorted based on several columns a number is ...

Page 102: ...Print dialog that allows you to print all list pages the list displays columns starting from the left according to the width of the paper Print Enables the search bar Selecting the command again disables the search bar Search Enables the advanced search bar Selecting the command again disables the advanced search bar Advanced Search Locks the appearance of the list Only the Primary Sort is active ...

Page 103: ... its own in the Properties dialog List_Properties_dialog_box jpg Figure 7 2 List properties You can select how the information is presented in the window The options are shown in the following table Table 7 2 Properties dialog icons Description Icon Grouping Click the Grouping button to turn grouping on off When grouping is on the information is presented categorized under group titles When groupi...

Page 104: ...cted only is off all items are shown in the Properties window even those that are not shown in the chart columns Include read only Click the Include read only button to include exclude the information that has a read only status When the read only information is included you can view also items that cannot be edited When the read only information is excluded you can only view items that can be edi...

Page 105: ...is an advanced search bar where you can define column specific selection criteria Depending on the column the criteria can consist of string list yes no or time span condition Advanced Search bar An advanced search bar list box for columns that can only include certain values Select the criteria from the list Only the items that meet the selected criteria is accepted Most lists with restrictions o...

Page 106: ... the items are sorted The list can be sorted by a maximum of five columns A number displayed next to the triangle indicates the order in which the column is used in the sorting The direction of the triangle indicates which of the following ways the items have been sorted by Normal order Ascending order depending on the type of data in the column an alphabetical or numerical order from smallest to ...

Page 107: ...t is in the beginning of the row List_sorting_titles2 jpg Figure 7 1 2 Sorting of titles Sorting list items using column headings Click the column heading to sort the items based on a single column Click the heading of the column by which you want to sort the items for example Name The sort indicator is displayed in the heading and the items are resorted When you select the column for the first ti...

Page 108: ...on You can also change the direction of the sort column by clicking the column To delete a sort order Click the column If you click any column other than that used for primary sorting the column becomes the primary sort column other columns are preserved and the number of sort columns decreases by one if you click the primary sort column only the sort direction changes Example_list_plain jpg Figur...

Page 109: ... query strings in the advanced search bar If you use them on the search bar the string must be found in all columns to limit off a row If you do not want the query string to be included in the search results use an exclamation mark or minus sign in front of it and add it to the string mask Exclusive query strings can also include asterisks The items selected are those that include one or all the p...

Page 110: ...ve the content of the advanced search bar and the appearance of the window for example column width The content of the search bar is not saved 8 This enables you to create a variable list that displays all floating point variables for department X When you open the variable list you can for example select to only view variables with the character z in some column by entering string mask z in the s...

Page 111: ...eld For descriptions of common list boxes for example Search see 7 1 List screen The descriptions of column headings are displayed at the bottom of the Properties dialog For more information see 4 6 Properties dialog Column headings The variable s current value and its status icon These are not displayed in the Properties dialog because they are a combination of different database attributes Statu...

Page 112: ...create your own lists by editing the basic list and place them anywhere in the tree The default lists however are located in the Events and alarms folder The alarm list shows all active not deactivated and unacknowledged including deac tivated alarms in the order of arrival An alarm is removed from the alarm list when it has been deactivated and acknowledged The event list shows all events includi...

Page 113: ... Variable specific identifications Acknowledge the alarms in the alarm list by first selecting the alarm rows you want to acknowledge and then by sending an acknowledgement message As an option you can enable a talking alarm for newly specified alarm types Currently available in Finnish only Talking alarm is implemented with the server s sound card Alarm list Alarm_list jpg Figure 7 4 1 Alarm list...

Page 114: ...larm status Event time is the effective time of the alarm event which is the time stamp of the variable s current value when the status becomes effective In the case of a measurement the time stamp is normally generated by the measurement system and in the case of a calculated variable by the calculation program Event time Return priority indicates the priority of the alarm at the moment it was re...

Page 115: ...row on one side of the desired area and then by clicking on the other side of the desired area with the Shift key held down The selected rows change color 2 Acknowledge the selected rows by right clicking and choosing Send To and then Acknowledge from the popup menu The mouse must be clicked in the selected area otherwise you will acknowledge the row under the mouse instead of the selected area 3 ...

Page 116: ...s dialog Clicking a row in the Properties dialog will display the explanation of the information column at the bottom of the dialog For more information see 4 6 Properties dialog 7 Lists explains how to sort events by different data fields and search them using different criteria Event_log jpg Figure 7 4 1 1 Event log Description Column heading For descriptions of common list boxes e g Search and ...

Page 117: ...ing to the variable s type when the status is OK and a status icon in other cases You can remove the variable from current value processing and give it a new current value To define a floating point variable move the slider to the required value or enter a figure in the box For binary variables select a value from the list Click to open the variable s Properties dialog Display Status_window_analog...

Page 118: ...ent value If binary variables the binary state as text Value The engineering unit of the value in the database Unit Indicator of the direction of change The arrow indicates the direction of the latest change in the current value of the floating point variable Increasing value Decreasing value Unchanged value The new value of the floating point variable indicated by the slider You can provide a new...

Page 119: ...e variable s current value Opening the Status Window Menu_open_status_window_from_list jpg Figure 8 4 Opening the status window Right click any other column than the current value or the alarm list variable column on the variable s row in the variable list or chart window legend Select Send To and then Status Window OR Menu_open_status_window_from_current_value jpg Figure 8 5 Opening the status wi...

Page 120: ...pens the Properties window of a selected variable Properties Setting the value of a process variable or a calculated variable 1 Remove the variable from current value processing in the Current value processing checkbox 2 Select a new value for the floating point variables by using the slider or by entering a new value in the box If binary variables select a new value from the list 3 Set the value ...

Page 121: ...a chart window defined for the variable which displays the variable s plot A variable can have several default trends that retrieve the information for plots from different time levels for example from the current value or one minute average value history Default trend Default_trend_display jpg Figure 9 1 Default trend display 121 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manu...

Page 122: ...le column on the variable s row in the variable list or the legend in the chart window 2 Select Send to and the required default trend OR Right click a current value value symbol or column in the process diagram and then select the desired default trend Do not replace the default trend so that the original default trend is not lost 122 1MRS756739 COM600 series Version 5 0 Data Historian Operator s...

Page 123: ...emplate based chart window 1 Using an appropriate template create a chart window in the tree s folder and open it 2 Open the variable list or another chart window that displays the variable rows in its legend the two methods lead to slightly different results 3 Drag the required variables from the variable list or from the legend of the chart window to the legend or chart of the new window For mor...

Page 124: ...e row from a legend of another chart window In terms of the determination of plot configurations these two methods differ in the following way When you drag variables from the variable list the graph definitions comply with the template defaults and the graph color with the order of addition When you drag variable rows from another chart window the graph definitions comply with the original graph ...

Page 125: ...riables_from_list jpg Figure 10 1 2 Adding graphs from a variable list 5 Add the rest of the graphs in the same way The graph definitions comply with the default settings of the template New_variables_from_list jpg Figure 10 1 3 Adding new variables from list Adding graphs from the legend of the chart window 1 Open the chart window where the properties of the graphs are displayed in the legend row...

Page 126: ...ng graphs from the legend of the chart window 3 Add the rest of the graphs in the same way You can also add graphs from several chart windows The definitions of the added graphs for example the color and the table if the table has been identified the default table is changed where the history 126 1MRS756739 COM600 series Version 5 0 Data Historian Operator s Manual ...

Page 127: ...fferent_time_span_chart_window jpg Figure 10 1 5 Adding new variables If you want to change the properties of the graphs added to the chart of the new window such as the colors and graph styles do this in the chart s Properties dialog 4 Save the chart window when prompted to save changes 127 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 128: ... application either manually using a bat file or automatically by setting the Windows task scheduler to take an automatc backup at certain intervals You can take a manual backup by using the COM600RTDBBackup bat script The script is located at C Program Files COM610 GW SW Common bin folder in the COM600 computer Note that you need admin rights to the computer run the script and perform the backup ...

Page 129: ...d prompt window To make the backup automatic you can set the Windows task scheduler to automatically perform the backup function at certain intervals The task is named COM600 COM600RTDBBackup in the Windows task scheduler It is disabled by default When enabled the task launches the COM600RTDBBackup bat script with the intended backup location as the input parameter To automatically backup Data His...

Page 130: ...igger entry to setup time interval for task execution and click Ok Make sure to check the Enabled check box to enable the task Data_Hist_Edit_Trigger png Figure 11 2 2 7 To edit the backup location for the task choose the COM600RTDBBackup Properties dialog and select the Actions tab 8 Double click on Start a Program action item to launch the Edit Action dialog 130 1MRS756739 COM600 series Version ...

Page 131: ...ring Data historian backup 11 3 To restore Data historian backup 1 Log into the COM600 computer operating system 2 Open the command prompt window Start Run cmd 3 Stop the Data historian services with command APP_STOP_RTDB 4 In Windows Explorer delete or rename the existing C RTDB Backup Onlinecopy directory 5 Copy the backed up Onlinecopy subdirectory from the backup media to directory C RTDB Back...

Page 132: ...132 ...

Page 133: ...ting buttons 26 editing buttons 26 D database logging on 13 default trend description 121 display 121 opening 122 F filter functionality 64 folder closing 28 opening 28 I icons chart item icons 42 other Vtrin icons 43 pointer icons 43 status icons 41 tree icons 39 variable icons 40 L legend calculated trend 69 133 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 134: ...4 description 47 graph values 49 pop up menu items 48 summary values 50 trend values 51 zooming in 53 zooming out 54 Properties dialog 32 33 closing 33 detaching 34 enlarging 34 opening 33 reducing 34 reducing into icons 34 S scaling limits description 69 limit scales 70 status colors 41 status icons 41 status window description 117 display 117 opening 119 setting variable values 120 134 1MRS75673...

Page 135: ...dow 27 closing 33 detaching 34 enlarging 34 opening 33 reducing 34 reducing into icons 34 V variable icons 40 variable list 110 viewing horizontal leafs 36 windows 36 Vtrin charts 45 custom toolbar 25 logging off 15 status bar 27 toolbar 24 user interface 15 user interface elements 20 W window area 35 135 COM600 series Version 5 0 1MRS756739 Data Historian Operator s Manual ...

Page 136: ...136 ...

Page 137: ......

Page 138: ......

Page 139: ......

Page 140: ...10 22 11 Fax 358 10 224 1094 ABB Inc Medium Voltage Products 655 Century Point Lake Mary FL 32746 USA Tel 1 407 732 2000 Fax 1 407 732 2335 www abb com medium voltage 1MRS756739 F 24 5 2017 Copyright 2017 ABB All rights reserved Specifications subject to change without notice ...

Reviews: