Historical Fault Browser WMS
Historical Fault Browser WMS
Historical Fault Browser WMS
Title page
Alcatel-Lucent 9353
Wireless Management System | UA08.1
Historical Fault Browser
411-5221-210
Issue 13.08 | April 2013
Alcatel-Lucent Proprietary
Use pursuant to applicable agreements
Use pursuant to applicable agreements
Legal notice
Legal notice
Alcatel, Lucent, Alcatel-Lucent and the Alcatel-Lucent logo are trademarks of Alcatel-Lucent. All other trademarks are the property of their respective
owners.
The information presented is subject to change without notice. Alcatel-Lucent assumes no responsibility for inaccuracies contained herein.
Copyright 2013 Alcatel-Lucent. All rights reserved.
Contains proprietary/trade secret information which is the property of Alcatel-Lucent and must not be made available to, or copied or used by anyone outside
Alcatel-Lucent without its written authorization.
Not to be used or disclosed except in accordance with applicable agreements.
Trademarks
Sun, Sun Microsystems, the Sun Logo, Solaris, and JRE are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other
countries.
Microsoft and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
Oracle is a trademark of Oracle Corporation.
Alcatel-Lucent Proprietary
Use pursuant to applicable agreements
Contents
2 HFB operation
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary iii
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Contents
....................................................................................................................................................................................................................................
System requirements ................................................................................................................................................................ 2-7
2-7
Procedures
Generating alarm reports using the HFB WICL Editor ............................................................................................ 2-48
2-48
....................................................................................................................................................................................................................................
iv Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Contents
....................................................................................................................................................................................................................................
Procedures
Procedures
Index
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary v
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Contents
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
vi Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
List of tables
4-1 Default Oracle user IDs and password settings .............................................................................................. 4-3
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary vii
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
List of tables
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
viii Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
List of figures
2-22 Alarm report generated through the HFB query interface ....................................................................... 2-40
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary ix
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
List of figures
....................................................................................................................................................................................................................................
2-23 Alarm report with filter information ................................................................................................................ 2-41
....................................................................................................................................................................................................................................
x Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
About this document
About this document
Purpose
The purpose of this document is to explain the Historical Fault Browser (HFB), how it
works, and how to administer its related database.
...................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary xi
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
About this document
....................................................................................................................................................................................................................................
Modified Table 4-1, Default Oracle user IDs and password settings (p. 4-3)
Updated to comply with CRI00427311.01
Intended audience
The audience for this document is fault management personnel.
Supported systems
This document applies to Alcatel-Lucent W-CDMA UA08.1 system release.
This document applies to WMS.
Prerequisites
It is recommended that readers become familiar with Alcatel-Lucent W-CDMA System -
Access Network Management Overview, NN-20500-031.
Conventions used
Vocabulary conventions
None
Typographical conventions
The following typographical conventions are used in this document:
Appearance Description
italicized text File and directory names
Emphasized information
graphical user interface text Text that is displayed in a graphical user interface
or in a hardware label
variable A value that the user supplies
key name The name of a key on the keyboard
command-syntax Command names that the user types
input text None
output text None
IP reference, reference number Related document that is referenced in the
document
....................................................................................................................................................................................................................................
xii Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
About this document
....................................................................................................................................................................................................................................
Related information
For information on subjects related to the content of this document, refer to the
documents listed in the following table:
Document support
For support in using this or any other Alcatel-Lucent document, contact Alcatel-Lucent at
one of the following telephone numbers:
+1-888-582-3688 (for the United States)
+1-630-224-2485 (for all other countries)
Technical support
For technical support, contact your local Alcatel-Lucent customer support team. See the
Alcatel-Lucent Support web site (http://www.alcatel-lucent.com/support/) for contact
information.
How to order
To order Alcatel-Lucent documents, contact your local sales representative or use Online
Customer Support (OLCS) (http://support.alcatel-lucent.com)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary xiii
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
About this document
....................................................................................................................................................................................................................................
How to comment
To comment on this document, go to the Online Comment Form (http://infodoc.alcatel-
lucent.com/comments/) or e-mail your comments to the Comments Hotline
(comments@alcatel-lucent.com).
....................................................................................................................................................................................................................................
xiv Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
1 1oadmap to Fault
R
Management
documentation
Overview
Purpose
This chapter provides the roadmap for Fault Management documentation.
Contents
...................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 1-1
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Roadmap to Fault Management documentation Roadmap to Fault Management documentation
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
1-2 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
2 HFB operation
2
Overview
Purpose
The HFB is an optional software application that builds on the alarm management
functions of the Network Services Platform (NSP). The NSP alarm management tools
provide real-time alarm information for the Network Elements (NEs) they monitor. The
HFB provides a database of historical alarms for trend analysis.
There are instances when alarms are generated for NEs that are not fully enrolled by the
system. Although the HFB captures the alarms in such cases, but the corresponding NE
information is missed out. The HFB periodically updates these alarms with the missing
NE information.
This chapter provides an overview of the HFB application, its operation, and the
procedures.
Contents
...................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-1
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
2-2 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Overview
HFB operation overview
....................................................................................................................................................................................................................................
Overview
Purpose
This section provides detailed information on the following topics:
Features
Components
System requirements
Supported web browsers
HFB agent
Contents
Features 2-4
Components 2-5
System requirements 2-7
Supported web browsers 2-8
HFB agent 2-9
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-3
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Features
HFB operation overview
....................................................................................................................................................................................................................................
Features
Purpose
The HFB supports stored alarm events for all the managed NEs. It provides a central
storage and retrieval capability for network alarm events, and also alarm event filtering
and report generation capabilities.
The following alarm events are supported:
Raise alarm
Clear alarm
Acknowledge alarm
Unacknowledge alarm
Manual alarm clear
Notification ID change
The HFB retrieves alarm events, both raise and clear, from the network using the building
block architecture. It stores the alarm events in an Oracle Relational Database
Management System (RDBMS). The HFB GUI supports the search, display, and report
generation of the selected alarm event data from the database.
The HFB provides the following main features:
Generic alarm event history across managed NEs
Central storage of alarm event history in an Oracle RDBMS
Web-based Java application GUI for retrieving alarm event data with the following
features:
Sophisticated filtering support
Report generation capability for analysis and tracking purposes
....................................................................................................................................................................................................................................
2-4 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Components
HFB operation overview
....................................................................................................................................................................................................................................
Components
Purpose
The HFB consists of the following two separate component applications:
HFB agent
The HFB agent retrieves alarm event information from the Fault Management
Building Block (FMBB) and Topology Management Building Block (TUMSBB),
and stores the information in the Oracle database. The HFB agent takes advantage
of the open architecture to retrieve information about alarm events. The HFB
agent is a client of the FMBB and TUMSBB. It retrieves alarm event information
immediately after the addition of a new NE to the network.
HFB GUI
The HFB GUI is run on a supported web browser. It provides an option to search
for alarm events in the database and generate reports. This GUI uses the open
contract interface provided by the FMBB and TUMSBB to retrieve information
from the network. This interface is based on the Common Object Request Broker
Architecture (CORBA) Interface Definition Language (IDL). See, Figure 2-1,
HFB architecture (p. 2-6)
The HFB is a client of Oracle RDBMS. The alarm event information stored in the
database maps to the information provided by the FMBB and TUMSBB CORBA IDL
interfaces. The HFB communicates with the database through the database interface.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-5
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Components
HFB operation overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
2-6 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation System requirements
HFB operation overview
....................................................................................................................................................................................................................................
System requirements
Overview
The HFB is compatible with NSP and is deployed on the NSP server. Install NSP before
you install the HFB. Ensure that FMBB and TUMSBB are installed and run before the
HFB is installed. For information on the hardware and OS for the HFB, see
Alcatel-Lucent 9353 Wireless Management System - User Guide, NN-20500-032.
Note: The HFB 2.4 requires that the Oracle 9.2.0.5 RDBMS software, Enterprise
edition with the Partitioning Option be installed on the NSP server. Alcatel-Lucent has
tested and approved HFB with Oracle RDBMS software.
Applications developed using Oracle database capabilities supports the following
features:
Large database capacity of storing 60,480,000 alarms
Fast retrieval of alarm history information
Stable and reliable database environment, accepted globally.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-7
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Supported web browsers
HFB operation overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
2-8 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation HFB agent
HFB operation overview
....................................................................................................................................................................................................................................
HFB agent
Overview
The HFB agent retrieves alarm events from the managed network and stores in a
database. These alarm events include raise alarm, clear alarm, acknowledge alarm,
unacknowledge alarm, manual alarm clear, and notification ID change. The HFB agent
uses key attributes to connect the clear alarm events with original raise alarm events.
The HFB agent is a client of the FMBB and the TUMSBB. It operates only after the
FMBB and the TUMSBB are installed and run in the network.
The HFB agent connects to the FMBB to retrieve active and new alarms on a continuous
basis. It also connects to the TUMSBB to retrieve inventory data on NEs needed for
alarm events.
If either the HFB agent or the FMBB is down, a data resynchronization takes place after
communication is restored.
If the FMBB is down, it resynchronizes with its device adapters (DA) after the service is
restored. Once this task is complete it sends a message to the HFB agent announcing that
the HFB agent is ready to update its data.
If the HFB agent is down, it contacts the FMBB to obtain an up-to-date list of active
alarms after the service is restored.
In both the cases, any alarms that were cleared during the loss of communication causes a
discrepancy between the old list of active alarms stored by the HFB agent and the new list
of active alarms provided by the FMBB. As a result, the HFB agent clears these alarms
with the hfbmaster user ID and puts a timestamp with the server time where the HFB
agent is located.
If the incoming alarm events exceed the HFB agent capacity, the HFB agent discards and
logs them. Customize the HFB agent, if needed.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-9
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Overview
HFB user interface
....................................................................................................................................................................................................................................
Overview
Purpose
The HFB is a web-based java application that provides a flexible GUI to search for alarm
data in the database. The HFB client workstation supports IE 5.0 or later, Mozilla 1.4 web
browsers.
The HFB user interface does not support the web browser buttons for navigation.
It provides the tools for finding and viewing historical alarms.
The HFB interface allows to perform the following operations:
Build and save search criteria
Retrieve and view alarm records based on search criteria
View alarm details
Count alarm records
Generate alarm reports
Contents
....................................................................................................................................................................................................................................
2-10 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-11
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
The Select Retrieval Criteria window contains eight tabs for setting query statements.
Use each tab to define a query statement with a specific attribute type.
For detailed description of the attributes in each criteria tab, see the following sections:
Network panel (p. 2-13)
Status panel (p. 2-18)
Severity panel (p. 2-20)
Event Type panel (p. 2-21)
Probable Cause panel (p. 2-22)
Specific Problem panel (p. 2-23)
Date/Time panel (p. 2-23)
Threshold panel (p. 2-25)
Criteria Sets panel (p. 2-26)
By default, the Network panel is displayed when you open the Select Retrieval Criteria
page.
The bottom section of the Select Retrieval Criteria window contains the Selected
Retrieval Criteria List. The criteria list is built from query statements created in the
criteria tabs. The criteria are additive. The query statements are joined to form the search
criteria. The system uses the search criteria to filter data from the database and display
alarm records that meet the criteria.
Build a query statement using multiple values for the same attribute. The search criteria is
formed using Boolean AND and OR logical operators. See the attribute descriptions for
details on how a query statement is constructed.
Manage the Selected Retrieval Criteria List using Delete Selected and Reset to
Default. To delete an individual query statement, select it and click Delete Selected. To
clear all current query statements, click Reset to Default. This resets all panels to default
values and the Retrieval Criteria List displays the default Raised during the last two
hours query statement.
Click Count to determine how many records match your query. The number of matching
records is displayed along with the timestamp. Choose to modify or cancel your query, if
necessary.
If the Selected Retrieval Criteria List is empty, the system will count all of the alarm
records which were raised during the last two hours.
Use Save Criteria at any time to save a new set of retrieval criteria you have built, or to
update an existing criteria set. The Save Criteria Set page opens. Specify a unique file
name, not more than 40 characters, and save the criteria set to the database.
Click View Records to search the database for alarms that meet the criteria specified.
....................................................................................................................................................................................................................................
2-12 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Some browsers generate a security warning message when you perform an action that
requires interaction with the database server. Eliminate these messages by selecting the
appropriate box in the message dialog before continuing.
Click Export Report to perform the same database search as the one requested using
View Records. However, the output is saved to a file and the record number is limited to
10,000. See Alarm report generation (p. 2-38).
An In Progress dialog box appears as the system retrieves the query. The HFB times out
after 30 minutes of either idle or query time.
If the query is time consuming, click Cancel to prevent the system from timing out, and
then revise the query.
Terminate and restart the HFB GUI after a time out occurs. Although the session is
terminated after 30 minutes of idle or query time, the HFB system remains responsive
and a manual termination and restart is recommended.
For information about the mapping of the HFB database fields to equivalent fields
from the FMBB and the TUMSBB, the CORBA IDL, see Table 3-1, FMBB or
TUMSBB to HFB mapping (p. 3-8).
Note: Some fields do not apply to all domains. For more information, refer to the DA
documentation for your domain.
Network panel
Use the Network panel to add query statements to the Selected Retrieval Criteria List
based on the network attributes. See Table 2-1, Search by values in the Network panel
(p. 2-14). The attributes are available from a drop-down menu in the Search by field. A
second drop-down menu allows to define criteria based on partial values. See Table 2-2,
Operator values in the Network panel (p. 2-15).
Note: The Value field is case-sensitive.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-13
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
If you choose to define retrieval criteria based on the NE Id attribute, specify the domains
to search. See Multiple network domain search by NE ID (p. 2-17).
....................................................................................................................................................................................................................................
2-14 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Table 2-1 Search by values in the Network panel (continued)
Note 1:
Database query using NE Name is not possible when the database contains more than 14 million
alarms.
Note 2:
If the value exceeds the default sizes in the search panel, a saved query is not executed properly
by HFB.
Operator Meaning
Equals Is equal to the entered value (see Note)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-15
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Table 2-2 Operator values in the Network panel (continued)
Operator Meaning
Does not equal The entered value will not appear (see Note)
Contains Contains the entered value
Does not contain The entered value will not be part of the record
Starts with Starts with the entered value
Ends with Ends with the entered value
Note:
This function may not be supported if the database structure of any of the fields in Table 2-1,
Search by values in the Network panel (p. 2-14) is changed.
Build multiple query statements using the same alarm record field, but with different
operators or values:
If your query string uses the positive operators only such as Contains or Equals, the
system joins these multiple query statements with OR.
If your query string uses only the negative operators, Does not contain or Does not
equal, the query string is joined by AND.
If your query contains both positive and negative operators, the system groups the
positive queries with OR, the negative queries with AND, and then joins the two
groups using AND.
Ensure that an alarm event meets the criteria of at least one query statement for the
system to select it from the database.
Build multiple query statements with different alarm record fields. The system joins these
multiple query statements with a logical AND operator. Ensure that an alarm event meets
all of the criteria from each query statement for the system to select it from the database.
When you build query statements that include multiple statements with the same alarm
record field and some with different fields, the system groups all criteria items for the
same attribute so that they appear together. The criteria list is also sorted by positive
criteria followed by negative criteria, to produce the final alarm set. See Figure 2-4,
Retrieval Criteria list (p. 2-17) for an example of a retrieval criteria list sorted in this
way.
....................................................................................................................................................................................................................................
2-16 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
If you choose to restrict the search to selected domains by selecting OK, the Network
Domain Selection panel opens.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-17
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
This panel provides options to add all domains or selected domains. Click Add All
Domains to include all the domains listed in the search. Or, select one or more domains
listed and click Add Selected Domains.
In case of selecting domains, query statements are created to specify the selected
domains, as shown in this figure.
Status panel
Use the Status panel to add query statements to the Selected Retrieval Criteria List
based on alarm and acknowledgement status. The system adds a separate statement for
each of the check box values. See Table 2-3, Status check boxes (p. 2-19). If an alarm
status criteria and an acknowledgement status criteria are selected, the system queries the
database for alarms with both the criteria.
....................................................................................................................................................................................................................................
2-18 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-19
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Table 2-3 Status check boxes (continued)
Severity panel
Use the Severity panel to add query statements to the Selected Retrieval Criteria List
based on alarm severity. The system adds a separate statement for each of the check box
values. See Table 2-4, Severity check boxes (p. 2-20).
Select one or more of the alarm severity check boxes. A query statement is added for each
severity selected. Ensure that an alarm has any one of the selected severity levels for the
system to select it from the database.
The Alarm Severity check boxes map to the perceivedSeverity field in the HFB database.
....................................................................................................................................................................................................................................
2-20 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Table 2-4 Severity check boxes (continued)
A query statement is added for each event type selected. Ensure that an alarm has one of
the selected event types. See Table 2-5, Event Type check boxes (p. 2-21) for the
system to select it from the database.
The Event Type check boxes map to the eventType field in the HFB database.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-21
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Table 2-5 Event Type check boxes (continued)
A query statement is added for each specified probable cause value. Build the criteria
specifying either Contains or Does not contain. Ensure that an alarm has the probable
cause matching one of the values specified for the system to select it from the database. If
....................................................................................................................................................................................................................................
2-22 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
you are using IE on Windows XP for the HFB, disable the script debugging option to
prevent Explorer from displaying invalid error messages. The Probable Cause values map
to the probableCause field in the HFB database.
This panel provides two types of searches:
Case-sensitive
Non-case-sensitive
A query statement is added for each specific problem value. Build the criteria specifying
either Contains or Does not contain. Ensure that an alarm has the specific problem
matching one of the values specified for the system to select it from the database. The
Specific Problem values map to the specficProblem field in the HFB database.
This panel provides two types of searches:
Case-sensitive
Non-case-sensitive
Date/Time panel
Use the Date/Time panel to build a query statement based on the date and time that an
alarm was raised or cleared.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-23
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
The query statement is in the event, date, and time format. Create a query statement with
a date and time range, or only a start or an end date and time. See Table 2-6, Date/Time
panel elements (p. 2-24). The system generates a time range as single query statement.
The system joins multiple date and time query statements with a logical OR operator.
Ensure that an alarm event meets the criteria of at least one of the specified query
statements for the system to select it from the database.
The system provides an initial date and time query statement by default. The value of the
default query statement is the last two hours before the current time on the NSP server.
Delete the default Date and Time query statement.
Attention: If you delete the default Date and Time query statement and do not replace
it, HFB will search the alarms raised in the last two hours. Whenever possible, include
a Date and Time query statement in the Retrieval Criteria List.
The Date and Time fields for a raised alarm map to the eventTime field in the HFB
database. The Date and Time fields for a cleared alarm map to the clearTime field in the
HFB database. Alarm records in the database are stored in Coordinated Universal Time
(UTC) and displayed in local time (local time of the operator).
Element Function
Raised radio button Selects raised alarms
Cleared radio button Selects cleared alarms
....................................................................................................................................................................................................................................
2-24 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Table 2-6 Date/Time panel elements (continued)
Element Function
From Date field Entry of the start date in yyyy/mm/dd format
From Time field Entry of the start time in hh:mm:ss format
To Date field Entry of the end date in yyyy/mm/dd format
To Time field Entry of the end time in hh:mm:ss format
Threshold panel
Use the Threshold panel to build a query statement based on the threshold attributes of a
Quality of Service (QoS) alarm. The system adds a separate statement for each expression
selected for Triggered Threshold Parameter or Observed Threshold Value.
Use the Threshold Parameter field to enter the name of the threshold attribute that
triggered the alarm. This field maps to the triggered threshold field in the HFB database.
Use the Observed Threshold Value field to enter the actual value that triggered the
alarm. This field maps to the observedValue field in the HFB database. Use the
drop-down menu to select an operator in the Observed Threshold expression.
Following are the values:
=: equals the entered value
>: is greater than the entered value
<: is less than the entered value
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-25
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
The query statement has the form parameter, operator, and value for both the Triggered
Threshold Parameter and the Observed Threshold Value for that parameter. To build a
query statement, enter only the threshold parameter or both the threshold parameter and
an observed value. Multiple query statements are allowed.
The HFB does not check if the observed value specified is valid for the specified
parameter, since these vary with NE types. Once you have completed entering data,
review the query that the system has added to the Selected Retrieval Criteria List, to
ensure the query is as intended. This query statement applies only to NEs that maps a
threshold event to an alarm.
....................................................................................................................................................................................................................................
2-26 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Use the check boxes beside the list entries to either add the selected set to the Retrieval
Criteria list, or to delete the selected set. When you select a criteria set from your list and
click Delete Selected, the selected criteria is deleted instantly as shown in Figure 2-16,
Delete Selected Criteria Set (p. 2-28).
Note: Ensure to check your selection before deleting a criteria set.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-27
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Select Retrieval Criteria
HFB user interface
....................................................................................................................................................................................................................................
Once you have added the criteria sets to the Retrieval Criteria List, modify the queries in
the list, retrieve alarms, generate reports, or save the modified queries under a new name.
At any time when you are logged in to the HFB application, save your set of retrieval
criteria for later use. For information on saving criteria sets, see Viewing historical
alarms in the HFB (p. 2-44).
....................................................................................................................................................................................................................................
2-28 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
View Records
Purpose
The View Records option in the Select Retrieval Criteria page enables the user to view
the retrieved alarm records. It retrieves alarm records from the HFB database that meet
the search criteria.
Each request to retrieve alarms from the database displaces the existing View Records
page in the main window. The system does not open separate windows for each request.
Overview
The View Records page contains the alarms list table that displays all the alarm records
retrieved from the database in groups of 25. The maximum number of alarm records
retrieved from the database is 500. The alarms list title bar indicates the group of alarms
displayed and the total number of alarms retrieved. To view other groups of alarms, select
the corresponding page listed below the alarms list. To scan through alarm records in
consecutive groups, use the Next page link.
The following figures illustrate examples of View Records page generated from the HFB.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-29
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Figure 2-18 Example of View Records page (2/4)
....................................................................................................................................................................................................................................
2-30 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Figure 2-19 Example of View Records page (3/4)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-31
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Figure 2-20 Example of View Records page (4/4)
....................................................................................................................................................................................................................................
2-32 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Alarm List
The alarms list, displays several columns of information for each alarm as shown in Table
2-7, Alarm List fields (p. 2-33). To view additional details in the Record Details page,
see Figure 2-21, Alarm Record Details page (p. 2-37). For more information, see the
DA documentation for your domain.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-33
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Table 2-7 Alarm List fields (continued)
....................................................................................................................................................................................................................................
2-34 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Table 2-7 Alarm List fields (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-35
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation View Records
HFB user interface
....................................................................................................................................................................................................................................
Table 2-7 Alarm List fields (continued)
Note 1:
If the default size of this field is increased to accommodate more than 1024 characters, only the
first 30 characters of the field are displayed in the Alarm List. To view the complete entry click
the row number of the alarm and open the Record Details (p. 2-37).
Note 2:
If the DN is more than 30 characters, the Alarm List displays the last 30 characters, preceded by
"...". To view the complete entry click the row number of the alarm and open the Record
Details (p. 2-37).
Note 3:
If the HFB GUI is open during a daylight savings time change, restart the HFB session to update
the time display. When daylight savings time is in effect, the times shown on the HFB GUI and
the NSP GUI may differ by one hour. HFB GUI times are Greenwich Mean Time (GMT) plus
the standard time zone of the HFB GUI host.
Alarm correlation
Alarm correlation is an optional application that performs alarm grouping and finds
dependencies between root causes and symptoms. The correlated alarm groups are
reported to the Alarm Manager and identified in the Correlation Alarm Type column.
PrimaryMain: designates the alarm root cause of the correlation group
Main: designates other alarm causes, than the primary one, of the correlation root
Symptom: designates an alarm consequence of a Primary or Main alarm.
For more information on alarm correlation, see Alcatel-Lucent 9353 Wireless
Management System - User Guide, NN-20500-032.
....................................................................................................................................................................................................................................
2-36 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Record Details
HFB user interface
....................................................................................................................................................................................................................................
Record Details
Purpose
The record details of an alarm is displayed in the Record Details page.
Overview
To view the Record Details page, click on the row number of an alarm in the View
Alarms page as shown in Figure 2-21, Alarm Record Details page (p. 2-37).
The Record Details page displays the following information for the selected alarm:
All attributes as listed in the Table 2-7, Alarm List fields (p. 2-33)
The trend indication attribute which corresponds to the trendIndication field of the
Table 3-2, Alarms table (p. 3-13)
The Alarm Duration attribute which corresponds to the time between when the alarm
was raised and the corresponding clear
Threshold information attributes such as:
Triggered Threshold which corresponds to the triggeredThreshold field
Observed Threshold Value which corresponds to the observedValue field
Note: Both the fields are listed in the Table 3-3, ThresholdInfo table (p. 3-18).
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-37
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Alarm report generation
HFB user interface
....................................................................................................................................................................................................................................
Overview
The report is produced as a text file in which the fields for each alarm are separated by
tabs. All fields are provided for all alarms as shown in Table 2-8, Alarm report fields
(p. 2-38). If a field has no value, the two tabs that delimit that field are adjacent. If the last
field has no value, the line ends with a tab. An end-of-line character separates alarm
records. All end-of-line characters and all tabs in an alarm field are converted to spaces.
Import the text file into a spreadsheet application where the Alarm Report fields are
converted into column headings. Additional formatting may be necessary when viewing a
report in a spreadsheet application. See Viewing historical alarms in the HFB (p. 2-44).
....................................................................................................................................................................................................................................
2-38 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Alarm report generation
HFB user interface
....................................................................................................................................................................................................................................
Table 2-8 Alarm report fields (continued)
The following are examples of several alarms in the alarm report text file:
Ne 1561 NE1561 equipment 1 Ec:AutotestEC Ne:1561 Ec:AutotestEC:Ne:1561:
2003-05-29T18:49:51 -0400 Critical Active False CCU Fail 66 - Timing Problem
N1561
Ne 1562 NE1562 communications 1 Ec:AutotestEC Ne:1562 Ec:Au-
totestEC:Ne:1562: 2003-05-29T18:49:51 -0400 Major Active False Tx AIS 1 - AIS
N1562
Ne 1563 NE1563 quality of service 1 Ec:AutotestEC Ne:1563 Ec:Au-
totestEC:Ne:1563: 2003-05-29T18:49:51 -0400 Minor Active False AU-4 Far-end
background block errors threshold crossing 15-min 5019 N1563
The alarm report displays all event times in the UTC time format.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-39
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Alarm report generation
HFB user interface
....................................................................................................................................................................................................................................
Figure 2-22 Alarm report generated through the HFB query interface
For the associated tasks, see Generating alarm reports using the HFB WICL Editor
(p. 2-48).
....................................................................................................................................................................................................................................
2-40 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Alarm report generation
HFB user interface
....................................................................................................................................................................................................................................
For the associated tasks, see Implementing the HFB input filtering feature (p. 2-50).
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-41
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Archiving and retrieving historical data
HFB user interface
....................................................................................................................................................................................................................................
Overview
The archiving and retrieval feature provides the following operations:
Archive, retrieve, and purge procedures while the HFB application is running
Archive up to the last 30 days of historical data
Retrieve up to seven days of archived historical data
Retrieve data from one day, multiple times, overwriting the previous retrievals
Disaster recovery
When you install the HFB application, you have the option to configure the application to
use the archiving and retrieval feature instead of the backup and restore function in NSP
for the historical data.
When you query alarms from the HFB, the View Records page displays active data as
well as retrieved archived data. The archived alarm appears shaded in the View Records
list and the Record Details page provides information on the archival of the selected
record.
The Figure 2-24, Archived alarms on the View Records page (p. 2-42) shows archived
alarms in the alarms list.
....................................................................................................................................................................................................................................
2-42 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Overview
Procedures
....................................................................................................................................................................................................................................
Procedures
Overview
Purpose
This section contains the following procedures:
Viewing historical alarms in the HFB
Generating alarm reports using the HFB WICL Editor
Implementing the HFB input filtering feature
Contents
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-43
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Viewing historical alarms in the HFB
Procedures
....................................................................................................................................................................................................................................
Procedure
To view the historical alarms in the HFB, perform the following steps:
...................................................................................................................................................................................................
1 In the HFB GUI client workstation, enter the following web address: http://<machine
name>:8080/hfb where <machine name> is the node name or IP address of the host
machine on which the web server is installed.
...................................................................................................................................................................................................
4 From the Select Retrieval Criteria page, click on one of the criteria tabs to start building
the query statement.
....................................................................................................................................................................................................................................
2-44 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Viewing historical alarms in the HFB
Procedures
....................................................................................................................................................................................................................................
...................................................................................................................................................................................................
5 Use the window elements in the tab to define a query statement. For a detailed description
of the window elements and possible values, see Select Retrieval Criteria (p. 2-11).
Select from the criteria sets that is saved before. See Threshold panel (p. 2-25).
...................................................................................................................................................................................................
6 Click Add to List to add the query statement to the Retrieval Criteria List.
...................................................................................................................................................................................................
7 Create additional query statements in this criteria tab or select other tabs to create
additional query statements.
Result: The system provides a default query of alarm records raised during the last
two hours.
...................................................................................................................................................................................................
...................................................................................................................................................................................................
9 In the Selected Retrieval Criteria area in the main window, click the check box to the
left of the query statements that you want to delete in the Retrieval Criteria List.
...................................................................................................................................................................................................
10 Click either of the Delete Selected buttons to delete the query statements from the
Retrieval Criteria List.
...................................................................................................................................................................................................
11 Return to Step 8.
...................................................................................................................................................................................................
12 (Optional) Click Count to determine how many records will match the query.
...................................................................................................................................................................................................
13 Click View Records to retrieve alarms and display them in the View Records alarms list.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-45
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Viewing historical alarms in the HFB
Procedures
....................................................................................................................................................................................................................................
Result: HFB will time out after 30 minutes of either idle or query time. After this time
out, the HFB system remains responsive and it is recommended that you terminate
and restart the HFB GUI.
...................................................................................................................................................................................................
14 Click the row number of the alarm on the left of the View Records page to view the
complete alarm, on the Alarm Record Details page.
...................................................................................................................................................................................................
15 Return to Step 8.
...................................................................................................................................................................................................
17 Select the Save option in the File Download window and click OK to save the file to the
disk.
If, for any reason, you click Cancel to stop this operation, wait for a few minutes before
performing another action. This allows the server to process the cancel request and
terminate current processing.
...................................................................................................................................................................................................
18 Select the directory path and file name for the alarm report in the Save As window and
click Save. Open the file in a spreadsheet application.
Additional formatting may be necessary to view the file in a spreadsheet application. For
example, to view a file in Microsoft Excel, start Excel and open the file using the Open
command in the File menu. The Text Import Wizard opens. On the first screen, select
Delimited and click Next. On the second screen, select the Tab check box in the
Delimiters area and click Next. On the third screen, highlight the Additional Text column
in the Data preview area and then select Text in the Column data format area. Click
Finish.
...................................................................................................................................................................................................
19 Return to Step 8.
...................................................................................................................................................................................................
20 From the Selected Retrieval Criteria page in the main window, click Save Criteria to
open the Save Criteria Set page.
....................................................................................................................................................................................................................................
2-46 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Viewing historical alarms in the HFB
Procedures
....................................................................................................................................................................................................................................
...................................................................................................................................................................................................
21 Enter a unique name in the Criteria Set Name field with maximum 40 characters. Do not
use spaces before or after an existing file name to rename a criteria set. The HFB does not
recognize spaces before or after a file name.
...................................................................................................................................................................................................
23 Return to Step 8.
...................................................................................................................................................................................................
24 From the Selected Retrieval Criteria page in the main window, click either of the Reset
to Default buttons.
The Retrieval Criteria List displays the default Raised during the last two hours query
statement.
E...................................................................................................................................................................................................
N D O F S T E P S
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-47
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Generating alarm reports using the HFB WICL Editor
Procedures
....................................................................................................................................................................................................................................
Procedure
...................................................................................................................................................................................................
1 From the NSP main window, select Configuration > WICL Script Editor.
Result: The WICL Script Editor window opens.
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
2-48 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
HFB operation Generating alarm reports using the HFB WICL Editor
Procedures
....................................................................................................................................................................................................................................
...................................................................................................................................................................................................
3 Select prepareReport.
Note: For more information on prepareReport, see Alcatel-Lucent 9353 Wireless
Management System - Commands Reference Guide (WICL), NN-20500-030.
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 2-49
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
HFB operation Implementing the HFB input filtering feature
Procedures
....................................................................................................................................................................................................................................
Procedure
...................................................................................................................................................................................................
1 From the NSP main window, select Fault > Alarm Stream Rule Set.
...................................................................................................................................................................................................
2 To make a specific rule active, select it from the Inactive Rules window and click
Activate.
Result: The selected rule becomes active and appears in the Active Rules window.
...................................................................................................................................................................................................
3 From the NSP, select Fault > Launch Historical Fault Browser.
Result: The HFB window opens. In the HFB report window, the filter information
appears for the alarms that match the criteria defined in the previously activated rule.
E...................................................................................................................................................................................................
N D O F S T E P S
....................................................................................................................................................................................................................................
2-50 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
3 3 istorical Fault Browser
H
administration
Overview
Purpose
This chapter provides information about the administration of the HFB application and
explains the HFB database maintenance procedures.
Contents
...................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-1
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration Overview
HFB administration overview
....................................................................................................................................................................................................................................
Overview
Purpose
This section explains the following topics:
Administering HFB agent
HFB Databse Maintenance Program
Application log files
HFB database schema
Archiving and retrieval
Capacity planning
Contents
....................................................................................................................................................................................................................................
3-2 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration Administering the HFB agent
HFB administration overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-3
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database maintenance program
HFB administration overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
3-4 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration Application log files
HFB administration overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
3-6 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-7
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
The mapping of the FMBB or TUMSBB IDL attribute ID types to the equivalent fields in
the HFB database is shown, see Table 3-1, FMBB or TUMSBB to HFB mapping
(p. 3-8). All attribute ID types apply to the FMBB IDL except for the neUserLabel
attribute ID type which applies to the TUMSBB IDL. The X.721 and X.733 standards are
International Telecommunications Union (ITU) standards.
....................................................................................................................................................................................................................................
3-8 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-1 FMBB or TUMSBB to HFB mapping (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-9
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-1 FMBB or TUMSBB to HFB mapping (continued)
Supported database
HFB supports the Enterprise edition of Oracle Release 9.2.0.5 RDBMS software with the
Partitioning option. HFB communicates with the database through the local database
interface.
Supported standards
HFB RDBMS maps to the FMBB and the TUMSBB contract definitions through the
CORBA IDL. The CORBA IDL is based on Telecommunications Management Network
(TMN) standards that support limited pseudo-Common Management Information Service
Element (CMISE) operations.
HFB databases
HFB database defines the following data tables, which are created by the HFB installer
during the installation of the HFB agent:
Two tables containing alarm event records (alarms and thresholdInfo)
One table containing network element data (nedata)
Five tables containing information about the alarms table fields (severity, eventtype,
status, trendindicationconst, probablecauseconst)
One table to store criteria sets
The alarm_insert_staging table has the same field contents as the alarms table.
....................................................................................................................................................................................................................................
3-10 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
If the HFB Archiving and Retrieval feature is configured on the system, an additional user
(hfbrestore) is created along with the following two tables:
One table containing restored alarm event records (alarms)
One table containing the partitioning information for the Retrieved Alarms table.
Additionally, the Oracle software creates, by default, the user_tab_partitions table which
tracks the partitions of all the tables. This table contains the required initial partition
labelled ABC. Do not remove this. For more information on Archiving and Retrieval, see
Archiving and retrieval (p. 3-29).
The HFB GUI uses a database view called v_alarms which displays the contents of the
current alarms table. If the Archiving and Retrieval option is configured on the system,
the view lists the contents of the active alarms table along with the restored alarms table.
The HFB relationships among the data tables is shown. See Figure 3-1, Diagram of HFB
alarm data tables (p. 3-12). Each box in this diagram represents a data table. The items
listed within each box represent the fields in each data table. The items N,N indicate the
row mapping between the Alarms table and the other data tables, where N represents a
numeric value. The first numeric value represents the minimum number of mapped rows.
The second numeric value represents the maximum number of mapped rows.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-11
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
3-12 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Following are the characteristics of the two alarm data tables represented in Figure 3-1,
Diagram of HFB alarm data tables (p. 3-12):
Alarms table: The fields eventTime, specificProblem, probableCause,
objectInstanceString, classId, eventType, and alarmKeyValue together form the
primary key of this table.
ThresholdInfo table: For each row in the Alarms table, there exists zero or one row of
data in the ThresholdInfo table. Each row of data in the ThresholdInfo table maps to
an alarm event in the Alarms table.
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-13
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-2 Alarms table (continued)
....................................................................................................................................................................................................................................
3-14 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-2 Alarms table (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-15
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-2 Alarms table (continued)
....................................................................................................................................................................................................................................
3-16 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-2 Alarms table (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-17
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-2 Alarms table (continued)
Note:
The fields eventTime, specificProblem, probableCause, objectInstanceString, classId,
eventType, and alarmKeyValue together form the primary key of this table.
....................................................................................................................................................................................................................................
3-18 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-3 ThresholdInfo table (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-19
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-4 nedata table (continued)
The five tables containing information about the alarms table fields are small (except for
the probablecauseconst table) and of fixed length. They are given next, in their entirety.
....................................................................................................................................................................................................................................
3-20 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-5 severity table (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-21
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-9 probablecauseconst table (continued)
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-25
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration HFB database schema
HFB administration overview
....................................................................................................................................................................................................................................
Table 3-9 probablecauseconst table (continued)
....................................................................................................................................................................................................................................
3-28 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration Archiving and retrieval
HFB administration overview
....................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-29
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration Capacity planning
HFB administration overview
....................................................................................................................................................................................................................................
Capacity planning
Purpose
This section explains the following topics:
Database instance requirements (p. 3-30)
Database capacity planning (p. 3-30)
Example
The following example shows how to derive the amount of disk space required to support
an HFB database.
....................................................................................................................................................................................................................................
3-30 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration Capacity planning
HFB administration overview
....................................................................................................................................................................................................................................
Other specifications
For this example, the following additional specifications exist:
Average entry size of one alarm is the row size of the alarms table + the row size of
all indexes of the alarms table
Average entry is approximately 1430 bytes for each alarm
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-31
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration Overview
Procedures
....................................................................................................................................................................................................................................
Procedures
Overview
Purpose
This section contains the following procedures:
Setting HFB database maintenance
Clearing domains when HFB agent is removed
Contents
....................................................................................................................................................................................................................................
3-32 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Historical Fault Browser administration Setting the HFB database maintenance
Procedures
....................................................................................................................................................................................................................................
Procedure
To set the HFB database maintenance, perform the following steps:
...................................................................................................................................................................................................
1 Log in to the WMS workstation as the root user and open a console window.
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 3-33
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Historical Fault Browser administration Clearing domains when the HFB agent is removed
Procedures
....................................................................................................................................................................................................................................
Procedure
Perform the following steps:
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
3-34 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
4 4 anaging Oracle
M
administrator user IDs
Overview
Purpose
This section covers the management of administrator user IDs for the Oracle database.
For information on managing all other users and roles, see Alcatel-Lucent 9353 Wireless
Management System - User Configuration and Management, NN-10300-074 and
Alcatel-Lucent 9353 Wireless Management System - Security Fundamentals,
NN-10300-031.
Contents
...................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 4-1
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Managing Oracle administrator user IDs Overview
Oracle administrator user ID management
....................................................................................................................................................................................................................................
Overview
Purpose
In general, all user and role management is performed using the Sun ONE Identity Server
(IS) console.
This section covers the management of administrator user IDs for the Oracle database.
The Oracle database is used by the HFB application.
Contents
....................................................................................................................................................................................................................................
4-2 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Managing Oracle administrator user IDs Default Oracle user IDs and password settings
Oracle administrator user ID management
....................................................................................................................................................................................................................................
Overview
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 4-3
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Managing Oracle administrator user IDs Default Oracle user IDs and password settings
Oracle administrator user ID management
....................................................................................................................................................................................................................................
Password rules for HFB
The following rules apply to creating passwords for hfbagent and hfbgui:
1 to 30 characters long
No quotation marks
Lowercase
Begins with an alphabetic character from the database character set, and contains only
alphanumeric characters.
Do not use an Oracle reserved word.
Note: Do not use the following characters:
underscore _
dollar sign $
pound sign #
period .
at symbol @
See the Oracle documentation for more information.
....................................................................................................................................................................................................................................
4-4 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Managing Oracle administrator user IDs Overview
Procedures
....................................................................................................................................................................................................................................
Procedures
Overview
Purpose
Use the following procedures for configuring and maintaining the Netscape Directory
Server:
Changing passwords of HFB database users
Changing the Oracle tnslsnr port password
Changing HFB passwords
Contents
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 4-5
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Managing Oracle administrator user IDs Changing passwords of the HFB database users
Procedures
....................................................................................................................................................................................................................................
Procedure
Perform the following steps:
...................................................................................................................................................................................................
1 Log in to the WMS PMS as the root user ID and open a terminal window.
...................................................................................................................................................................................................
E...................................................................................................................................................................................................
N D O F S T E P S
....................................................................................................................................................................................................................................
4-6 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Managing Oracle administrator user IDs Changing the Oracle tnslsnr port password
Procedures
....................................................................................................................................................................................................................................
Procedure
Perform the following steps:
...................................................................................................................................................................................................
1 Log in to the PMS, open a terminal window and log in as the root user.
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 4-7
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Managing Oracle administrator user IDs Changing the Oracle tnslsnr port password
Procedures
....................................................................................................................................................................................................................................
Result: The prompt LSNRCTL> is displayed after the message indicating that the
password has been set successfully.
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
4-8 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Managing Oracle administrator user IDs Changing the HFB passwords
Procedures
....................................................................................................................................................................................................................................
Related information
If you have installed the HFB agent on a SMS, change the hfbagent password on the
secondary server. Use the same password on the PMS and SMS.
Note: Ensure that the password follows the specified rules. See Password rules for
HFB (p. 4-4).
Procedure
Perform the following steps:
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
Alcatel-Lucent 9353 WMS Alcatel-Lucent Proprietary 4-9
411-5221-210 UA08.1 Use pursuant to applicable agreements
Issue 13.08 April 2013
Managing Oracle administrator user IDs Changing the HFB passwords
Procedures
....................................................................................................................................................................................................................................
...................................................................................................................................................................................................
....................................................................................................................................................................................................................................
4-10 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013
Index
....................................................................................................................................................................................................................................
disk space calculations, 3-31
other, 3-31
....................................................................................................................................................................................................................................
IN-2 Alcatel-Lucent Proprietary Alcatel-Lucent 9353 WMS
Use pursuant to applicable agreements 411-5221-210 UA08.1
Issue 13.08 April 2013