"batch completion: Encountered TDS_COLMETADATA (0x81). SHOWPLAN is ON, ignoring" messages filling up FglAM log (4226763)

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.

1. Stop the Foglight Agent Manager (FglAM)
2. Download and unpack the attached zip file containing the set of drivers 
3. Open libs folder where the SQL Server drivers are stored (e.g. \fglam\agents\DB_SQL_Server\{version}\lib)
4. Delete mssql-jdbc-9.2.0.jre8.jar file, mssql-jdbc_auth-9.2.0.x64.dll, and mssql-jdbc_auth-9.2.0.x86.dll
5. Copy the new jar files into the same folder
6. Restart the FglAM

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
Defect ID FOG-4705 has been logged to update the SQL Server driver to the Microsoft 11.2.1 version.