SQL Performance is not showing SQL text under "View full text" (4277873)

SQL Performance is not showing SQL text under "View full text"

When the user clicks "View Full Text" the SQL associated does not appear. It is an empty "View Full Text" box.

Blocked RMI port 

Resolution:  
Verify the on-demand connection

1. Select the agent in question
2. Go to Databases | Settings | Agent Settings | Administration from the Database dashboard
3. Go to On-Demand Data Port (this will show the RMI port that is being used which needs
4. to be open bi-direactional between the FGLAM agent host and FMS)
5. Set the 'port' to a port that is open in both directions (default port is 3235)
6. Click 'verify connection'

This should show that the connection succeeded.

The user can get "netstat –a > desktop\netstat.txt" from the FGLAM hostname and another one from the FMS hostname.
Then, make a comparison to ensure port 3235 port is open.

Please, verify the on-demand port. The RMI Server is on the FglAM itself where the RMI Client resides on the FMS. In some cases this connection may fail due to a blocked port. Ensuring the port is not in use on the Foglight Agent Manager (FglAM) host or the Foglight Management Server (FMS) host. The RMI Server is on the FglAM itself where the RMI Client resides on the FMS (Foglight console). In some cases this connection may fail due to a blocked port or if the FglAM points to the wrong RMI client machine.