hit counter script
ABB COM600 series Data Historian Operator's Manual
  1. Manuals
  2. Brands
  3. ABB Manuals
  4. Controller
  5. COM600 series
  6. Data historian operator's manual
ABB COM600 series Data Historian Operator's Manual

ABB COM600 series Data Historian Operator's Manual

Distribution automation controller
Hide thumbs Also See for COM600 series:
Table of Contents

Advertisement

Quick Links

Download this manual See also: Configuration Manual, Operator's Manual
—
COM600 series, Version 5.0
Data Historian Operator's Manual

Advertisement

Table of Contents
loading

Related Manuals for ABB COM600 series

Summary of Contents for ABB COM600 series

  • Page 1 — COM600 series, Version 5.0 Data Historian Operator's Manual...

  • Page 3: Table Of Contents

    1MRS756739 COM600 series, Version 5.0 Issued: 13.2.2009 Data Historian Operator's Manual Version: F/24.5.2017 Contents: About this manual .................. 7 1.1. Copyrights ..................7 1.2. Trademarks ..................7 1.3. General information ............... 7 1.4. Document conventions ..............8 1.5. Use of symbols ................8 1.6.
  • Page 4 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 5.1. Plot area ..................47 5.1.1. Viewing the value of the graph in the tool tip box ..49 5.1.2. Viewing summary values ..........50 5.1.3. Viewing trend values ............. 51 5.1.4.
  • Page 5 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 11.1. Taking 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...

  • Page 7: About This Manual

    In no event shall ABB Oy be liable for direct, indirect, special, incidental or consequential damages of any nature or kind arising from the use of this document, nor shall ABB Oy be liable for incidental or consequential damages arising from use of any software or hardware described in this document.

  • Page 8: Document Conventions

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 1.4. Document conventions The following conventions are used for the presentation of material: • The words in names of screen elements (for example, the title in the title bar of a window, the label for a field of a dialog box) are initially capitalized.

  • Page 9: Terminology

    Terminology The following is a list of terms associated with COM600 that you should be familiar with. The list contains terms that are unique to ABB or have a usage or definition that is different from standard industry usage. Term...

  • Page 10: Abbreviations

    A communication protocol developed by Echelon. LON Application Guideline for A proprietary method of ABB on top of the standard LON pro- substation automation; LAG tocol. Series of standards specifications aiming at open connectivity in industrial automation and the enterprise systems that support industry.

  • Page 11: Document Revisions

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Name of the manual MRS number COM600 HMI Configuration Manual 1MRS756740 1.9. Document revisions Document version/date Product revision History A/13.2.2009 Document created B/06.11.2009 Document revised C/30.6.2011 Document revised D/31.5.2012 Document revised E/13.3.2015...

  • Page 12: Introduction

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Introduction 2.1. Overview of COM600 COM600 provides gateway functions for mapping signals between protection and control IEDs in industrial or utility substations and higher-level systems. It further includes an optional WebHMI that provides data and information from the substation to the users.

  • Page 13: Getting Started With Com600 Data Historian

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Getting started with COM600 Data historian The COM600 data historian is a relational database designed and optimized for process information management and extensive history recording. Vtrin is a user interface client that connects to RTDB database (cpmPlus History database) in the COM600 computer.
  • Page 14 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Security_warning.jpg Figure 3.1-1 Security warning dialog The logon window opens: Vtrin_login.png Figure 3.1-2 Log On to Database dialog 3. In the Location drop-down menu, select the RTDB-COM600 you want to connect to.

  • Page 15: Logging Off From Vtrin

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 3.2. Logging off from Vtrin 1. Click Vtrin's title bar OR select Exit from the Database menu. 2. When logging off from Vtrin, you are prompted to save the changes in each open window.
  • Page 16 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Workspace.png Figure 3.3-1 Vtrin workspace for a normal Vtrin user The administrator'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...

  • Page 17: Quick Start For Creating Trend Views

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual WorkspaceAdminView.png Figure 3.3-2 Vtrin workspace for a Vtrin administrator user Detailed information about the Vtrin user interface is found later in the following chapters of this manual. 3.4. Quick start for creating trend views To create a new trend view: Right-click User’s Definitions in the tree view and select New Tree Item ->...
  • Page 18 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual The variable list opens with the variables (such as process measurements), which have been configured with SAB600 for the Data historian function. 5. Drag and drop variables from the list to the trend view.

  • Page 19: History Collection Cycles And Lengths

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual tree. Administrator users can create objects to other levels as well. For example, to create a trend view available for all users, the administrator user can create it below the root object in the tree.

  • Page 20: Vtrin Workspace

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Vtrin workspace The following table lists the elements in the Vtrin user interface. Table 4-1 Vtrin user interface elements Title bar Window's heading Menu bar See 4.1, Menu bar Tree window See 4.5, Tree window and 4.7, Tree window and the Properties...

  • Page 21: Database Menu

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 4.1.1. Database menu Menu_database.jpg Figure 4.1.1-1 Database menu Table 4.1.1-1 Database menu items Item Description Connect to... Opens a connection to another database. Displays a logon window as described in 3.1, Logging on/connecting to the database.

  • Page 22: View Menu

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 4.1.2. View menu View_menu.jpg Figure 4.1.2-1 View menu Table 4.1.2-1 View menu items Item Description Toolbar Displays the toolbar by default under the menu bar, see 4.2, Toolbar. Selected by default.

  • Page 23: Window Menu

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 4.1.3. Window menu The commands in the Window menu affect the active window in the window area. See also 4.9, Window area. Only the commands available for the active window are displayed in bold.

  • Page 24: Toolbar

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual About_vtrin.jpg Figure 4.1.4-2 About Vtrin dialog 4.2. Toolbar By default, the Vtrin toolbar is located below the menu bar. Row_toolbar.jpg Figure 4.2-1 Vtrin toolbar Table 4.2-1 Toolbar elements Button Description Steps backward through the window call path, activating the previ- ous window.

  • Page 25: Custom Toolbar

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Button Description Changes the display to design mode. Designer Mode Not yet supported. Data Playback Opens the Print dialog that allows you to print the content of the active window to the selected printer. For further information, see Windows help.
  • Page 26 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Toolbarbutton_collection_editor.jpg Figure 4.3-2 Toolbar button collection editor Table 4.3-1 Toolbar button collection Members The buttons that have been defined to belong to the custom tool- bar. The buttons are listed from left to right.

  • Page 27: Status Bar

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 4.4. Status bar The status bar is displayed at the bottom of Vtrin. Row_status_bar.jpg Figure 4.4-1 Status bar It indicates the status of Vtrin (not yet supported) and time. The time on the user’s PC is indicated by the ( ) icon and the time on the server by the ( ) icon at the right-hand end of the bar.
  • Page 28 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Opening folders and windows To make the tree fully visible: • If the tree is not fully visible, open it by clicking next to the database icon by clicking the icon or name of the database.

  • Page 29: Setting The Root Of The Tree Window

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Rename Opens up the window name field for editing. Changing the name of the window in the tree changes also the name visible in the window tab. In case of a trend, the default title of the trend is also changed.

  • Page 30: Searching In The Tree Window

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Tree_folder_menu_set_as_root.jpg Figure 4.5.1-1 Setting content as root of the tree window Menu item Description Set as Root Sets the folder to act as a root of the tree. Only the contents of the folder are left visible.
  • Page 31 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Tree_search_tes.jpg Figure 4.5-1 Searching in the Tree window Any item names matching the search criteria are left visible in the Tree window, while others are hidden. Entering a longer or a more descriptive search phrase narrows down the visible items even more.

  • Page 32: Properties Dialog

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual "t" or "T" somewhere in the item name. Also, the search phrase "Trend - avg" returns different results from "avg - Trend". This is because the whole search phrase is searched for, not a name containing all the words in the search phrase.

  • Page 33: Searching In The Properties Dialog

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Clicking the buttons at the top of the dialog allows you to select or deselect a data display option. When an option is selected the button is displayed in white (for example,...
  • Page 34 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual • Click the Close button in the title bar. Enlarging and reducing the Tree window and the Properties dialog • Click in the title bar if you want the window to cover the area of both the Tree window and the Properties dialog.

  • Page 35: Browsing The Tree Window History

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual If the window does not open as shown in the following figure, widen the Vtrin on the screen. To position the window back on the bar, click anywhere outside the window.

  • Page 36: Adjusting Window Placement And Docking

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Window_area.jpg Figure 4.9-1 Window area Click the selected tab to activate a window and to display it on top. 4.9.1. Adjusting window placement and docking If you want to view more than one window at a time, you can position the windows in several horizontal or vertical tabs.
  • Page 37 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual To move the active window to a new tab of horizontal (vertical) leaf using the Window menu: • Select Move to a New Horizontal Leaf (Move to a New Vertical Leaf) from the Window menu.

  • Page 38: Changing Window Placement With Drag And Drop

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Menu item Description Move To Next Tab Group Moves the window to the next tab group. If there are no more windows left in the former tab group, it will be dismissed.

  • Page 39: Icons

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Window_docking_helper_center.jpg Figure 4.9.2-2 Dropping the window to the center of the docking helper If dropped to the center area of the docking helper, the dragged window consumes the whole target window area and the replaced window is hidden under a tab.
  • Page 40 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Table 4.10-1 Tree icons Icon Description Equipment Model Maintenance Report History History of current values Stored procedures Table, List System Configuration SQL view Column chart Trend chart Process diagram Variable list...
  • Page 41 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Icon Description Text Variable The status icons and colors indicate the status of the variable's current value. The follow- ing table lists the icons and colors, as well as the icons depicting the direction of values.
  • Page 42 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Table 4.10-4 Chart item icons Icon Description Icon for line plots. The color of the symbol in the icon corresponds to that of the plot and/or data point markers. The data point marker color is selectable.
  • Page 43 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Icon Description Shows that an error occurred when fetching chart item data. Error indicator The following table lists other icons used in Vtrin. Table 4.10-5 Other icons Icon Description Vtrin User's PC...
  • Page 44 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Icon Description Pointer displayed when you change the size of different areas on the screen.

  • Page 45: Charts

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Charts The graphical information in Vtrin displays is shown in charts. Charts can contain various graphical elements, such as pictures, graphs, plots, value controls, and text blocks. This chapter describes various properties of the chart display on a trend display template.
  • Page 46 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Chart window Chart_Window.jpg Figure 5-1 Chart window Chart window terms Description The text displays the name of the chart. Plot area See 5.1, Plot area. Chart title The default title of the chart window is the name that the chart has in the tree.

  • Page 47: Plot Area

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Chart window terms Description Current date and time Upper scaling limits See 5.3, Scaling limits. Scaling limits See 5.3, Scaling limits. Lower scaling limits See 5.3, Scaling limits. Locked pin See 5.4, Time bar.
  • Page 48 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual To view the values of the graph, place the pointer over the graph. The tool tip box shows the value, time stamp, and status of the data point closest to the left of the pointer (See 5.1.1, Viewing the value of the graph in the tool tip box).

  • Page 49: Viewing The Value Of The Graph In The Tool Tip Box

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual To List Changes the chart from a graph to a list format. See 5.1.7, Converting chart to list or graph. To Graph Changes the chart from a list to a graph format. See 5.1.7, Converting chart to list or graph.

  • Page 50: Viewing Summary Values

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 5.1.2. Viewing summary values Tooltip_summary_in_trend_2.jpg Figure 5.1.2-1 Tool tip summary in trend Click the mouse at the desired location in the plot area. A turquoise vertical trend value line 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.

  • Page 51: Viewing Trend Values

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Item Description Average Average during the time span between the start and end time. Deviation Deviation during the time span between the start and end time. 5.1.3. Viewing trend values 1. Place the pointer in the plot area and move it so that the vertical line of the crosshair pointer (assuming that the crosshair has been selected in the chart window) is in the spot you want to see.
  • Page 52 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 2. Click on the chart to select time. Turquoise vertical line appears indicating the selection. 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.

  • Page 53: Zooming In

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Table 5.1.3-1 Display items Item Description Trend value line The trend value line shows the values corres- ponding to the selected time. Pointed time The column shows the values corresponding to the selected time.

  • Page 54: Zooming Out

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Zoom_out.jpg Figure 5.1.4-2 Zoom out 5.1.5. Zooming out 1. Right-click in the plot area and select Zoom Out. 2. The Zoom Out command can be selected as long as the number of zooms in com- mands is larger than the number of zoom out commands.

  • Page 55: Converting Chart To List Or Graph

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Table 5.1.6-1 Clipboard actions Action Description Copy Data to Clipboard The Copy Data to Clipboard dialog is displayed with chart pop- up menu. Averages Picks the average values of the chosen intervals.

  • Page 56: Legend

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual List_display.jpg Figure 5.1.7-2 From list to chart display To Graph: When in a list format, the To List -command is replaced by a To Graph - command. It converts the chart back into a graphic format.
  • Page 57 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual The legend can be configured to display a variety of information on the variables, such • variable names • aliases • • descriptions • current values • units of current values •...

  • Page 58: Pop-Up Menu

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual To edit a variable column: • Select the variables in the column as instructed earlier. An arrow indicating a drop- down menu appears in the last row selected. • Click the arrow to open the drop-down menu.
  • Page 59 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Item Description Remove... Removes the chart items whose rows you clicked from the plot area and from the legend in question. Legend Columns... Opens the Legend Columns dialog, where you can define the data to display in the column and its order.
  • Page 60 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 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 •...

  • Page 61: Legend Columns

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Color information (Item color / Item secondary color / Chart background color) The three color boxes show the following information (from left to right): • Item color: the color in which the selected item is presented in the chart.
  • Page 62 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual the variable data is retrieved. As the column headings are often the same, an additional attribute related to the heading is used to specify the data source as follows: Table 5.2.2-1 Abbreviations used in the legend column headers...
  • Page 63 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Column header Description Pointer value If trend values have been requested for the chart, the time pointed to is displayed in the column heading and the column’s rows show the corres- ponding calculated values.

  • Page 64: Using The Filter Functionality

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Button Description You can drag the legend’s items (rows) to change their order. This also changes the order of curves in the plot. This is useful, for example, if the plot of a variable you want to view is behind other plots.
  • Page 65 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual ADEV Arithmetic Deviation ADEVP Arithmetic Deviation of Entire Population AMEDIAN Arithmetic Median AMODE Arithmetic Mode AVARIANCE Arithmetic Variance AVARIANCEP Arithmetic Variance of Entire Population Time Weighted Average AVGRAW Raw Time Weighted Average - ignoring the invalidity of values CALC User Defined Calculation.
  • Page 66 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual MINPT Minimum Value of a Period, TimeStamp is the Period Time OPTIME Operating Time. Requires a parameter, e.g. OPTIME10MIN(>5) calculates the time the value has been greater than 5. PERG Percent of Good Samples (0-1)
  • Page 67 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Time identifier Description MON, MONTH, Months, local time MONTHS MON_UTC, Months, UTC time MONTH_UTC, MONTHS_UTC Y, YEAR, YEARS Years, local time Y_UTC, Years, UTC time YEAR_UTC, YEARS_UTC PL, PLEN, PERI- Source data period lengths. E.g. if the source data is AVG5MIN, AVG2PLEN...
  • Page 68 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual • rem(x, y) = returns the remainder of x divided by y • round(x) = rounds x to closest integer value • rounda(x, y) = rounds x to y decimals, away from zero •...

  • Page 69: Scaling Limits

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Calculated Trend Calculated_value.jpg Figure 5-1 Calculated value You can create new variable items that are calculated from the data of the existing vari- ables. In our example, variable H is the sum of A and C.
  • Page 70 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual The graphs in the chart window can have either common or individual limits. For explanations, see Table 5.3-1. Individual and common scaling limits can be changed by using boxes or at the ends of the scales.
  • Page 71 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Field Description Common limit The common upper scaling limit is the highest upper limit, while the common lower scaling limit is the smallest lower limit. Common limits are only displayed if they are used in one of the graphs and if no individual limits have been defined for the plot.
  • Page 72 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Trend_scaling_limits_3_variables.jpg Figure 5.3-2 Chart with three graphs The following figure shows a chart with two graphs. The scales are now visualized 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.

  • Page 73: Time Bar

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 5.4. Time bar The time bar allows you to select the time range for displaying the plots of the variables. Description of time bar The time bar is displayed under the plot area. It shows the start time of the time span at the left end of the row and the end time at the right.
  • Page 74 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual The time next to the pin is unlocked The time next to the pin is locked The display's update mode is determined in the following way, depending on the left and right pin: Normally updated display.

  • Page 75: Time Scroll Bar

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Button Description Free start or end time that cannot be changed. Start time You can change the locked start or end time to view the graph at different times and to use a longer or shorter time span.

  • Page 76: Time Scale

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Time scroll bar Time_scroll_bar_row.jpg Figure 5.5-1 Time scroll bar The following table lists the Time scroll bar buttons Table 5.5-1 Time scroll bar buttons Button Description The time span for which the curves are displayed moves backwards or forwards in time when you move the scroll box.
  • Page 77 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Time_scale_whole_2.jpg Figure 5.6-1 Time scale • Start time shows the earliest time the chart shows. • The drop-down menus show the numerical value and the time span unit selected for the time span. You can change either the numerical value or the unit from the menus.

  • Page 78: History Updating And Recollection

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual • Select the desired option by clicking its row. If the selected numerical value does not match exactly with the selected unit, the numerical value is rounded to a matching value closest to the original.
  • Page 79 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual selected time span as the default values. You see them in the value boxes next to the time span start and end times. • If you change your selection, the value boxes show new default values.
  • Page 80 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual • If you want to change the values, enter new values in the value boxes. • Clear the values from the value boxes, if you want to remove the history values.
  • Page 81 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Updating non-periodic history values Update or delete operation inserts new data points immediately before (-100ns) the start time and immediately after (+100ns) the end time of the time span and assigns them to the original values at those time positions, and then removes values that the time span covers.
  • Page 82 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual The effect of the history update is seen as a straight line from the start value to the end value and as the additional value points just before and after the selected time span.
  • Page 83 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual corresponding time are shown in the time bar. In this case the update function replaces or deletes the value, which is in the beginning of the highlighted area. Updating periodic history values The update procedure for values in periodic type history tables is slightly different from the updating of a non-periodic table.
  • Page 84 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual If start and end values are different, 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...
  • Page 85 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual If start and end values are equal, the update function produces a value only 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...
  • Page 86 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual If a value is deleted, the update function removes the values covered by the time span. AverageTrendAfterDeletion.jpg Figure 5.7.1-9 An average value table after deletion...
  • Page 87 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual The following figure shows an 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...
  • Page 88 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual In case of sum of the values, the update function produces equal values every time period covered by the time span. SumTrendAfterUpdating.jpg Figure 5.7.1-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).
  • Page 89 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual combination takes values primarily from 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...

  • Page 90: Scenario Operations

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Updating the combined trend always changes the values in the scenario table, as shown in the following figure. Deletion removes the values from the scenario table as well. ScenarioTrendAfterUpdating.jpg Figure 5.7.1-13 Scenario table after updating 5.7.2.
  • Page 91 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual The full scenario table name for this example according to this rule is: ‘HT_SC123’. There is also a separate table ‘Scenarios’ for scenario handling in the system. This table connects the scenario number to the scenario name which is shown on the legend rows and related dialog boxes.
  • Page 92 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual ScenarioClearing.jpg Figure 5.7.2-2 Scenario clearing operation Scenario commitment This operation combines data from the 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.
  • Page 93 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Copy to Scenario This operation copies all rows of all variables within the time span from the base table to the scenario table. The original data in the scenario table is removed before copying.

  • Page 94: History Update Log

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 5.7.3. History Update Log Each update and deletion or scenario operation generates a new row to the History Update Log table. A row contains information about the target table and variable, updating time, time span and corresponding values, and what was the updating operation.
  • Page 95 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Click Recalculate on the menu to open the History recalculation activation dialog: HistoryRecalculationActivation.jpg Figure 5.7.4-2 The History recalculation activation dialog • Select the history table from where (selected table included) the recollection is activated.

  • Page 96: Process Diagrams

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Process diagrams Process diagrams present current and history values refreshed in the process-specific background as values, columns, symbols, or plots. Process diagrams are displayed in chart windows. Description of process diagrams Process diagram windows are usually located in the application-specific folders of the tree.

  • Page 97: Sub-Diagrams

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Example_process_diagram.jpg Figure 6-1 Sample process diagram 6.1. Sub-diagrams G_sub_diagram.jpg Figure 6.1-1 Sub-diagram Sub-diagrams can contain a background, a refreshed line, and area plots or column series on top of it. The direction of time of the series can be defined right, down, up, or left.

  • Page 98: History Values

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual a current value with a flash. The icon can be displayed at all times or only when the status is not OK. Current_value_and_tooltip.jpg Figure 6.2-1 Current value Pointing to the value displays a ToolTip. The ToolTip shows the description (or updated text) of the variable, the growth direction of the value (+/=/), the current value unit, time stamp, status, and short trend.

  • Page 99: Symbols

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Bar_graph_and_tooltip.jpg Figure 6.4-1 Bar with current history and variable of the value Pointing to the bar displays a ToolTip. The ToolTip shows the description (or updated text) of the variable, the growth direction of the value (+/=/), the current value unit, time stamp, and status.

  • Page 100: Links

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 6.6. Links The name of the window link is displayed in blue and underlined, assuming the color and underlining settings of the link have not been changed. When you point to the link,...

  • Page 101: Lists

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Lists List windows show database data (attributes) in list format. Examples of lists include the variable list, alarm log, event log, maintenance log, and user log. Basically all lists are viewed in the same way. Some lists, however, can contain more properties than others.
  • Page 102 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Menu_list_column.jpg Figure 7-1 List menu Table 7-1 List menu items Item Description Primary Sort The items are first sorted by the column you clicked to display the pop-up menu. Select an ascending or descending order. A triangle and the number 1 ( ) is displayed in the column.
  • Page 103 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Item Description Properties Displays the Properties dialog, where you can change the appearance and functions of the list. You can view and, with sufficient authorizations, change (in Edit mode) item data directly in the list or in the general Properties dialog by clicking the item.
  • Page 104 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Icon Description Alphabetical order Click the Alphabetical order button to turn alphabetical order on/off. When alphabetical order is on, the information is shown in an alphabetical order, from a to z.

  • Page 105: List Screen

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual 7.1. List screen Sample list view Example_list_small.jpg Figure 7.1-1 Sample list view Table 7.1-1 List view fields and activation buttons Field / button Description Row Numbers The row numbers are optionally shown in the beginning of the row.
  • Page 106 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Field / button Description A text selection box for text and figure columns. Enter a string mask like the one used in the Search bar in the text box. Advanced Search bar...
  • Page 107 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Field / button Description Click the right side of the column heading with the pointer to change the column width to accommodate the longest text in the column. Changing the order of columns You can change the order of columns by clicking a column heading and then moving the column either to the right or the left in the table.
  • Page 108 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual • Click the same column again if you want to sort the items in reverse order ( ). Sorting the list items using a popup menu • The primary sort (default sort) is always selected in the list. If you want to sort the items by more than one column, select the following columns in numerical order - first the Secondary Sort, then the Tertiary Sort option, and so on.
  • Page 109 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Different criteria on search and advanced search bars: • Search bar: Defines the string mask that is compared with the texts in all columns. The string mask can consist of several query strings.

  • Page 110: Variable List

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual the search bar are combined with an AND operator, that is, the displayed items must meet all the criteria listed in 7.1, List screen To use the search and advanced search bars: 1.

  • Page 111: Event And Alarm Tables

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual The information displayed in the list depends on the customer. To view the meaning of columns, click the variable in any column of the list (the current value column does not open).

  • Page 112: Alarm And Event Lists

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual and alarm acknowledgement information. Alarm table printouts are described in 7.4, Alarm and event lists. • Event table displays the system events that do not have variables in the database. In this case, the event row contains all the information available to the user. Event table printouts are described in 7.4.1, Event log.
  • Page 113 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual • Process area (grouping variables by process area) • Variable-specific identifications You can sort the alarms/events shown in the list based on the following criteria (see Chapter 7, Lists for more information on how to sort the alarms by different data fields and search them using different criteria): •...
  • Page 114 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Table 7.4-1 Available alarm and event list columns Alarm and event list Description columns For descriptions of common list boxes (e.g. Search and Advanced Search Bar, see 7.1, List screen. Column headings The descriptions of column headings are displayed at the bottom of the Properties dialog.

  • Page 115: Event Log

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Alarm and event list Description columns Variable identification The variable is identified in the row with the following information: data • Variable • Description • Unit • Area • Process •...
  • Page 116 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Description of event log Open the event log in the tree. You can create your own event logs by editing the basic event log and place them anywhere in the tree. The default event log, however, will remain in the Maintenance folder.

  • Page 117: Status Window

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Status window The variable's Status window displays the current value of the selected database variable. You can also remove the variable from current value processing in the Status window and replace the variable with a different value.
  • Page 118 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual t_sum.jpg Figure 8-3 T_SUM status Table 8-1 T_SUM status fields Field Description Type icon A variable-type icon on the left of the title bar, if the variable’s status is Status icon Icon representing the variable’s status.
  • Page 119 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Field Description Status icons The variable’s valid states are displayed at the bottom of the window using colored icons. Status icons are described in 4.10, Icons. Table 8-2 T_SUM activation buttons...
  • Page 120 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Table 8-1 Status window items Item Description Send To Opens a variable specific pop-up menu from which you can select a display type. Status Window The status window of a selected variable.

  • Page 121: Default Trends

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Default trends The variable's default trend enables you to, for example, use the variable list to open a chart window displaying the variable's plot. Description of default trends The default trend is a chart window defined for the variable, which displays the variable's plot.

  • Page 122: Opening A Default Trend

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 9.1. Opening a default trend Menu_open_status_window_from_list.jpg Figure 9.1-1 Opening a default trend To open a default trend: 1. Right-click any column other than the current value or the alarm list variable column on the variable's row in the variable list or the legend in the chart window.

  • Page 123: Templates

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Templates A template contains certain properties and the layout of a chart window. Using the appropriate template to create a chart window enables you to quickly create a functional window complying with the agreed standard by simply adding the required graphs.

  • Page 124: Creating A Chart Window Using A Template

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 10.1. Creating a chart window using a template Right-click the tree's folder in which you want to create a chart window. Select New Tree Item and the required template. Menu_open_new_tree_item.jpg Figure 10.1-1 Creating a chart window using a template Table 10.1-1 Templates...
  • Page 125 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual In the variable list, locate the variables that you want to add to the chart. The easiest way to find variables is by using search criteria in the search bar and in the selection boxes.
  • Page 126 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 2. Drag the variable row from the chart window's legend to the legend or the graph area of the new chart window. New_variables_from_chart_window.jpg Figure 10.1-4 Adding graphs from the legend of the chart window 3.
  • Page 127 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual values are retrieved from) is like those of the chart they originated from. The addition of graphs does not affect the chart window interval. New_variables_from_different_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.

  • Page 128: Data Historian Backup And Restore Functions

    COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual Data historian backup and restore functions 11.1. Taking a backup of the Data historian Ensure that the actions below are done from administrator command prompt. To backup Data historian : 1. Log into the COM600 computer operating system.
  • Page 129 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual To manually backup Data Historian application: 1. Log into the COM600 computer operating system. 2. Open the Command Prompt by choosing Start>Run>cmd. Make sure that you have logged in as an administrator.
  • Page 130 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual 4. Right click the COM600RTDBBackup task and select Properties to enable the task and set the time interval for task execution. 5. In the following COM600RTDBBackup Properties dialog, select the Triggers tab.

  • Page 131: Restoring Data Historian Backup

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Data_Hist_Edit_Action.png Figure 11.2-3 9. Edit the textbox for Add arguments (optional) to change the intended backup location. Then click Ok. 10. Click Ok in the COM600RTDBBackup Properties to confirm the changes made to the properties of the task.

  • Page 133: Index

    1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual Index charts ........................ 45 description ..................... 45 window ......................46 COM600 data historian ..................13 connecting to database ..................13 creating trend views tree view ......................17 Variables list ....................18 custom toolbar adding buttons ....................
  • Page 134 COM600 series, Version 5.0 1MRS756739 Data Historian Operator's Manual columns ......................61 description ..................... 56 lists changing order of columns ................107 description ....................101 list view ......................105 searching items .................... 108 sorting items ..................107–108 variable list ....................110 logging on to database ..................
  • Page 135 1MRS756739 COM600 series, Version 5.0 Data Historian Operator's Manual templates ......................123 creating chart window ................... 124 using ......................123 time bar buttons ......................74 description ..................... 73 time scale description ..................... 76 setting ......................77 time scroll bar buttons ......................76 description .....................
  • Page 140 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.

Table of Contents