When drilling down on "View Full Text" of a SQL Statement the following error message comes up "Data retrieval via RMI failed".
The on-demand port is not verifying successfully. Changing the port and making sure that the port is not in use on the Foglight Agent Manager (FglAM) host or the Foglight Management Server (FMS) host, but an "Address already in use" error message is reported. There is no Firewall between the FglAM host and the FMS host.
The on-demand port connection was being made to an IP address associated with a network card that was no longer being used on the FglAM host.
Delete the network card that is no longer used on the FglAM host. Then recreate the DB_SQL_Server agent for the instance using the Auto-Discovery wizard.