Foglight Agent Manager is being spammed with this message being written hundreds of times per second in the FglAM log when monitoring SQL Server 2017 (14.0.1000.169) at the base RTM release with no critical updates applied.
ECHO ERROR [HOSTNAME-lowPriorityPool-2-[DBSS_SQL_Agent_Error_Log][YYYY/MM/YY HH:MM:SS]] com.quest.glue.core.util.JavaLoggingToQuestBridge - TDSReader@85 (ConnectionID:2 ClientConnectionId: d9788c05-4a66-4508-ba76-ddd55dee35c3): batch completion: Encountered TDS_COLMETADATA (0x81). SHOWPLAN is ON, ignoring.
WORKAROUND 1
Upgrade the SQL Server cartridge to 6.1.2.10, then replace the SQL Server cartridge Microsoft SQL driver with the 11.2.1 or higher release. A copy of the 11.2.1 driver set is attached to this knowledge base article. Users must be logged into Supportlink to access the download.
NOTE: If a line similar to the following was previously added to the baseline.jvmargs.config file in the \state\default\config folder, then this line should be removed or commented out before restarting the FglAM.
WORKAROUND 2
All of the recent updates to SQL Server on the monitored host helped to stop these messages from appearing.
WORKAROUND 3
Deactivate the SQL Agent Error Log, SQL Server Error Log, and Error Log List collection. Refer to How to enable or disable a DB2, Oracle, or SQL Server database agent collection? (120521)
WORKAROUND 4
Change the driver from Microsoft to Data Direct as described in KB 338210.
STATUS
For Azure SQL
Upgrade the Azure SQL cartridge to 6.1.5.10 or higher.
For SQL Server
Fixed in the 6.3.0.10 and higher releases of the SQL Server cartridge which has updated the SQL Server driver to the Microsoft 11.2.1 version.
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center