-
Título
"batch completion: Encountered TDS_COLMETADATA (0x81). SHOWPLAN is ON, ignoring" messages filling up FglAM log -
Descrição
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. -
Causa
Microsoft SQL Server driver issue -
Resolução
WORKAROUND 1
Deactivate the SQL Server Agent Error Log collection.
Refer to How to enable or disable a DB2, Oracle, or SQL Server database agent collection? (120521)
WORKAROUND 2
Change the driver from Microsoft to Data Direct as described in KB 338210.
WORKAROUND 3
For some systems, applying the most recent critical updates to SQL Server helped to stop these messages from appearing. This however has not been a consistent resolution.
STATUS
Defect ID FOG-3979 has been logged for this message to be hidden from logging in a future release of the SQL Server cartridge.