-
标题
Foglight for Databases 7.1.5 release notes -
说明
New in this release
Version 7.1.5 of Foglight contains updates to version 7.1.x as described in the Resolved issues and enhancements section.
In addition, version 7.1.5 of Foglight contains the following:
Security Enhancements
-
Updated Java JRE used by Foglight to version 17.0.11
-
Updated third-party libraries
-
Addressing issues with supporting HTTPS traffic when the FMS is running in FIPS mode
Foglight Agent Manager Enhancements
-
Update the SSH library used by agents to provide support for newer encryption and signature algorithms.
User Experience Enhancements
-
Fixed date format inconsistency in timeframe selector
-
Timeframe reset when zoom-in on a wcf chart and set
Previously released version 7.1.1 of Foglight contains the following features and updates:
-
Provide new signed installers for Foglight server and Foglight Agent Managers
Version 7.1 of Foglight contains the following new features and updates:
Security Enhancements
-
Updated third-party libraries
-
Addressing issues with supporting HTTPS traffic when the FMS is running in FIPS mode
Foglight Agent Manager Enhancements
-
FglAM HA partitions will now automatically fail back to the highest priority FglAM
User Experience Enhancements
- Revised the header across all foglight dashboards to include new breadcrumbs, timeframe selector, and reports
- Open source and No-SQL database menus are now conveniently located under the “Databases” menu on the left for easy navigation
- Change the location of the “Pin” button for the left navigation bar
- Improve Query Insight layout to allow change of width between the two parts of the screen
Query Insights Enhancements
-
Add support for Snowflake and SAP HANA
-
Improve Query Insight layout to allow change of width between the two parts of the screen
SQL Server Enhancements
-
Add the ability to remove literals from queries collected.
-
Add monitoring for os_workers.
-
Add monitoring for read and write file latency.
- Remove the use of RMI in SQL Server cartridge.
Following is the list of database cartridges that are included in this release:
Cartridge Version Included in DB All installer SQL Server 7.2.3.12 Yes Oracle 7.2.3.12 Yes DB2 7.2.3.12 Yes Azure SQL Database 7.2.3.12 Yes MySQL PI 7.2.3.12 Yes SAP ASE 7.2.3.10 No SnowflakeAgent 7.2.3.10 No SAPHANAAgent 7.1.0.35 No RedshiftAgent 7.2.3.10 No Redis 7.1.0.10 No MongoDBAgent 7.2.3.10 Yes PostgresSQLAgent 7.2.3.10 Yes CassandraAgent 7.1.0.16 Yes MySQL 7.2.3.10 Yes Resolved Issues and Enhancements
The following is a list of Core issues addressed and enhancements implemented in 7.1.5 Foglight release.Defect ID Resolved Issue Domain FOG-8485 Custom REST APIs implemented in Groovy can fail to invoke privileged operations Foglight Agent Manager FOG-8664 Update ResizableThreadPoolExecutor to avoid IllegalArgumentExceptions Foglight FOG-8178 support custom time ranges when running reports Foglight FOG-8081 Foglight RegEx Tester fails to parse some valid Expressions Foglight FOG-8006 Account does not get unlocked after 'Lockout Duration' ends Foglight FOG-7155 Suspend all rule actions when a global blackout is in effect Foglight
The following is a list of Database cartridge issues addressed and enhancements implemented in this 7.1.5 Foglight release.Defect ID Resolved Issue Domain FOG-8894 Remove Literals Credential not found" when upgrading directly to 7.2 database cartridges Oracle, SQL Server, DB2, and Azure SQL Database FOG-8695 Connection test is not working with JAVA 17 Oracle, DB2, and SQL Server FOG-8583 get_locked_object_ids collection failing when getting "metadatalock" resource_description MSSQL PI FOG-8480 SAP ASE agent often cannot display top sql and top hash. Functionality was working fine in 6.1 SAP ASE FOG-8464 PI enable failing when sql_require_primary_key parameter is true in MySQl configuration MySQL PI FOG-8456 Improve Oracle PI Data collection performance Oracle FOG-8423 SQL PI administration panel agent manager checkbox does not filter the agents list SQL Server FOG-8277 Missing charts in "SPI Global View" Oracle agent Quick View system utilization popups Oracle FOG-8149 AUI Timepicker does not update time range from 1 hour in SQL Server Databases dashboard SQL Server FOG-8016 DBSS_FileGroup_Utilization rule: False alarms when auto_grow path is on NetApp storage SQL Server FOG-7316 CLR Security alarms should be firing for user defined assemblies, not system assemblies SQL Server FOG-5911 Long Running Session Alarms does not fire when enabled via Alarms Template Oracle FOG-5910 Long Running Session Alarms does not fire when enabled via Alarms Template SQL Server FOG-8350 Workload/Executive Reports show upSince of Cluster agent and not the instance agent Oracle FOG-8066 Tablespaces > Details dashboard doesn't display data when changing timerange Oracle FOG-7834 Fixed The DBO_Data_Guard_Status topology is missing for Mounted database Oracle FOG-7707 Fixed DBONameRamRacProcessor RAC aggregation failed with NPE Oracle FOG-7706 Fixed DBOUnixOracleRamProcessor fails reading input string Oracle FOG-7089 Unable to create Oracle/MSSQL/Azure/DB2 agents when enabling OS with RSA credential Oracle FOG-6899 OS_File_System_IO_Summary is not collecting data when Oracle instance run on Linux kernel
version 5.15Oracle FOG-6590 Cannot add Data Guard for RAC One Node Primary / Standby Oracle FOG-6561 Wizard prints a user sensitive info in the FMS log Oracle FOG-6455 [Query Insights] Oracle sql stmnt >Investigate shows blank Oracle FOG-6277 Generate Workload Summary Report for Oracle (7 days) shows the graph when we total it
shows more than 100%Oracle FOG-6276 Stop pushing RAC data to SQLProfile Oracle FOG-6267 Data Guard Stats Standby collection failed Oracle FOG-6215 execution plan: INDEX RANGE SCAN/TABLE ACCESS FULL rows repeated but with diff stats Oracle FOG-6084 Creating Oracle agent for Standby in mounted mode failed Oracle FOG-5954 The number of executions is not correct in PI Oracle FOG-5803 Typo in resultset limiter of DBO_Data_Guard_Destination_Status_ONE_NODE collection Oracle The following is a list of Core issues addressed and enhancements implemented previously in 7.1.x Foglight release:
Defect ID
Resolved Issues Domain FOG-6058 Enhance"Set default" tag line on Alarm templates Foglight FOG-6113 Increase FglAM agent transfer delay Foglight Agent Manager FOG-5976 Deadlock in FglAM HAManager Foglight Agent Manager FOG-1262 Lockbox is not removed from FglAM when it's removed from FMS Foglight Agent Manager FOG-8178 Support custom time ranges for reports Foglight FOG-8006 Unlock users after timeout Foglight FOG-8211 Remove qmx-integration-fms.exe Integration cartridge The following is a list of Database cartridge issues addressed and enhancements implemented previously in 7.1.x release.
Defect ID Resolved Issue Domain FOG-5353 Fixed Backup Location collection Failed to get free space of disk. SQLServer FOG-5817 Query Insight - First drilldown using "investigate" use a wrong timezone Databases FOG-5742, FOG-5745
Databases dashboard grid " # size" columns sort doesn't work
SQLServer
FOG-5819
Some charts title are not visible in Light Theme
SQLServer
FOG-6325
Allow configuration of chartset in RS agent
SAP RS
FOG-5670
Add debug messages for loadIniFile function
SAP RS
FOG-6129
Fixed - TSQL Batches cannot be expanded for one of the Sql Server instances
SQLServer
FOG-6178
Change the alarm definition in order to align to alarm message on the rule "DBSS - Page Splits"
SQLServer
FOG-6489
Unable to add Redshift agents to database groups
Databases
FOG-6115
Foglight hides import from files after selecting discover
SQLServer
FOG-6636
Cannot grant SQL Server sysadmin privileges in Connection Details
SQLServer
-
-
解决办法
Upgrade and compatibility
Important:
- Upgrade to version 7.1.5 directly is supported from version 6.1.0 or 6.3.0. To upgrade from earlier versions, follow the path to first upgrade to one of the supported platforms.
- To upgrade from a 5.5.x Management Server to 5.7.1 or later, you must first upgrade to 5.6.2 (or a more recent 5.6.x version), and then to 5.7.1 or later.
- To upgrade from a 5.6.11 Management Server to 5.7.5.x, you must first upgrade to 5.7.1, and then to 5.7.5.x.
- To upgrade from a 5.7.5.x Management Server to 6.1.x, you must first upgrade to 5.7.5.8, and then to 6.1.x.
- Foglight Management Server (5.7.0 to 5.7.5.8) no longer supports authentication of Federation actions (such as clearing alarms) without specifying a secure token in the federation.config file. Previously configured installations in which Federated Master and Children were authenticated without a security token no longer allow authenticated actions. For more information, see the Federation Field Guide.
- In the 5.9.x release, configuration of SecurityToken in the federation.config file (adopted from Foglight 5.7.0 to 5.7.5.8) was removed. Therefore, configuring an SSL for Federation is required when you upgrade the Federation environment to release 6.1.x from a release prior to 5.9.x, if your Federation environment configures SecurityToken before. For more information, see the Federation Field Guide.
- To upgrade from 5.9.8 FMS + 5.9.7.20 db cartridge to Management Server to 7.x release, you must first upgrade the cartridge to 5.9.7.24, and then to 6.1, and finally to 7.x. This is true for SQL Server, Oracle, and DB2 cartridges.
See the Foglight 7.1.x Upgrade Guide for information about upgrading Foglight and for a list of the latest cartridge versions that are compatible with Foglight Management Server 7.1.x.
System requirementsFor information about system requirements for this release, see the Foglight 7.1.0 System Requirements and Platform Support Guide.