SRM Pub Admin Guide 4 4 en Us
SRM Pub Admin Guide 4 4 en Us
SRM Pub Admin Guide 4 4 en Us
7
Administrator Guide
4.7
January 2022
Rev. 1.0
Notes, cautions, and warnings
NOTE: A NOTE indicates important information that helps you make better use of your product.
CAUTION: A CAUTION indicates either potential damage to hardware or loss of data and tells you how to avoid
the problem.
WARNING: A WARNING indicates a potential for property damage, personal injury, or death.
© 2016 - 2022 Dell Inc. or its subsidiaries. All rights reserved. Dell, EMC, and other trademarks are trademarks of Dell Inc. or its subsidiaries.
Other trademarks may be trademarks of their respective owners.
Contents
Figures.......................................................................................................................................... 7
Tables........................................................................................................................................... 8
Contents 3
Access and configure scheduled tasks........................................................................................................................ 30
Metrics collection and reporting.....................................................................................................................................31
Collectors and metrics................................................................................................................................................ 31
Configure the import_variable_status task............................................................................................32
How SRM handles collection interruptions........................................................................................................... 33
Monitoring for collection interruptions...................................................................................................................34
Isolated causes of reporting gaps .......................................................................................................................... 35
Chapter 7: Licensing................................................................................................................... 56
Licensing concepts........................................................................................................................................................... 56
After installation: Licenses and SolutionPacks.....................................................................................................56
Dell EMC SRM feature names and ELMS licenses............................................................................................. 56
Trial licenses................................................................................................................................................................. 56
4 Contents
License duration...........................................................................................................................................................57
License purchase......................................................................................................................................................... 57
Licensing operations......................................................................................................................................................... 57
Log in with Admin credentials.................................................................................................................................. 57
View license information............................................................................................................................................58
Upload a new license file........................................................................................................................................... 59
Delete licenses............................................................................................................................................................. 60
Synchronize licenses on multiple hosts..................................................................................................................60
Troubleshooting licensing ...............................................................................................................................................60
Permanent license stops working after host reconfiguration........................................................................... 61
Users are locked out of Dell EMC SRM..................................................................................................................61
Module does not start or has no license .............................................................................................................. 63
ELMS license entitlements..............................................................................................................................................63
Contents 5
Overview.............................................................................................................................................................................. 81
Usage.................................................................................................................................................................................... 81
SQL syntax..........................................................................................................................................................................83
6 Contents
Figures
Figures 7
Tables
8 Tables
1
Dell EMC SRM Introduction
The following topics introduce the Dell EMC SRM system and its components.
Topics:
• System description
• Log in and explore the Dell EMC SRM Interfaces
• Provide an enterprise logo and message
• Configuring an SMTP server
• Navigation styles
• Use links in reports to get more detail
• For more information
System description
Dell EMC SRM provides a multi-vendor view into an enterprise storage infrastructure to help visualize and optimize capacity and
manage devices.
Frontend Hosts the Tomcat web server and the Dell EMC SRM Console. Users and administrators log in to the
Frontend server. All Frontend services, including reports, alerting, and compliance, are integrated into a
single User Interface on the Console.
Primary Backend Hosts the database and system processes and tasks, including the Alerting, Compliance, and Topology
Backend components.
Secondary Hosts additional backend elements.
Backend
Collector Hosts the metrics collectors that receive information from the monitored storage devices.
Manager
Logically, Dell EMC SRM consists of the core platform ( Dell EMC SRM) and a set of SolutionPacks installed onto the core that
adds storage-specific and device-specific functionality.
SolutionPacks essentially customize the system to the infrastructure—you install only the ones you need. A SolutionPack
installs a metrics collector, reports, alert definitions, configuration compliance policies, and many other components that enable
meaningful reporting for a storage device type or feature set.
When you install a new SolutionPack, you also configure a discovery process to look for the new device types. Dell EMC
SRM discovers devices and starts metrics collection from them, and those new devices eventually appear in the reporting
infrastructure on the Dell EMC SRM User Interface.
The following figure shows how metrics from various devices are collected, enriched, merged into a single database, and
displayed in one user interface. The Load Balancer Arbitrator/Load Balancer Connector (LBA/LBC) manages collected data. The
data is inserted into the database where it is available to the Frontend for reporting purposes on the web Portal, which is the
Dell EMC SRM User Interface (UI).
Steps
1. In a web browser, go to the following URL:
https://<frontend_server_name>:58443/APG
Obtain the Dell EMC SRM Frontend server name from the system installer.
2. On the login screen, type a valid Dell EMC SRM username and password, and click LOGIN.
NOTE: Obtain the initial username and password from the system installer. You can create more user accounts once you
are logged in as an administrative user.
NOTE: In SRM Frontend, the password expiry duration is current date + 90 days. The users are notified 10 days prior
about password expiration in SRM Frontend . Once the password is changed, the user must log out and log in for the
password changes to be effective.
NOTE: As an administrator, you can configure the initial report that appears immediately after logging in for various
user profiles by browsing Administration > Users & Security > Users & Roles > Manage Profiles > ProfileName >
Customizable Settings.
3. To explore reports in the User Interface, make selections in the navigation column.
4. To explore the Administration features, click Administration in the banner.
5. To open the Help topics, click ? > Documentation in the banner.
The Help describes features available on the User Interface, such as managing and scheduling reports, browsing features,
and how to edit report definitions. The Help also describes Administrative features available from the Console.
6. To explore user preference settings, click Profile > User Settings in the banner.
7. To log off, click Profile > Log out.
Steps
1. Log in to the Console and go to Administration > CONFIG > Settings > Frontend Status.
2. In the Banner field, provide the name that is required in place of product name on the login page.
3. In the Welcome Message field, provide a message to the users for the Login screen.
Use plain text or HTML.
4. To upload a logo, click the Administration > Users & Security > Users & Roles > Manage Profile tab.
5. In the Click Customizable Settings tab, click Upload New Logo and select a file from the local system.
6. Click Save.
7. To test, click Profile > Logout in the banner, and then start over with the URL to see the new Login screen.
Steps
1. Click Administration > CONFIG > Settings > SMTP Settings.
2. Configure the SMTP fields.
3. Click SAVE CHANGES.
You have successfully set the SMTP variables on the Backend (alerting) server. In a one-server setup, these settings also
apply to the Frontend server.
4. In a setup with more than one server, set the SMTP variables on each Frontend server.
NOTE: This step is required in a 4-VM vApp, or if the installation includes more than one Frontend.
Navigation styles
The navigation column on the User Interface provides access to all reports. You can choose between the Icon Navigation and
Tree Navigation styles. The Administrator sets the default style for the installation.
Default style Each user account can override the global default style and set their own preferred style in the
Navigation Style field at Profile > User Settings > Preferences.
Icon Navigation The Icon Navigation style helps preserve space on smaller-sized windows. Initially, it shows only a thin
column of icons. To browse to a report, click an icon. A second column of categories appears. To expand
a category, click it, and click again to select a report. Notice the scrollbar on the expanded second
column. The second column disappears when you click a report. To browse further into the reporting
structure, use the tabs, dashboards, and links in the reporting pane.
Steps
1. Click Profile > User Settings > Preferences.
2. In Navigation Style, make a selection.
Option Description
Use default navigation The default navigation of the portal.
Use icon navigation The navigation column contains icons that expand into reporting categories.
Use tree navigation The navigation column is a hierarchical tree of report names.
3. Click Save.
Steps
1. Click the pin at the top of the icon navigation bar.
2. Click the pin again to return the second column to a temporary display.
Underline on configuration item indicates link to home An underline appearing when you hover the cursor over a
report configuration item in a report indicates a link to a detailed
storage system report for that item.
More details about a table row are displayed below a In some tables, click a row to show more details below the
table table. The original table conveniently remains in view, letting
you click each row in it and see the details change per row.
Question mark (?) indicates link to history for a metric A question mark (?) appearing when you hover the cursor
over a metric indicates a link to a historical trending report for
the metric in a table cell.
Underline on report title indicates link to full-size report On dashboards and mixed reports, the report titles are links
and supporting details to the full-size report. The full-size report typically includes a
table of supporting details below the report.
The following procedure illustrates these link types and shows how to recognize them in a report.
Steps
1. Click Report Library > solutionpack_name > Summary > Table View.
All the configuration items are discovered and are listed in table.
2. Hover the cursor over items in the summary report to discover active links.
In the report above, the Array column contains active links to the home reports for each discovered array.
3. To access the home report of the array, click a link.
4. Use the Back button of the browser to return to a previous report.
5. Click Report Library > solutionpack_name > Inventory.
SolutionPack tracks the objects and these objects are shown in the Inventory report tabs. In this case, there are enough tabs
to require a scrolling tab bar.
6. To explore the reports, click a tab.
a. To discover active links, hover the cursor over items in the report.
b. In many Inventory reports, click a row to show additional details.
7. Click Report Library > solutionpack_name > Capacity, or click Dashboards > Storage > Enterprise Capacity.
Either of it displays a Capacity Dashboard showing multiple capacity reports.
On dashboards and mixed reports, the report titles are links to supporting details. Click the report title.
Dell Support Site The Dell Support Site provides access to installation, security, upgrade, configuration, and usage guides. It
also contains release notes and a set of matrixes of supported features and detailed system information.
Pointers to Dell EMC SRM documentation are also included.
Embedded Help The Help system that is embedded in the product provides information about features on the User
Interface and Administration Interface. To open the Help, click the ? icon in the banner in the Dell EMC
SRM web portal.
User management
On the Dell EMC SRM Console, administrators can create and manage Dell EMC SRM user accounts, and set roles and
privileges on user accounts.
Dell EMC SRM supports multiple user accounts that have different purposes. The product has predefined roles such as
Datacenter Administrators, Storage Administrators, and Network Administrators. You can also create custom roles and assign
specific privileges to those roles.
To perform these operations, you need Dell EMC SRM login credentials with global administrative privileges.
The User Management page also lists the number of days left for password expiry and the last accessed date of the user.
Steps
1. Click Administration .
2. Go to User & Security > Users & Roles > Manage Users.
The resulting page shows all defined user accounts.
3. Right-click a user to access a context menu of management actions.
4. Choose Edit to view or change information about a user account.
You can also click a username to edit it.
5. Edit the tabs on the Users Modification page, and then click Save.
Steps
1. Click Administration .
2. Go to Users & Security > Users & Roles > Manage Users.
3. Click New User .
4. Complete the User Data tab.
a. Type the user login and password credentials.
NOTE:
● Users can change their password after logging in with these credentials, in the settings dialog box.
● The user login and passwords are case-sensitive.
● If Dell EMC SRM is configured to use an external authentication system such as LDAP, passwords need not be
set.
b. Optionally type a title, first and last name, and email address of the user.
The email address is used to send notifications of stored reports.
Users can enter these settings in their own settings dialog box, which overrides anything set here.
5. Click the User Status tab and set the user's rights and access.
7. Click Save.
User authorization
Roles restrict access to resources by using role-based access control.
The default roles available are Normal User and Global Administrator. However, if required you can also create a role and apply
filters to manage access permissions.
Delete a user
Administrators can delete a user account.
Steps
1. Click Administration .
2. Go to Users & Security > Users & Roles > Manage Users.
3. Right-click a user, and select Delete.
Steps
1. Click Administration > Users & Security > User & Roles > Manage Users.
2. Right-click the user that you want to test, and choose Test User.
You are launched into the User Interface, interacting with the Console as if you had logged in as the user being tested. The
username that you are testing appears.
Steps
1. Click Administration .
2. Click Users & Security > Users & Roles > Manage Profiles
The resulting page shows all defined profiles.
Steps
1. Click Administration .
2. Click Users & Security > Users & Roles > Manage Profiles > New Profile
3. On the Main Properties tab, type a name and a description for the new profile.
4. Click the Customizable Settings tab and set the language, time zone, and logo.
Use the ? icons on the page for information about these settings. You can upload a custom logo here which then appears on
the login screen and on the Dell EMC SRM user interface pages.
Steps
1. Click Administration > Users & Security > Users & Roles > Manage Roles.
2. To edit a role, click the role name.
3. Edit the tabs on the Role Modification page, and then click Save.
Steps
1. Click Administration .
2. Click Users & Security > Users & Roles > Manage Profiles > New Profile
3. On the Main Properties tab, type a name and description for the role.
4. On the Members tab, and add users to the role.
5. If LDAP authentication is configured, click the External Members tab and bind an external group to the new role (LDAP
Users).
6. Click the Template Access tab and set one report pack access for this role.
7. Click the Actions tab and select actions that this role can perform.
8. Click the Module & Restrictions Access tab. For each module, select whether users with this profile can access the
module.
9. Click the Role and User Management tab and select whether the new role can manage other roles or the users with those
roles.
Test authentication
You can test authentication settings to test the connectivity to the realm.
Steps
1. Go to Administration > USERS & SECURITY > Authentication > Authentication Settings.
2. In Authentication Type, select the authentication type you want to test.
3. Click Test Authentication.
Steps
1. Go to Administration > USERS & SECURITY > Authentication > Authentication Settings.
The Authentication Settings dialog box appears.
Two realms are provided by default after installation:
● Local
● LockoutRealm
2. Click Add a Realm.
3. Select an Authentication Type.
4. Configure additional fields that appear for the selected authentication type.
5. To add additional parameters to the authentication source, click Add Property.
For example, if you selected Custom, use Add Property to define the parameter names required to configure connections
and credential search.
6. Click Test Authentication to test connectivity to the realm.
7. If authentication failed, check configured property values or add additional properties as needed for the realm, and retest
connectivity.
8. Click Save.
Steps
1. Go to Administration > User & Security > Authentication > Authentication Settings.
The Authentication Settings dialog box appears.
Two realms are provided by default after installation:
● Local
● LockoutRealm
2. To set the order of the authentication methods that are used to check credentials, use the up and down-arrow icons.
Local realm
The Local realm authenticates from usernames and passwords that are configured in Dell EMC SRM.
The Local realm is the default authentication method that is activated after installation. It does not require any additional
configurations.
If you configure an external database, such as Active Directory, for authentication, you still need at least one local user account,
with global administrator rights, that matches a domain account.
Steps
1. For LDAPS, copy and import certificates for the LDAP server and for the Dell EMC SRM Frontend server.
See the Dell EMC M&R Security Configuration Guide for procedures.
2. To use for the LDAP connections, select an existing LDAP user and get the Distinguished Name (DN) for that user.
To avoid security issues, select a user with read-only privileges to the directory.
You can obtain the DN using dsquery or another tool on the AD server. For example, the following dsquery obtains the
DN for the user W4NAD.
3. Go to Administration > Users & Security > Authentication > Authentication Settings.
The Authentication Settings dialog box appears.
Two realms are provided by default after installation:
● Local
● LockoutRealm
4. Click Add a Realm.
5. In Authentication Type, select LDAP.
6. Configure the required LDAP connection properties that appear. See Configuration properties for LDAP authentication for
property explanations.
7. Add additional optional properties, as needed by the LDAP implementation.
See Configuration properties for LDAP authentication for property descriptions for typical use cases.
To add a property, use either of these methods:
● Select a property from the Add Property drop-down list, and click Add.
● Type a property name in the text box, and click Add.
Each Add action adds the new property name and accompanying text box for configuring the value for the property.
8. To test connectivity to the LDAP server, click the Test Authentication.
9. If authentication failed, add additional properties as needed for the LDAP implementation and their values and retest
connectivity.
10. Click Save.
11. Provide Dell EMC SRM privileges to the LDAP authenticated users by either:
● Create Dell EMC SRM local users that match the LDAP users.
● Map LDAP/AD groups to Dell EMC SRM roles. See Adding external members to a role.
For LDAP, you can use just the group name in the mapping. The distinguished name is not required.
For example, using information from the following dsquery that requests all group names starting with Watc, the
external group name to map is Watch4netLDAP.
Required properties
The following properties are mandatory for connection.
ldap://your-ldap-server1:389
or
ldapS://your-ldap-server1:389
connectionName The Distinguished Name of the LDAP user you selected to connect to the LDAP directory.
For example:
CN=W4NAD,CN=Users,DC=support,DC=local
CN=Users,DC=support,DC=local
userSearch The message format that is used to search for a user. This property is the LDAP filter
expression that is used to search for a user's directory entry. The syntax is (variable={0}),
where {0} represents the username. Examples of common values for userSearch are:
● For Active Directory:
○ (sAMAccountName={0})
○ (userPrincipalName={0})
● For OpenLDAP:
○ (uid={0})
memberOf
isMemberOf
member
If this property is not specified, the default is that all roles for a user derive from the role
search that is defined in roleSearch.
roleBase The base DN for group membership search (the DN of the DIT location where groups are
located. If not specified, the default is the top-level directory context. Example value:
CN=Users,DC=corp,DC=Example,DC=com
userSubTree Values are true or false. When set to true, the search looks in the entire subtree of the
element that is specified by the roleBase property for role entries that are associated with the
user. The default value of false searches only the top level.
roleSearch The LDAP filter expression that is used for performing role searches. Use {0} to substitute the
DN of the user, or {1} to substitute the username. Example values:
(uniqueMember={1})
(member={0})
If not specified, a role search does not take place and roles are taken only from the attribute in
the user's entry that is defined in the userRoleName property.
roleName The name of the attribute that contains role names in the directory entries that are found by
a role search. In addition, you can use the userRoleName property to specify the name of an
attribute in the user's entry that contains additional role names. If roleName is not specified,
a role search does not take place, and roles are taken only from the user's entry. Example
values:
sAMAccountName
referrals
derefAliases
Steps
1. Click Administration > Users & Security > Users & Roles.
2. Click the Manage Roles tab.
Steps
1. Click Administration > Users & Security > Users & Role.
2. Click the Manage Profile tab.
3. Select the profile.
4. Click the External Members tab.
5. In Bind an external group to this profile, type a group name that is defined in the external source.
For example, type an LDAP group name.
6. Click Add to this profile.
7. To add additional groups to the profile, repeat the previous two steps.
8. Click Save.
Steps
1. Click Administration.
2. Click a server under System Admin > Servers & Modules > Services
3. Click the service that you want to start or stop.
4. Click Start, Stop, orRestart.
Steps
1. Go to Administration > System Admin > Servers & Modules > Modules > component_type > component_name .
2. To view or edit a configuration file:
a. Expand the Configuration Files block.
b. In the list of configuration files, click the Edit (pencil) icon to open a file.
c. If needed, edit the file and click Save.
3. To download or delete a log file:
a. Expand the Log files block.
b. In the list of log files, click a file to select it.
c. Click Download and respond to the browser's prompts for storing the file.
d. Click Delete and respond to the prompt to verify the delete action.
Steps
1. Go to Report Library > Dell EMC SRM Health > Logical Summary.
2. Scroll down to bring the heat maps in view.
5. Click the block to display the detailed alert information for the component.
Prerequisites
Ensure that you have logged in with root or APG privileges.
NOTE: The list of services varies depending on which type of installation was performed, vApp, collector, backend, and
frontend.
Steps
● Type manage-modules.sh service stop <service_name> from the bin directory of the installation to stop a
specific Dell EMC M&R platform service.
This example shows how to stop all Dell EMC M&R platform services:
Prerequisites
To manage services, ensure that you have logged in with system administrator credentials.
NOTE: The list of services varies depending on which type of installation was performed, vApp, collector, backend, and
frontend.
Steps
Type manage-modules.cmd service stop <service_name> from the bin directory of the installation to stop a
specific Dell EMC M&R platform service.
This example shows how to stop all Dell EMC M&R platform services:
About Collectors
Collector instances are associated with specific SolutionPacks and are configured during SolutionPack installation. For many
collectors, you can configure the collection frequency to conform to conditions at the site.
To change a collection frequency, reconfigure the corresponding SolutionPack. No disruption in metrics collection occurs when
you change a collection frequency.
A Collector Manager process manages a set of collector instances. On the Administration console, you can see the Collector
Manager processes and the status (Started or Stopped), configuration files, and log files. Look under Administration >
System Admin > Servers & Modules > Logical View > Collecter.
<param> element, "inactive" Stale metrics become inactive after 14 days of inactivity when the inactivity is the
attribute result of collection failures.
<param> element, "max- Stale metrics where only one member in a group of peers is affected become inactive
inactive" attributes after 24 hours of inactivity.
If needed, you can change the schedule and the delays. The following list parses the elements in the configuration file.
<schedule> Sets the run schedule for the task. The installed setting is every 6 hours.
<schedule
cron="0 */6 * * *"
xsi:type="schedule-repeated"
disabled="false">
<param> The inactive parameter sets how long a metric can be stale before being changed to inactive when all
{"inactive":" metrics in a specific peer group are stale (indicating a collection failure). The installed setting makes stale
14d", metrics inactive after 14 days of inactivity.
<parameters>
<param>{"inactive":"14d",...
The assumption is that collection failures are typically corrected within a 14-day period and most
installations do not want to see fluctuations in metrics that are caused by collection failures. If needed,
you can decrease (or increase) this period.
"max- The max-inactive attribute defines how long one member of a peer group can be stale before
inactive": becoming inactive. When no metric is collected for a single member of a group (and metrics are collected
"24h" for other members), it is not a collection failure. Instead, it typically indicates a permanent change, such
as a deleted or reconfigured component. The assumption is that most installations want to see such a
change reflected as soon as possible in reports. For most installations, the 24-hour delay is optimal. The
24-hour delay accommodates the timing of other processes, such as all collector intervals and database
processes. If needed, you can increase this delay period.
NOTE: Only small installations with correctly timed processes can consider decreasing this period.
NOTE: There are multiple max-inactive attributes. All of them must be changed to the same
value to maintain integrity of global reporting.
Steps
1. Go to Administration > CONFIG > Settings > Scheduled Tasks > Backend > import_variable_status_instance .
Each Backend in the installation has an import_variable_status task.
2. On the task page, click to expand Configuration Files.
3. Click the Edit (pencil) icon beside the following file.
data/task_repository/backend/Default/import_variable_status.task
Subcomponent A component or part that is related to a device is reconfigured or deleted. For example, one or several
reconfigured, ports or arrays could be reassigned, or a LUN could be removed from a configuration. In these situations,
removed, or the previously collected metric never reappears.
temporarily down A subcomponent or part could be temporarily down. In this case, the metric resumes collection normally
when the part is up.
Temporary There is a temporary problem that prevents collection for a time. As examples, the device could be shut
collection issue down for maintenance, there could be a problem in the network, or a problem with the collector process
itself.
Collection of this metric eventually resumes.
Device An entire device is decommissioned or removed from the infrastructure. The previously collected
decommissioned metrics never reappear. These are different use cases. For the most meaningful reporting, the system
distinguishes between these use cases and accommodates for them differently in the reports.
Reporting results
The following table shows the reporting results for the three collection gap use cases.
Steps
1. Go to Explore > Storage > Storage Systems.
The default report has visual cues set up based on thresholds. The visual cues are not related to alerts or notifications.
2. To view or change the threshold settings:
a. With the Storage Systems report in view, click Modifications > Edit Reports.
b. On the Report Details:Table tab, expand the blue bar for the Total time since last collection column.
c. Click Value Settings.
d. View or change the current threshold settings in the Thresholds Definition section.
e. To save the changes, click Save.
f. To return to the report, click BROWSE MODE.
3. To set up an alert, first schedule an alert on the report:
a. At the top of the report page, click Tools > Schedule this report.
Results
Whenever any storage array does not collect for more than the specified time (24 hours by default), an alert appears in the All
Alerts report.
If you click a row in the All Alerts report, a detailed report about that alert appears.
Steps
1. In the left navigation bar, click Home.
Link Goes to a pre-filtered All Alerts report. For Storage Systems, Fabric Switches, and Hosts, the All
Alerts report is filtered to show all critical alerts and any other alerts that are related to hardware
failures for the category type. For SRM Components, the All Alerts report is filtered to show all
critical and major alerts for SRM components.
Pie chart Shows the percentage of components in the category with serious problems. In the example, 50% of
SRM Components are experiencing problems.
2. To view details about the alerts in one of the categories, click the link at the top of the item.
The All Alerts report with filters appears.
3. To view complete details on a single alert, click that alert row.
The Alert Details report for the specified alert appears.
Prerequisites
Use an account with administrator privileges to perform most of these tasks.
Steps
1. Go to Report Library > System Health > Misc. Reports > Daily Dashboard , and scroll to the Web Servers (Tomcat)
report.
2. Check the following metrics:
3. Resolution: As needed, increase memory and quantity of vCPUs on the Web Server virtual machine. Continue to monitor
utilization.
Steps
1. Type these commands:
3. Resolution: If a service is down, determine if it is stopped for a reason. If not, start the service. If a service does not start,
investigate and resolve the problem.
Steps
1. To stop data loss, add a new VMDK to the VM and run expand_disk.pl to merge the new VMDK with the existing files
system.
2. On Linux servers, run the df -h command to check available disk space.
3. On Windows servers, open Windows Explorer and click Computer to check available disk space.
4. On the Dell EMC SRM Console, go to Report Library > System Health > Misc. Reports > Daily Dashboard and scroll to
the File Systems report.
Database health
Verify the health of the Dell EMC SRM databases.
Steps
1. Go to Report Library > System Health > Misc. Reports > Daily Dashboard, and scroll to the Databases report.
2. Verify the following:
❑ Current Metrics Count per database should be less than 3.2 million (3,200,000). This may require additional Java
memory.
3. Resolution: When these numbers are exceeded, the database is overloaded. Install an additional database, and redistribute
the metrics.
NOTE: The Dell EMC SRM upgrade service does not include this effort. If wanted, Dell EMC Professional Services can
assist with this effort.
Steps
1. Go to Report Library > System Health > Misc. Reports > Daily Dashboard and scroll to the Backends report.
2. Check the following:
Collector managers
Verify the health of the Dell EMC SRM collector managers.
Steps
1. Go to Report Library > System Health > Misc. Reports > Daily Dashboard and scroll to the Collector Managers
report.
3. Resolution: If overages exist, examine the server-specific reports to determine the causes.
Steps
1. Go to Report Library > System Health > Misc. Reports > Daily Dashboard, and scroll to the Servers Summary report.
2. Check the following metrics:
❑ CPU Utilization values should be less than 60% for Windows servers, but Linux servers can safely run at 90%
utilization.
❑ Swap Usage value should be 10% or less.
3. Resolution: For overages, perform troubleshooting on the server to find the process using the large amount of CPU or
swap space. Then make appropriate decisions, such as assigning more memory to resolve swapping.
Temporary files
Ensure that temporary files on the Backend servers are getting cleaned up appropriately.
Steps
1. Go to Report Library > System Health > Servers Summary.
3. If the server's Vapp Role is a Backend or AdditionalBackEnd, scroll down to find its Backends Temp Files Count report.
❑ Verify that the temporary file count rises and falls consistently.
5. Use the browser's Back button to return to the Servers Summary report, and repeat these steps for other Backend
servers.
NOTE: The temporary files count is not an issue for the Frontend and Collector roles. A Temp Files Count report does
not exist for those roles.
6. Resolution: If the file counts indicate that temporary files are not getting deleted automatically. It indicates a problem with
data insertion. Open a Service Request with Dell EMC Support.
Steps
1. Review logs from the Collector Manager for errors.
● The file pathname is:
Collecting/Collector-Manager/Default/logs/collecting-0-0.log
● To download from the Console, go to Administration > Logical Overview > Collecting > Collector-
Manager:: instance_name . In the right pane, expand the blue bar for Log files, select logs/collection-0-0, and
click Download.
2. Review logs from the Web Servers for errors.
● The file pathnames are:
○ Web-Servers/Tomcat/Default/logs/apg-tomcat-default.out . This is the log file for the current
Tomcat running instance.
○ Web-Servers/Tomcat/Default/logs/catalina.<date>.log . The system indicates if there are any
errors.
● To download from the Console, go to Administration > Logical Overview > Miscellaneous > Web-Servers >
Tomcat:: instance-name . In the right pane, expand the blue bar for Log files, select the files as named earlier, and
click Download.
3. Resolution: Troubleshoot the root cause of any errors as indicated by the error text. For additional assistance, open a
Service Request with Dell EMC Support.
Task completion
Verify that all Dell EMC SRM tasks on each server completed successfully during their last run.
Steps
1. Go to Administration > Physical Overview > server_name > Tasks.
3. Resolution: If tasks are unsuccessful without a known reason, contact Dell EMC support.
Data collection
Verify that data collection is occurring as expected.
Steps
1. Go to Report Library.
2. For each SolutionPack name, select Summary and check the following:
❑ Verify that data exists in the summary report, indicating that collection is occurring.
3. Resolution: If missing data is not expected, investigate whether it is a collection configuration issue, collector problem, or
discovery issue and resolve it. Otherwise, contact Dell EMC support.
d. To see more details for that alert and the related alert message, click a row in the Alerts report.
● This report helps you to set the ideal memory size for the JVM maximum memory setting (memory.max). The report
calculates the proper memory allocation for Dell EMC SRM Modules by computing the 15% of the 95th percentile Used
Memory to better use the memory resources of the servers.
● The memory.max setting should be rounded to the nearest multiple of 64: Value between 0 and 64: 64, Value between 65
and 128: 128
● The report shows each of the modules running and the memory consumption for each of those modules. It monitors
the maximum used memory for the last 24 hour period. It shows the currently allocated heap size and the optimal
recommendation for memory.
● It is best practice not to lower memory but increase it when needed.
Discover new If the SolutionPack adds support for a new type of device, the devices must be discovered before
devices they appear on reports. For procedures, see the SolutionPack-specific chapter in the Dell EMC SRM
SolutionPack Guide.
Configure new If the site is using consolidated alerting to show alerts from all devices in the storage infrastructure,
devices to send each device must be configured to send alerts to Dell EMC SRM. For procedures, see the SolutionPack-
alerts to Dell specific chapter in the Dell EMC SRM SolutionPack Guide.
EMC SRM
Enable or Most SolutionPacks install alert definitions for the SolutionPack's devices or features. Review them and
disable new alert decide which to enable or disable. For procedures, see the Dell EMC SRM Alerting Guide. For a list of
definitions alerts by SolutionPack, see the Alerts Matrix.
Configure and Many SolutionPacks install compliance policies and rules for the devices. If the site uses the compliance
enable new features, you should review them and decide which to configure and enable or disable. For procedures,
compliance and a list of policies, see the Dell EMC SRM User Guide for Storage Administrators.
policies and rules
Steps
1. Click Display at the top of any report page to show settings that control the reporting period.
2. Under Time Range Quick Switch, click the Maintenance Period calendar icon.
d. Click one or more squares in the calendar to specify the period to exclude from reports.
e. Click Save.
f. To return to the report, click BROWSE MODE at the top of the page.
The report configuration is changed for all users. The navigation path to the report remains the same as before.
Steps
1. Click Administration .
2. Go to CONFIG > Settings > Manage Online Update.
3. Ensure that you are on the Settings tab.
4. Check the Enabled checkbox.
5. Type the Dell EMC Online Support username and password.
The icon indicates that connectivity to the server has been established.
If a major update of the Dell EMC M&R Platform is detected, the Status tab is included with a Major Update Status section
that describes that the version that is available. It provides a link to the upgrade documentation, and includes a Start Download
button.
Prerequisites
If you want to update a single SolutionPack to receive the benefit of a required fix or feature, see Updating SolutionPacks and
other components Updating SolutionPacks and other components. For installation, configuration, and upgrade instructions for
each SolutionPack, see the dedicated SolutionPack articles.
Synchronize the packages across the servers:
1. From Administration > CONFIG > Settings, click Manage Package.
2. Click the Synchronization button.
3. Select retrieve the latest packages from the remote servers.
4. Wait for the synchronization to complete before proceeding.
Steps
1. From Administration > CONFIG > SolutionPacks > Installed SolutionPacks.
2. Click the Update All Components.
The Initialization window opens and lists the following details:
● Number of components from SolutionPacks that is updated to the latest version.
● Number of components that contain new features that require configuration.
3. Click Next. The Configuration window opens. The left-most pane lists each of the components that include new features
that you want to configure. The right-most pane displays the configuration details for the component with the new features
that are highlighted in yellow. Carefully review the selections to ensure the configuration details for the components and
SolutionPacks are correct, and modify any configuration that is not set correctly. When you have finished configuring a
component, click Next to move onto the next component. Edit some SolutionPack entries while reviewing the configuration:
For the SolutionPack for Dell EMC M&R Health, select the Front End hostname for the Web-Service Gateway.
4. After you have configured every component on the list, click Next.
5. The Confirmation window opens and lists all the components that are being updated. Confirm that all the components are
correctly listed, and then click Update.
6. The Update window opens and displays the progress of each update and the percentage complete of the overall update. Do
not close the browser window during this step.
The update process detects if any manual edits were made to the SolutionPack files. If a manually edited file is compatible
with the new version of the SolutionPack, it is reused and the system displays a message to let you know. If a manually
edited file is not compatible with the new version of the SolutionPack, the system backs up the file and displays a warning
message that indicates the name and location of the incompatible file. The backed up files are saved in their current
directory with the following format: <file-name>-old-<version>_<date>.<ext>
Messages about the following incompatible files can safely be ignored:
● tmsconfig.xml
● snmp-masks.xml
● slave-snmp-poller.xml
7. The Results window opens. Use the drop-down list to check the status of each component. Any manually edited files that
are backed up by the system is displayed under “Updated with warnings.”
Steps
1. Browse to the installed SolutionPacks page: https://<Frontend IP address>:58443/centralized-
management/#/sp
2. Depending on which SolutionPacks or components you want to update, click the required button:
Option Description
Update all the installed SolutionPacks Click the Update All Components button in the top-right corner of the page.
and other components
Update all the installed SolutionPacks Click the Select All button that is located below the SolutionPacks table, and then
click the Update button.
Update all of the installed other Click the Select All button that is located below the Other Components table, and
components then click the Update button.
Update individual SolutionPacks or In the SolutionPacks table or the Other Components table, click the update icon
other components
for the SolutionPacks or other components that you want to update.
6. The Results window opens. Use the drop-down list to check the status of each component. Any manually edited files that
were backed up by the system is displayed under “Updated with warnings.”
Steps
1. Go to the installed SolutionPacks page: http://<Frontend IP address>:58080/centralized-
management/#/sp
2. In the Other Components section of the page, click Add Component.
The Browse and Install Other Components page opens.
3. Click the component that you want to install.
4. Specify the server where you want to install the new component, and click Next.
5. If necessary, specify additional configuration settings.
6. Click Install.
1 Scale the Presentation layer horizontally based on the number of concurrent users.
2 Scale the Backend layer horizontally based on the number of metrics.
3 Scale the Collection layer horizontally based on the number of devices and sites.
Licensing concepts
Learn how to manage and troubleshoot Dell EMC SRM ELMS licensing. Learn how to upload license files, delete trial licenses,
verify available licenses, and synchronize licenses on multiple hosts.
Starting with Dell EMC SRM 3.0, Dell EMC SRM uses Dell EMC SRM the Electronic Licensing Management System (ELMS) for
licensing. Dell EMC SRM runs on the Dell EMC SRM platform, which uses a different licensing system.
To manage Dell EMC SRM licensing, get familiarized with permanent and trial licensing and the relationship between Dell EMC
SRM features and the Dell EMC SRM ELMS licenses.
Trial licenses
The Dell EMC SRM software can include all trial licenses or a combination of permanent and trial licenses.
Licenses that you purchase are permanent. Other software comes with trial licenses.
Trial licenses let you test features in the UI and perform some initial configurations before full purchase. Trial licenses typically
last for 30 days after the installation time. You cannot copy or regenerate a trial license in the product.
56 Licensing
If all the licenses are trial licenses, including the core software license that includes the Web Portal feature, the software can
lock out all users from accessing the UI when the trial expires.
License duration
Permanent licenses do not expire. Trial licenses have expiration dates, typically 30 days after the installation date.
When trial licenses expire, module license checks fail and the modules stop working. If the Web Portal module fails, you cannot
access the product.
Because the License Management UI operates behind the Web Portal module, you must upload the permanent license file or
extended trials before the 30-day license for the core features expires. Otherwise, the UI locks and you cannot upload the
license file. If it happens, see Troubleshooting licensing .
License purchase
To convert a feature from a trial license into a permanently licensed feature, purchase a license.
To start the purchase of a license for a SolutionPack or ReportPack, go to Dell EMC Online Support using the following URL:
https://support.emc.com/servicecenter/createSR/
On the page that appears, submit a service request to Dell EMC. Include the SolutionPack or ReportPack name that you want to
purchase.
When all purchasing transactions are complete, Dell EMC sends you instructions for downloading a regenerated license file for
the site that includes the newly purchased software license. Download the file to a local server, and then follow instructions in
Upload a new license file to upload the new license file into Dell EMC SRM.
NOTE: Until the license is purchased and the new license file is obtained and uploaded into Dell EMC SRM, the
SolutionPack is inoperable, unless the 30-day trial license is still in effect.
Licensing operations
Use the Dell EMC SRM Centralized Management UI to perform licensing management operations, such as uploading, verifying,
deleting, and synchronizing licenses.
Steps
1. Access Dell EMC SRM by typing the following URL in a web browser:
https://frontend-hostname:58443/admin
Where frontend-hostname is the server where the Dell EMC SRM frontend module is installed.
Licensing 57
View license information
You can view license information in two ways in Dell EMC SRM. One method displays licenses by host. The other one shows a
centralized view of all licenses.
Steps
1. Log in to Dell EMC SRM.
2. To view active licenses on a physical host, go to Administration > Home > Physical Overview > host-name .
3. Click the Licenses tab.
The host's Licenses tab opens, as shown in the following figure. The page shows the features with active licenses on that
host. It also indicates whether licenses are permanent or trial, the expiration date for trials, and additional license properties,
if applicable.
4. To view a consolidated list of licenses for all hosts, and to perform license management operations, in the navigation tree in
the left pane, click Licenses Management.
The Licenses Listing page opens showing all licenses on all servers.
The following figure shows this page. Notice the ELMS permanent license, showing all features included in the license and
the license serial number. Also notice the Upload and Synchronize commands at the top of the page.
58 Licensing
This table displays Information for ELMS licenses related to product name for the license, SWID, and serial numbers.
Prerequisites
1. Purchase the required licenses.
2. Download the new license file to a local server, as directed by Dell EMC during the purchase process.
Steps
1. Log in to the Admin UI in Dell EMC SRM using the following URL:
https://frontend-hostname/admin
2. Go to System Admin > Licenses and click Manage Licenses. Click Upload at the top of the page.
The License Upload dialog box appears.
3. Click Browse and locate the new license file that you downloaded.
4. Click OK.
The system extracts the licenses and displays them in the table on the Licenses Listing pane.
5. When the License Upload Complete dialog box appears, click OK, and then click Continue.
The new license automatically affects all servers capable of using the license.
Licensing 59
6. Delete the trial licenses that correspond to newly licensed features, if any.
To delete a trial license, see Delete licenses.
Delete licenses
You can select and delete specific licenses or delete all licenses. A delete action affects all servers that use the license.
Steps
1. Log in to the Admin UI in Dell EMC SRM using the following URL:
https://frontend-hostname/admin
Steps
1. Log in to the Admin UI in Dell EMC SRM using the following URL:
https://frontend-hostname/admin
Troubleshooting licensing
You can resolve common licensing problems.
Dell EMC SRM trial licenses typically last for 30 days after the installation time. To initiate the purchase of a permanent license,
go to Dell EMC Online Support page.
60 Licensing
Permanent license stops working after host reconfiguration
If you change the configuration of a host, for example, by adding interfaces, removing interfaces, or changing the operating
system, the permanent license might stop working. If the license does not work, obtain a new host ID and request a new
permanent license.
Prerequisites
Ensure that you have a login with root, Dell EMC SRM, or system administrator privileges to perform this task. The user apg is
the account that the application uses instead of root.
Steps
1. Log in to the operating system command line on the Dell EMC SRM host server.
2. To obtain the new host ID, run one of the following operating system commands:
The command output is the new Dell EMC SRM host ID.
3. Copy the host ID information to the clipboard or to a text file.
4. To obtain the new license, go to the Dell EMC support site using the following URL: https://www.dell.com/support.
The Create a Service Request page appears.
5. Submit a service request to Dell EMC, asking for a new permanent license file for a new host. Paste the new host ID into the
request.
6. When Dell EMC sends you the new license file, follow the procedure for uploading a new license file.
Prerequisites
● Ensure that you have an operating system account with root, apg, or system administrator privileges. The application uses
the apg account, instead of root.
● Acquire a new license file from Dell EMC, and download it to a local server. To request a new license file, create a Service
Request on Dell EMC Online Support.
Steps
1. Log in to the server where the Dell EMC SRM core software is installed.
2. Copy the new, valid license file to this same server. The file is a .zip file.
Licensing 61
3. At the operating system command line, go to the bin directory.
4. Install the license file using one of the following commands appropriate to the operating system:
NOTE: The command installs the license file on this server only.
Prerequisites
● Install the new license file using operating system commands.
● Ensure that the library search path is correct on the server that is the host for the core software. This requirement applies
to the libstdc package on a Solaris server and the libaio package on a LINUX server.
Steps
1. Log in to the server where the Dell EMC SRM core software is installed.
2. At the operating system command line, go to the bin directory.
3. Run one of the following commands appropriate to the operating system:
Steps
1. Open a browser and log in to the Admin UI in Dell EMC SRM using the following URL:
https://frontend-hostname/admin
62 Licensing
The License Upload dialog box appears.
4. Click Browse and locate the new license file.
5. Click OK.
The system extracts the licenses and displays them in the table on the Licenses Listing pane.
6. When the License Upload Complete dialog box appears, click OK, and then click Continue.
The new license automatically affects all servers capable of using the license.
7. In the License Listing table, select all expired trial licenses by clicking the check boxes.
8. Click Delete.
The Delete command appears at the bottom of the page, below the table of licenses.
The delete action automatically affects all available servers.
Steps
1. Log in to the Admin UI in Dell EMC SRM using the following URL:
https://frontend-hostname/admin
Licensing 63
Table 12. Features in ELMS SRMSUITE_GENERAL (continued)
Feature Name
SolutionPack for IBM LPAR
SolutionPack for IBM SVC V7000
SolutionPack for Microsoft Hyper-V
SolutionPack for Microsoft SQL Server
SolutionPack for Oracle Database
SolutionPack for Oracle MySQL Database
SolutionPack for Physical Hosts
SolutionPack for Configuration Compliance
SolutionPack for VMware vSphere & vSAN
NOTE: The Backend Adapter for this license allows for 1 million devices and 4 million metrics per device.
64 Licensing
8
Dell EMC SupportAssist
Topics:
• Dell EMC SupportAssist
• Configure Dell EMC SupportAssist
• Running and scheduling the Dell EMC SupportAssist task
• Configuring an SSL truststore
• Configuration information sent to using Dell EMC SupportAssist
• Customer usage information sent to Dell EMC using Dell EMC SupportAssist
• Reconfiguring the esrs-query-config SolutionPackBlock
• Alerts sent to using Dell EMC SupportAssist
Prerequisites
● Dell EMC SupportAssist V3 (Virtual Edition) must be running in a supported VMware ESXi or Microsoft Hyper-V
environment.
● A valid ELMS license must be installed. (Dell EMC SupportAssist does not work with a trial license.)
● You need valid Dell EMC Online Support credentials.
● Opening port 22 on both the Dell EMC SRM frontend host and the Dell EMC SupportAssist host is required for additional
communication between the two components.
● Optional: For validated SSL communications, a truststore is required to validate the server's SSL certificate.
Steps
1. In Administration, click CONFIG > Settings > Dell EMC SupportAssist Settings.
8. To test connectivity to the Dell EMC SupportAssist server, click the icon.
The icon indicates that connectivity to the server has been established.
Steps
1. In Administration UI, go to CONFIG > Settings > Scheduled Tasks .
2. Type SupportAssist in the search field.
3. Click the Dell EMC SupportAssist task.
The Properties window for the task opens.
4. The Dell EMC SupportAssist task is disabled by default. If it has not yet been enabled, click Enable.
5. To expand it, click the Configuration Files section.
6. Select the checkbox for the Dell EMC SupportAssist task, and then click the Edit File icon.
The configuration file opens.
7. Change the schedule by editing the cron expression. The expression for the default setting (once a week) is "0 0 * * 0".
Example: To change the schedule so the task runs once a month at midnight on the morning of the first day of the month,
change the cron expression to "0 0 1 * *".
8. Click Run Now if you want to test the task.
9. Click Save.
Steps
1. If an SSL certificate has not been issued, you can use the certificate that the Dell EMC SupportAssist VE is using.
a. Go to the VE site.
Steps
1. Go to the installed SolutionPacks page: https://frontend-hostname:58443/admin.
2. Click Config > SolutionPacks > Installed SolutionPacks.
3. Under Other Components, click the Reconfigure icon for the ESRS-Query-Config instance.
4. From the Frontend Web service drop-down list, select Add a new FrontEnd Web service.
5. In the Tomcat hostname or IP address field, type the hostname or IP address of the host from which you want esrs-
query-config to gather instance details.
SSL certificates
Generally, Dell EMC products are distributed with a self-signed SSL certificate. If you receive an SSL certificate error or a blank
pane when you are trying to access content that is served by a data source, you may be able to resolve the issue by doing one
of the following procedures.
SSL certificate error examples provides a list of sample errors.
Temporary resolution
Accept the certificate exception temporarily: Troubleshooting an SSL certificate error: Accepting the exception.
Permanent resolution
Add an SSL certificate to the truststore to permanently prevent the exceptions from appearing.
70 Troubleshooting procedures
You can: Perform:
Install the self-signed SSL certificate that is provided with the Installing a self-signed SSL certificate from an Internet
Dell EMC product using an Internet Explorer browser. Explorer browser
Install the self-signed SSL certificate that is provided with the 1. Export the self-signed SSL certificate to save it to the
Dell EMC product using a Chrome or Firefox browser. export location: Exporting an SSL certificate from an
Internet Explorer browser
2. Importing an SSL certificate into the truststore
Import an exported SSL certificate that you or another Importing an SSL certificate into the truststore
administrator prepared.
If you want to prepare an SSL certificate to share with other users, use: Exporting an SSL certificate from an Internet Explorer
browser.
Content was blocked because it was not signed by a valid security certificate.
Steps
● Accept the exception.
Steps may vary for the browser. For example, for Internet Explorer, click Continue to this website (not recommended).
This temporary solution causes the exception to be ignored for the current browser session, but the exception reappears if
you open another browser tab or window.
Troubleshooting procedures 71
Installing a self-signed SSL certificate from an Internet Explorer
browser
Install the self-signed SSL certificate that is provided with the Dell EMC product to prevent certificate exception errors.
Steps
1. Click Continue to this website (not recommended) in the browser window.
2. Click the red Certificate Error indicator next to the address bar.
3. In the Untrusted Certificate window, select View certificates.
4. In the Certificate dialog box, in the General tab, click Install Certificate.
5. Follow the instructions in the Certificate Import Wizard.
a. Select the Place all certificates in the following store setting to add the certificate to the truststore.
6. In the Certificate dialog box, in the General tab, click OK.
Next steps
Refresh the browser window.
Prerequisites
See the latest Dell EMC SRM Support Matrix document for supported versions used with Dell EMC SRM.
Steps
● Import the certificate using one of the following procedures:
○ Importing an SSL certificate in Chrome
○ Importing an SSL certificate in Firefox
○ Importing an SSL certificate in Internet Explorer
Steps
1. Go to Settings > Show advanced settings.
2. Scroll down, and select HTTP/SSL > Manage Certificates.
3. In the Trusted Root Certification Authorities tab, click Import.
4. To import the certificate, follow the instructions in the Certificate Import Wizard.
5. Click OK in Internet options.
6. Refresh the browser window.
72 Troubleshooting procedures
Importing an SSL certificate in Firefox
For Firefox, use this procedure to import the certificate into the truststore.
Steps
1. Go to Firefox > Options > Options.
2. Click Advanced.
3. In the Certificates tab, click View Certificates.
4. Click Import.
5. Locate the certificate file, and click Open.
6. Click Save.
7. Click OK in Certificate Manager.
8. Refresh the browser window.
Steps
1. Go to Tools > Internet options.
2. In the Content tab, click Certificates.
3. Select the Trusted Root Certification Authorities tab.
4. Click Import.
5. To import the certificate, follow the instructions in the Certificate Import Wizard.
6. Click OK in Internet options.
7. Refresh the browser window.
Steps
1. Access the host for which you want to export the SSL certificate from the browser.
For example: https://<myHostname>.emc.com
2. Select Continue to this website (not recommended) in the There is a problem with this website's security
certificate window.
3. Click the red Certificate Error indicator next to the address bar.
4. In the Untrusted Certificate window, select View certificates.
5. In the Certificate dialog box, select the Details tab and ensure that the Show field is set to All. Click Copy to File.
6. In the Certificate Export Wizard,
a. Click Next in the Welcome screen.
Troubleshooting procedures 73
b. Click Next to accept the default DER encoded binary X.509 setting in the Export File Format screen.
c. Browse to the location where you want to save the certificate.
d. Specify the certificate file name, and click Save.
e. In the File name field, ensure that the location and the certificate file name are correct. Click Next.
f. Click Finish.
g. Click OK when The export was successful appears.
7. In the Certificate dialog box, click OK in the Details tab.
8. Share the resulting exported SSL certificate with other users to use.
Steps
1. After the completion of at least three collection cycles, verify if data is populating into the reports. If there is still no data in
the reports, continue to the next step.
2. To import data into reports, run the scheduled task. If there is still no data in the reports, continue to the next step.
3. To view the log files for errors, browse to System Admin > Logs & Diagnostics > Log Files > Collector-
Manager::< instance name >.
Prerequisites
Allow at least three polling cycles to pass before manually running the scheduled task.
Steps
1. Click System Admin.
2. Click Settings.
3. Expand Scheduled Tasks.
4. Select Database.
5. Click Run Now.
6. Confirm success in running the task in the Last Result and Last Result Time columns.
Steps
1. Run the scheduled task to import data into reports. If there is still no data in the reports, continue to step 2.
2. Search for the metric in the database.
74 Troubleshooting procedures
3. To view the log files for errors, System Admin > Logs & Diagnostics > Log Files > Event-
Processing_Manager::Instance name.
To troubleshoot the errors, enable the Event-Spy for the Event Processing Manager.
Steps
1. Click Administration .
2. Under System Admin > System Operations, click Manage Database Metrics.
3. On the Metric Selection page, create the filter, type the number of results, and select the properties to display for the
metric.
For example, to list up to 100 results of the Capacity metric with the properties of device and IP, type name=='Capacity'
in the Filter field, 100 in the Maximum results field, and select device and IP for the Properties to show.
4. Click Query.
A list of the metric results appears. If nothing displays, the metric is not being collected.
Steps
1. Go to User Interface > Report Library.
2. To view its reports, click the SolutionPack.
Results
It may take up to an hour to display all relevant information in these reports.
NOTE: When you install Dell EMC M&R 7.0u6, by default it is installed in the HTTPS mode.
Steps
1. In the /opt/APG/Web-Servers/Tomcat/Default/conf/server.xml file:
a. Locate and remove the entry redirectPort="58443"
Troubleshooting procedures 75
Before removing the entry redirectPort="58443", it appears as follows:
Steps
1. Log in to a UNIX server with root access.
2. Access the diagnostic.sh script at /opt/APG/Tools/APG-Diagnostic-Tools/Default/bin/
diagnostic.sh and run it.
If Dell EMC SRM is installed as Minimal, the script is missing from the installation and you should run # manage-
modules.sh install diagnostic-tools to install the script.
Output from the script goes into a Zip file in the /tmp/ directory. The output file name is APG-
DiagnosticFiles.tar.gz
3. Upload the output file into a Service Request or if the file is large, to an FTP site specified by Customer Support.
Steps
1. Log in to a Windows server and open a command window.
2. Go to the folder <%INSTALL_ROOT%>\Program Files\APG\bin.
If Dell EMC SRM is installed as Minimal, the diagnostic.cmd script it missing and run manage-modules.cmd
install diagnostic-tools to install the script.
3. Run diagnostic.cmd.
Output goes into the file C:\Program Files\APG"\APG-DiagnosticFiles.zip.
4. Upload the file into a Service Request or if the file is large, to an FTP site specified by Customer Support.
76 Troubleshooting procedures
Detect and repair database crashes
Steps to detect and repair database crashes.
Steps
1. Perform a weekly check:
a. Browse log files.
The following logs for MySQL and Backends can be checked:
i. /opt/APG/Databases/MySQL/Default/logs
ii. /opt/APG/Backends/APG-Backend/Default/logs
On Additional Backend:
i. /opt/APG/Backends/APG-Backend/apg1/logs
ii. /opt/APG/Backends/APG-Backend/apg2/logs
iii. /opt/APG/Backends/APG-Backend/apg3/logs
iv. /opt/APG/Backends/APG-Backend/apg4/logs
Other than these logs, there are logs for scheduled tasks, which can be checked from the UI as well.
b. Check for suspicious errors.
2. If you find slow reports, data missing, a portal hanging, and so on, suspect a database failure and closely check the log files.
For instance, if the database crashes from an import-properties" task, you may receive errors like the following:
Enter password:
# Connecting to 127.0.0.1...
apg.cache_group_0_1401278400 OK
[...]
apg.cache_group_86400_1399680000 OK
apg.data_property
error : Size of datafile is: 2 Should be: 3758440
error : Corrupt
apg.data_property_flat Table is already up to date
apg.data_variable OK
Repairing tables
apg.data_property
Error : Incorrect information in file: './apg/data_property.frm'
Troubleshooting procedures 77
error : Corrupt
# Disconnecting from 127.0.0.1...
4. Depending on the severity of the failure, you may or may not be able to restore the table.
You may must restart affected services.
Steps
1. Click the down-arrow next to the quick search field.
A popup screen appears.
2. To display a list of options, click the Filter field and select Edit expression.
3. Type an expression. For example:
device=='000195700930'
4. Click OK.
5. In the Expansion field, replace “device” by "device, source."
6. In the field Search Base, click the down-arrow and select search from root.
7. Click Apply.
All devices that meet the search criteria and all collectors that are associated with them are displayed. The name of the
collector enables you to identify the SolutionPack associated with the collector.
You can filter the column using the filter icon that is displayed in the table title.
VM Utilities Manager
VM Utilities Manager overview
The VM Utilities Manager allows you to install and remove debugging utilities from the VMs in a vApp deployment of the SRM.
The following utilities are available:
78 Troubleshooting procedures
● man
● tcpdump
● netcat
● net-snmp
● sysstat
● iotop
The VM Utilities Manager is available through a GUI and a CLI.
Steps
1. Open the GUI by entering vmutils-manager.sh from any directory on the VM.
The GUI provides a checklist of available utilities. The checklist displays checkmarks next to any of the
utilities that are already installed. The following screenshot shows the default checklist with no utilities installed.
2. To install a utility, click the checkbox next to the utility you want to install.
3. To uninstall a utility, clear the checkbox next to the utility that you want to uninstall.
4. Select OK.
The Managing Utilities progress screen opens and shows the progress of the installation and/or uninstallation activities.
Steps
1. To install a utility, type the following command from any directory:
vmutils-manager.sh -i <utility name>
For example: vmutils-manager.sh -i iotop
2. To uninstall a utility, type the following command:
vmutils-manager.sh -u <utility name>
For example: vmutils-manager.sh -u iotop
You can install and/or uninstall multiple utilities with a single command. Regardless of the order of the arguments at the
command prompt, the script always starts the uninstall action first.
Troubleshooting procedures 79
Log files
The VM Utilities Manager provides 2 log files.
80 Troubleshooting procedures
10
About the datastore
This chapter contains the following topics about the underlying datastore for Dell EMC SRM.
Topics:
• Overview
• Usage
• SQL syntax
Overview
Learn the fundamentals of querying the Dell EMC SRM Datastore.
The Dell EMC SRM Datastore is the underlying database engine that is used in the APG Datastore module starting at version
5.0. The datastore is a standard database engine that uses its own native query language (X100). However, all the relational
concepts (and more) are available by using a SQL converting JDBC driver.
A single datastore can only host a single database without schema support. It means that all the tables are in the same
namespace, therefore they have to be correctly qualified.
The datastore is listening on port 53308 by default, it can be changed in the conf/module.properties file with the
database.port setting. When set to 0, the port is randomly chosen. The datastore is always listening on 0.0.0.0 (all
interfaces) and there is no way to change it currently. The port is protected by a randomly generated hash which is stored in
data/default/authpass and recreated each time that the service starts.
When a client connects to the database: it first goes through the webservice-gateway to get the port number and the random
token, and then it connects to the actual server listening on the retrieved port and uses the retrieved token. It means that if the
machine is firewalled, both 48443 (the webservice gateway) and 53308 (the datastore) have to be opened.
Usage
There are two ways to use the database:
● Through one of the APG modules, such as the Datastore Writer or Web Portal
● Through the CLI built-inside the APG-Datastore module (/opt/APG/bin/datastore-client.sh)
JDBC driver
To use the driver, you must ensure the driver class (com.watch4net.x100.jdbc.Driver) has been classloaded. The JDBC
driver handles the following URL:
jdbc:x100://localhost:48443/Databases/APG-Datastore/Default
(1) (2)
Where:
● (1) is the host and port of the Webservice Gateway running on the same host as the database server
● (2) is the path to the Datastore module you are talking to
The following connection properties are honored:
● user and password: are the two standard JDBC properties that are used to specify the username and password are the
Web Service gateway credentials for the driver.
● ssl and sslVerify: These two flags control how to connect to the Web Service gateway. By default ssl=true and
sslVerify=false, meaning that HTTPS is used to connect to the gateway but the certificate is not verified.
CLI
The APG Datastore module comes with a CLI which can connect to a local or remote instance. The CLI is installed
as /opt/APG/bin/datastore-client.sh.
Cli [<database>] [--debug] [--host (-h) <host name>] [--mode [x100 | sql]] [--password
(-p) <password>] [--port (-P) <port number>] [--ssl [on | off | strict]] [--user (-u)
<user name>]
<database> : the database path (default: auto)
--debug : enable debug mode
--host (-h) <host name> : the host name (default: 'localhost')
--mode [x100 | sql] : the session mode (default: 'sql')
--password (-p) <password> : the password (default: auto)
--port (-P) <port number> : the port number (default: auto)
--ssl [on | off | strict] : the SSL mode (default: auto)
--user (-u) <user name> : the user name (default: auto)
When used locally, the CLI can be started without any argument since it can connect automatically to a local datastore instance
without any authentication (since it can bypass the webservice gateway and talk to the datastore service directly).
Connected to jdbc:x100://localhost:43138/ !
sql>
When used remotely (hostname is specified and is not localhost), the CLI uses arguments similar to the MySQL CLI:
Connected to jdbc:x100://w4n-dl-test1:48443/Databases/APG-Datastore/Default !
sql>
Table definition
The general syntax is:
Query
The general query syntax is:
NOTE:
● Duplicates in the select clause are not allowed.
● JOIN is not supported, table has to be a single table name.
● GROUP BY and ORDER BY can reference column names or aliases that are defined in the select clause. When an
ambiguity arises, aliases are preferred.
● GROUP BY does not support MySQL specific syntax where columns other than the GROUP BY ones or aggregations
can be specified in the select clause (for example: SELECT a, b FROM table GROUP BY a). It is however allowed
for constants (for example: SELECT 1, a, sum(b) FROM table GROUP BY a).
● Multiple queries can be merged together using UNION ALL only. UNION is not supported. In this situation, ORDER BY
and LIMIT apply to the resulting union, not individual queries.
● While the data store does not natively support schema, the SQL conversion layer offers a sys schema which allows
accessing internal system tables. The list of available system tables and columns can be retrieved with SELECT *
FROM sys.sys_tables / SELECT * FROM sys.sys_table_columns.
NOTE: By default, update propagation is disabled. It means that deletes (and updates) are not applied onto data but stored
instead as a difference on data (It is called the Positional Delta Tree). If deleted rows are not consecutive, it can get
significant and a manual update propagation operation might be necessary.
Loading
The loader can be invoked with:
Select *
The data store does not natively support the concept of selecting all columns of a table. However, it is handled at the
conversion layer and used naturally in SQL as a typical SELECT *. The downside is that before every query which contains a
SELECT *, the driver has to issue a first query to retrieve column names.
|
|
\ /
v
Project (
Project (
Project (
MScan ('test', ['__SELECT_ALL__'])
, [__SELECT_ALL__])
, [__SELECT_ALL__])
, [__SELECT_ALL__])
|
|
\ /
Project (
Project (
Project (
MScan ('test', ['i', 'j', 'k'])
, [i, j, k])
, [i, j, k])
, [i, j, k])
Table expansion
Since partitioned tables are used, table expansion was added to the SQL conversion layer to make queries on them easy. The
table expansion has different syntaxes and works on all the supported queries (select, delete, create table, ...).
In general, if a table name contains one of the table expansion tokens that are listed here, the query is going to be transparently
dispatched across the matching tables. The behavior is the same as doing the query on the union of the matching tables
(meaning that cross table aggregation, order, ... works).
__ALL__ (catch-all)
The catch-all syntax allows selecting tables using a pattern. Wherever found in the table, it is considered as a * wildcard to
match table names. The downside is that before every query which contains a table containing __ALL__, the driver has to
issue a first query to retrieve table names.
For example, if the database contains three tables: my_table, your_table and other, running a query on __ALL__table
uses my_table and your_table.
|
|
\ /
v
Project (
Project (
Aggr (
Project (
MScan ('__ALL__table', ['__tid__'])
, [__tid__])
, [], [
_aggregatenode_7d15d06c = count(*)
], 1)
, [_aggregatenode_7d15d06c])
, [_aggregatenode_7d15d06c])
|
|
\ /
v
Project (
Project (
Aggr (
Project (
Union (
MScan ('my_table', ['__tid__'])
,
MScan ('your_table', ['__tid__'])
)
, [__tid__])
, [], [
_aggregatenode_7d15d06c = count(*)
], 1)
, [_aggregatenode_7d15d06c])
, [_aggregatenode_7d15d06c])
__SEQ_n_m__ (sequence)
|
|
\ /
v
Project (
Project (
Aggr (
Project (
MScan ('table__SEQ_1_2__', ['__tid__'])
, [__tid__])
, [], [
_aggregatenode_9d686c1 = count(*)
], 1)
, [_aggregatenode_9d686c1])
, [_aggregatenode_9d686c1])
|
|
\ /
v
Project (
Project (
Aggr (
Project (
Union (
MScan ('table1', ['__tid__'])
,
MScan ('table2', ['__tid__'])
)
, [__tid__])
, [], [
_aggregatenode_9d686c1 = count(*)
], 1)
, [_aggregatenode_9d686c1])
, [_aggregatenode_9d686c1])
Troubleshooting
Since the driver does not know the database schema and the data store does not return an error message when a query fails,
understanding why a query fails can be challenging. Here are a few hints:
● Always run the CLI using the --debug option. It gives you the complete error message and not just the outermost.
● When the error message starts with Error while parsing query ..., it means that the query cannot even be
parsed. When this error occurs, the query never reached the database engine. It is most likely an error in the query, and the
full stacktrace gives more detail on what the exact issue with it is.
● When the error message contains an error occured executing query ..., it means that the query has
been converted to a native database query successfully but its execution on the database engine failed. Frequent
causes are misspelled table or column names. Since no error message is given to clients, you must check the
database log file (Databases/APG-Datastore/Default/logs/database-0-0.log) and look for error messages
like your_table.a not found in ColumnBM, which means that the table or column cannot be found.
Documentation Feedback 87