Foglight for Databases® 6.3.0.2
Release Notes
May 2023
Resolved issues and enhancements
Quest's Foglight® solution simplifies application performance monitoring and reduces the skills and effort required to manage applications, the user experience, and the supporting infrastructure.
Unlike other solutions, Foglight uses a single code base, and has a model-driven design that couples fast deployment and accelerated time-to-value. It offers the modular flexibility required to deliver a range of capabilities and sophistication to meet the needs of any organization—from those still focused on technology-centric monitoring to those that have completed the transition to application-centric or transactional monitoring.
Foglight performs equally well in physical, virtual, and mixed infrastructure environments, providing visibility into issues affecting the application and end-user experience. Intuitive workflows help you quickly move from the symptom to the root cause in the application, database, infrastructure, or network to resolve issues, reducing mean time to resolution. Predefined and drag-and-drop dashboards provide insight that is tailored to each stakeholder. By offering comprehensive visibility into your monitored environment, Foglight helps ensure that cross-functional teams collaborate on and prioritize issues that matter most to the business.
These Release Notes cover the resolved issues, known issues, workarounds, and other important information about the 6.3.0 release of Foglight for Databases. Review all sections before starting the installation.
Version 6.3 of Foglight contains the following new features and updates:
User Experience Enhancements
Security Enhancements
Improvements
PagerDuty cartridge is provided without the need for a special license (FOG-4816)
Enhance Databases Global view support for SAP HANA, Redis, Redshift, and Snowflake
The following is a list of issues addressed and enhancements implemented in 6.3.0.2 Foglight for Databases hotfix release.
Defect ID |
Resolved Issue |
Cartridge |
FOG-5517 | Enabled overview links for Redis, SAP Hana, Snowflake & RedShift in the GV table |
Foglight for Databases Global View
6.3.0.11 |
FOG-5819 | Fixed charts titles for light theme view |
Foglight for SQL Server
6.3.0.20 |
FOG-5803 | Fixed the typo in resultset limiter of DBO_Data_Guard_Destination_Status_ONE_NODE collection | Foglight for Oracle 6.3.0.20 |
FOG-5823 | Fixed the missing v$px_session permission in Oracle grant script |
Foglight for Oracle 6.3.0.20 |
FOG-5844 |
Fixed navigating from Sql-PI tab to to other tabs don't preserve selected MySql instance |
Foglight for MySQL 6.3.0.11 |
The following is a list of issues addressed and enhancements implemented in 6.3.0 Foglight for Databases release.
Defect ID | Resolved Issue | Domain |
FOG-2006 | Ability to use an OS non-administrator user for monitoring SQL Server. View the Foglight Agent Manager guide for more details. | SQLServer |
FOG-4468 | Ability to skip providing power user credentials while using CLI to install a secondary AG node | SQLServer |
FOG-4994 |
Automatically recover from situations where connection in pools becomes invalid |
SQLServer |
FOG-3817 |
Fixed- DBSS Long Running Session Alarm fire according to the filter set |
SQLServer |
FOG-4705 |
Replaced Microsoft JDBC Driver to a higher level to overcome errors “Encounter TDS_COLMETADATA” |
SQLServer |
FOG-4752 |
Fixed- DBSS_database collection fails when the monitored instance has a database using case-sensitive charset |
SQLServer |
FOG-4566 |
Fixed- Plan Handle is abbreviated on the Plan Analysis dashboard |
SQLServer |
FOG-4222 |
Fixed- DBSS_Database_Tables_List show incorrect row count for large partitioned tables |
SQLServer |
FOG-4242 |
Add Flag to determine if vss copies are considered as valid backups or not. default - yes |
SQLServer |
FOG-3678 |
Fixed- Cannot display TSQL Batch data sometimes |
SQLServer |
FOG-3925 |
Fixed- cannot use SQL PI with DB agent having special characters in display name |
SQLServer |
FOG-3935 |
SQL Server User Defined Collection support SQL_VARIANT on MSSQL JDBC driver |
SQLServer |
FOG-4153 |
Fixed- Database Groups is not created as a Service when running installer via CLI |
SQLServer |
FOG-4022 |
Fixed- High CPU and threads consumption when monitored instance is unavailable |
SQLServer |
FOG-4242 |
Add Flag to determine if vss copies are considered as valid backups or not. default - yes |
SQLServer |
FOG-3678 |
Fixed- Cannot display TSQL Batch data sometimes |
SQLServer |
FOG-3925 |
Fixed- cannot use SQL PI with DB agent having special characters in display name |
SQLServer |
FOG-3935 |
SQL Server User Defined Collection support SQL_VARIANT on MSSQL JDBC driver |
SQLServer |
FOG-4153 |
Fixed- Database Groups is not created as a Service when running installer via CLI |
SQLServer |
FOG-4022 |
Fixed- High CPU and threads consumption when monitored instance is unavailable |
SQLServer |
FOG-5146 |
Added ability to config PI repository to use SSL using parameter |
SQLServer |
FOG-3735, FOG-5360 |
Fixed- Clicked on View SQL Text and then it spawns an empty pop-up |
Oracle |
FOG-4441 |
Fixed- CPU/RAM not collected for Oracle on AIX |
Oracle |
FOG-5306 |
Fixed- Oracle PI shows the wrong number of executions for parallel executions |
Oracle |
FOG-4972 |
Fixed- Oracle instances are sometimes missing from the Global View dashboard |
Oracle |
FOG-4919 |
Fixed- ORA-1000 (Maximum Number of Cursors Exceeded) error in Oracle PI. |
Oracle |
FOG-4737 | Enhanced Oracle supported character sets | Oracle |
FOG-4630 | Fixed- Connectivity Validation collection set the wrong instance status | Oracle |
FOG-3443 | Allow monitoring Oracle target set to read-only | Oracle |
FOG-5260 | Fixed- Unable to monitor Dataguard when SSL is required | Oracle |
FOG-3887 | Fixed arithmetic overflow in SAP/ASE collection | SAP ASE |
FOG-4835 | Fixed - DBSpace collection sometimes failes due to missing temp table | SAP ASE |
FOG-3798 | Fixed - Empty client id or secret on first login | Foglight |
FOG-4485 | Change default server URL to use HTTPS | Foglight |
FOG-4141 | The algorithm used for the encryption of the password of the Foglight repository was changed to AES-256 for increased security | Foglight |
FOG-4299 | Fixed- Notification channel not allow more than 3 levels in the domain | Foglight |
FOG-4217 | Alarm Template and Notifications dashboards does not require the Administrator role. Only the “Alarm Management Administrator” role | Foglight |
FOG-4141 | Update server to use AES-256 encryption in non-FIPS mode | Foglight |
FOG-4736 | Update SQLServer JDBC driver in FMS | Foglight |
FOG-3832 | Fixed - MariaDB prerequisites check will always return missing prerequisite | MYSQL PI |
FOG-3798 | Collect statements that run inside packages | MYSQL PI |
FOG-3814 | Fixed get digest text | MYSQL PI |
FOG-2613 | Improve database global view for SMA agents | MySQL, Postgress, Cassandra, MongoDB, |
FOG-4018 | Fixed - MongoDB agents are not listed in the Database dashboard after upgrade to 6.1 | MongoDB |
The following is a list of issues known to exist at the time of this release.
Note: Check the release notes for each cartridge you will be using for known and late-breaking issues with that cartridge.
For a list of known issues for Foglight Agent Manager in this release, see the Foglight Agent Manager 6.3.0 Release Notes.
Foglight for Automation is not supported:
See below for details. These limitations will be addressed in a future release.
When a Foglight Management Server running in High Availability mode fails over, all in-progress tasks fail and the system cannot recover them.
The Foglight Cartridge for Automation should not be installed, and workflow automation must not be used, on a Foglight Federation Master. This is because active tasks that update topology objects are not permitted on the Federation Master. Workflow automation may be installed and used on the Federated Child(ren) as usual.
Defect ID |
Known Issue |
FOG-3615 |
Notification emails body prefix formatting may show as one big line
instead of separated lines. Workaround: add dot "." at the end of each line you add to the email body prefix |
FOG-3589 |
In the Notification Channel dashboard, on the "Alarms" tab an "Error
occur" message is displayed sometimes. Workaround: Move to another domain in the same alarm template. |
WCF-15913 |
Custom rules (which are copied from existing cartridge rules) will drop some tables or charts that exist in the original Alarm dialog. Contact Quest Support for workaround. |
FGL-20162 |
Running Foglight 5.9.5 on Windows Server 2008 requires upgrading PowerShell to version 3.0. |
FGL-19877 |
Upgrading to version 5.9.3 completes successfully but the installation log contains shortcut creation failures. |
FGL-19479 |
The Management Server UI will possibly be displayed abnormally if Tomcat version is upgraded. Workaround: Clear the cache data of your web browser. |
FGL-19431 |
If you toggled enable/disable state for Alarm Integration, Incident Integration, Clear Integration Alarm, or QMX Agent Host Connection Rule rule in the Integration cartridge, its enable/disable state will be reset after upgrading to 5.9.x from 5.7.5.8. |
FGL-19283 |
When upgrading the Management Server from 5.7.5.8 to 5.9.x, unexpected CartridgeDeploymentException shows in the log file. Workaround: This exception only occurs in environments with those cartridges which define Java Archive or JBoss Artifacts component, like Integration and IntelliProfile cartridges. JBoss Server has been removed from the Management Server 5.9.x. As a result, JBossDeploymentHandler, which was used to handle above components, has also been removed from the Management Server 5.9.2 or later. If you encounter this issue, you could ignore it as this exception does not impact upgrade of the Management Server and relevant cartridges. |
FGL-18953 |
EU appliances may fail connecting the Foglight Management Server after
the initial installation of Foglight Management Server. |
FGL-18611 |
LDAP accounts may fail binding to the OU group whose name includes backslash characters '\'. This can prevent Foglight to authenticate LDAP users. |
FGL-18470 |
FSMService availability calculations do not work as expected in a service hierarchy. |
FGL-18125 |
FoglightShutdownAction.checkInUsedPort() does not load port settings from server.config during an upgrade. |
FGL-18122 |
In a Windows Single-Sign ON (SSO) with untrusted multiple domains, only the user with the keytab file-corresponding group can be imported. |
FGL-18076 |
The Management Server data-driven multiple severity rules may fire multiple times for the same severity in case of concurrent data submissions. |
FGL-18075 |
The rule engine may pass non-persisted alarm IDs to rule actions. This can prevent some alarms, that are generated multiple times against the same scoping object, from firing. |
FGL-18034 |
PostgreSQL fails to start up while installing the Management Server with an embedded PostgreSQL database on a Korean OS. |
FGL-17845 |
Failing to start the Management Server with the --host=*.*.*.* option due to a failed attempt to start the embedded database. |
FGL-17826 |
LDAP users may have to log in twice to get proper role assignments. |
FGL-17769 |
Foglight is configured with a list of default ciphers. Some of these ciphers are potentially vulnerable ciphers. A review of the ciphers that will be available in a future release is ongoing. Workaround: Edit the list of ciphers by completing the following steps:
For complete information, visit
http://tomcat.apache.org/tomcat-7.0-doc/config/http.html.
|
FGL-17768 |
The Management Server distribution layout contains some confusing directories under server/jboss. |
FGL-17415 |
ObservationQueryPlan$QueryStep.getDayIndex(...) can result in ArrayIndexOutOfBoundsExceptions during a Daylight Savings Time (DST) change. |
FGL-17162 |
Core monitoring policy derivations are not deployed on a Federated Master. |
FGL-17055 |
Excluded objects are sometimes included in a Federation topology synchronization. |
FGL-17015 |
A Foglight Agent Manager that is no longer in use maintains a stale disconnected RemoteObject instance under the host object. This causes the host to appear as undefined on the Hosts dashboard, even though the host is monitored by Foglight for Infrastructure. |
FGL-16508 |
When federation.config does not contain any queries, TopologySynchService mistakenly logs the following warning: WARN Obsolete federated topology object purge will not be performed because the following federated servers are not connected: ... |
FGL-16487 |
Topology loading can fail for topology objects that have been converted to DataObjects. |
FGL-16439 |
Type-based exclusions in federation.config do not apply to referenced objects. |
FGL-16432 |
String observations containing reserved characters in script agents are not supported. |
FGL-16388 |
The alarm email notification code does not persist any information about notification alarms that were previously sent. If the server is restarted, all alarms appear as new, and the notifications are resent. |
FGL-16166 |
Hibernate/JDBC errors occurring while loading rules return an empty list. |
FGL-16163 |
Cleared credential alarms are found when querying for alarms that are not cleared. |
FGL-4498 |
Simple rules that report alarms directly are not affected by blackouts. |
FXM-880 |
Diagnose link doesn't work on the Master FMS. |
Defect ID |
Known Issue |
FADUI-1149 |
An attempt to import external groups results in the following error: Could not execute the requested operation, error(s) had occurred: Failed to retrieve groups, please make sure you correctly configured the Directory Services, check log for details. The log, however, does not contain any errors. |
FGLUI-11228 |
After changing the value of the registry value, some of the performance
calendars may disappear from the list. |
FGLUI-11009 |
When editing properties from the Agent Status dashboard or the Agent
Properties dashboard in Chrome 17, some edit fields are not available.
|
FGLUI-10834 |
The Cartridge Inventory page is currently unable to alert users if a cartridge install fails due to lack of space in the server's temp directory. An error is written to the log files. |
FGLUI-10788 |
When editing secondary agent property tables from either the Agent
Status or Agent Properties dashboards, performing Add and Delete
operations at the same time results in all Added items being deleted.
|
FGLUI-10504 |
Selecting the time range "All" on the Service Details dashboard can result in the page getting stuck refreshing. Avoid using the "All" time range on this page. |
FGLUI-10456 |
Selections made on the Service Selector tab of the Select services and tiers to monitor dialog box of the SOC become unselected when you switch to the Tier Selector tab and back again. |
FGLUI-10323 |
The first time the Environment Report is run it may generate a warning:
"com.quest.wcf.core.component.RenderPDFContext
- Text ... did not fit. in view ..." |
FGLUI-10036 |
Credential alarm messages sometimes contain UUIDs for objects related to
the alarm. |
FGLUI-8261 |
When using a Federation Master that is a newer version than the Federated Child, it is possible to get warnings about missing metrics. This occurs when new metrics have been added to the Federation Master's version. The warnings indicate that the Federated Child does not provide these metrics, and they will cease when the Federated Child is upgraded to the same version as the Federation Master. |
FGLUI-7817 |
When editing secondary agent property lists, the Delete Selected Row(s) button marks the rows to be deleted by graying them out. Save changes must be selected to delete the selected rows. If a required field is blank, then a value must be entered before the row can be marked for deletion. |
FGLUI-7729 |
In the Service Builder and Service Operation Console (SOC) dashboards, when alarm filters are configured, they are applied to the main dashboards (Service Builder and SOC dashboards) and to some first level popups only. The alarm filters are not applied throughout all popups/drilldowns at any level. |
FGLUI-7593 |
When reviewing Alarms on a Federation Master, you are able to open a link to view the rule that fired the alarm on the Federated Child. This involves opening the console of the Federated Child. If the Federated Child is of an older version than the Federation Master, an error page is displayed. |
FGLUI-7377 |
Under rare conditions, if the session is allowed to expire while viewing some of the views in the Administration dashboard, the process of logging in again displays the Administration view without any decoration around the side panels. Workaround: To clear this condition, close the browser. Do not save your session if the browser prompts you to save the last session configuration. Instead, start the browser and log in again. |
FGLUI-7356 |
The column layout on the Agent Status Page does not allow resizing of columns, which can result in the host name appearing truncated. |
FGLUI-7333 |
An error message stating "Error getting value of context entry with key:timeRange" can appear in the logs when using the popup menu on the Origin field of the Alarm Details dialog. |
FGLUI-6874 |
If a Federation Master Server connects an older version Federated
Child, the Federated Child may have some of the objects that are no
longer associated with the Management Server Performance Report and
Foglight Server Diagnostic views on the Federation Master. This results
in some data about the Federated Child being unavailable to this report
and views. |
FGLUI-5990 |
Inconsistency in the number of alerts shown in the "All Alarms Chart" and "Alarm List with Filter" in the Alarms dashboard. |
FGLUI-5708 |
Display all available scoping objects in the condition editor for copied and user-created rules. |
FGLUI-4628 |
On systems with a large numbers of hosts, the Host Table view can be slow to display.
|
FGLUI-4544 |
Foglight 4 Tabular views generate an error when the time range has "Auto" granularity. |
FGLUI-3509 |
The edit rule definition for an alarm from a Federated Child brings up a page for editing a rule on the Federation Master, rather than for the rule that triggered the alarm. This occurs because it is not possible to perform administration from the Federation Master. |
FGLUI-3440 |
When the user pastes data using right-click >
Paste to
a box that automatically updates itself (for example, the edit agent
properties screen), the user interface does not automatically refresh
itself. |
FGLUI-3430 |
When agent activation fails, the "Activating" status box does not show the status of the failed start agent. |
FGLUI-1906 |
The Service Levels Details page does not show cleared alarms for Service Level Policy. |
FGLUI-257 |
Seconds should be displayed in the startTime and endTime in the WCF under Browse > Data when granularity is set to "raw". |
WCF-13385 |
QP5 needs to be upgraded to the latest version. |
WCF-12581 |
In Internet Explorer 8, when the number of dashboard nodes in the navigation panel exceeds the maximum that can be displayed without a scrollbar, the scrollbar does not immediately appear. |
WCF-10580 |
Tree Table list nodes should not be clickable or dwellable. |
WCF-7344 |
PDF charts and files that were requested through a proxy fail and result in a Connection Refused error. Note that this error only applies to requests made by the Management Server. |
WCF-5895 |
Vertical scrollbar not shown for the text area. |
The following is a list of third party issues known to exist at the time of this release. For a list of third-party issues related to the Foglight Agent Manager at the time of the Foglight 6.3.0 release, see the Foglight Agent Manager 6.3.0 Release Notes.
Defect ID |
Known Issue |
FGL-5691 |
The Foglight Management Server generates an "Unable to load Java VM shared library to start JVM" message when attempting to start the Management Server on a Red Hat Enterprise Linux Server 5.0 VMware machine. This is caused by the SELinux security code on newer RedHat systems. There are two workarounds:
This issue is addressed in the Sun JDK 1.6.0 release notes: |
FGL-3677 |
Installation:
Console Mode. Returning to a previous step in the installation process
after being prompted for a user password, the input is not recognized.
|
FGL-2882 |
Installation: Console Mode. Some characters of the Administrator's password
are not hidden if typed too quickly.
|
WCF-9735 |
When typing words containing "ss" in the online help search, a
null pointer exception is generated. |
Important:
See the Foglight 6.3.x Upgrade Guide for information about upgrading Foglight and for a list of the latest cartridge versions that are compatible with Foglight Management Server 6.3.x.
For information about system requirements for this release, see the Foglight 6.3.0 System Requirements and Platform Support Guide.
This will be the final Foglight release that supports the Foglight Agent Manager (FglAM) on AIX , Sun Solaris, and HP-UX platforms. Starting from the next release, FglAM installers will only be provided for Windows and Linux platforms.
Foglight includes a licensing capability that restricts access to those features that are defined in the license. All Management Server installations require a license that grants access to server-specific parts of the browser interface and the features associated with them. Foglight cartridges are also license-protected. While some cartridges are covered by the base Foglight license (such as Foglight Agent Manager cartridges and the Cartridge for Infrastructure), others may require an additional license.
To activate a trial or a purchased commercial license:
The Foglight 6.3.0 release package contains the following:
See the Foglight 6.3.0 Installation and Setup Guide set for installation instructions.
Additional information is available from the following:
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.
This release has the following known capabilities or limitations: The server will be enabled for Global Operations, but not localized to any particular locale. Some legacy agents cannot support multi-byte locales.
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit https://www.quest.com/.
Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.
The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:
Quest, the Quest logo, Foglight, and Where next meets now are trademarks and registered trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest Software trademarks, please visit our website at www.quest.com/legal. Red Hat, JBoss, the JBoss logo, and Red Hat Enterprise Linux are registered trademarks of Red Hat, Inc. in the U.S. and other countries. CentOS is a trademark of Red Hat, Inc. in the U.S. and other countries. Fedora and the Infinity design logo are trademarks of Red Hat, Inc. Microsoft, .NET, Active Directory, Internet Explorer, Hyper-V, Office 365, SharePoint, Silverlight,SQL Server, Visual Basic, Windows, Windows Vista and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. AIX, IBM, PowerPC, PowerVM, and WebSphere are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. Java, Oracle, Oracle Solaris, PeopleSoft, Siebel, Sun, WebLogic, and ZFS are trademarks or registered trademarks of Oracle and/or its affiliates in the United States and other countries. SPARC is a registered trademark of SPARC International, Inc. in the United States and other countries. Products bearing the SPARC trademarks are based on an architecture developed by Oracle Corporation. OpenLDAP is a registered trademark of the OpenLDAP Foundation. HP is a registered trademark that belongs to HewlettPackard Development Company, L.P. Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries. Novell and eDirectory are registered trademarks of Novell, Inc., in the United States and other countries. VMware, ESX, ESXi, vSphere, vCenter, vMotion, and vCloud Director are registered trademarks or trademarks of VMware, Inc. in the United States and/or other jurisdictions. Sybase is a registered trademark of Sybase, Inc. The X Window System and UNIX are registered trademarks of The Open Group. Mozilla and Firefox are registered trademarks of the Mozilla Foundation. IOS is a registered trademark or trademark of Cisco Systems, Inc. and/or its affiliates in the United States and certain other countries. Apple, iPad, iPhone, Mac OS, Safari, Swift, and Xcode are trademarks of Apple Inc., registered in the U.S. and other countries. Ubuntu is a registered trademark of Canonical Ltd. Symantec and Veritas are trademarks or registered trademarks of Symantec Corporation or its affiliates in the U.S. and other countries. OpenSUSE, SUSE, and YAST are registered trademarks of SUSE LCC in the United States and other countries. Citrix, AppFlow, NetScaler, XenApp, and XenDesktop are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. PostgreSQL is a registered trademark of the PostgreSQL Global Development Group. MariaDB is a trademark or registered trademark of MariaDB Corporation Ab in the European Union and United States of America and/or other countries. Intel, Itanium, Pentium, and Xeon are trademarks of Intel Corporation in the U.S. and/or other countries. Debian is a registered trademark of Software in the Public Interest, Inc. OpenStack is a trademark of the OpenStack Foundation. Amazon Web Services, the "Powered by Amazon Web Services" logo, and "Amazon RDS" are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries. Infobright, Infobright Community Edition and Infobright Enterprise Edition are trademarks of Infobright Inc. POLYCOM®, RealPresence® Collaboration Server, and RMX® are registered trademarks of Polycom, Inc. All other marks and names mentioned herein may be trademarks of their respective companies.