Failed to initialize SQL Server RMI server: Port already in use errors (4288179)

The following error messages are found in the Foglight log files

ERROR [IncomingMessage-186743] com.quest.qsi.fason.oracle.agent.SQLServerAgent - Failed to initialize SQL Server RMI server java.rmi.server.ExportException: Port already in use: 3735; nested exception is:

ERROR [IncomingMessage-186743] com.quest.qsi.fason.oracle.agent.OracleAgent - Failed to initialize Oracle RMI server java.rmi.server.ExportException: Port already in use: 3723; nested exception is:

ERROR [IncomingMessage-186743] com.quest.qsi.fason.oracle.agent.DB2Agent - Failed to initialize DB2 RMI server java.rmi.server.ExportException: Port already in use: 3725; nested exception is:

RESOLUTION 1.

If there is more than one FglAM instance on the same server, but the agents are segregated by type; then the unused Agent Packages should be undeployed from each FglAM.

1. Navigate to the Agent Managers dashboard from the Navigation panel Dashboards | Administration | Agents | Agent Managers
2. Select a single FglAM instance running on the affected server with multiple FglAM instances
3. Click on Undeploy Agent Package
4. Select the Database Agent Packages that don't have any agents running on this FglAM, then click Next
5. Verify the information, then click Finish
6. Repeat steps 2 through 5 for all other FglAM instances running on this same server

RESOLUTION 2.

Change the RMI server port from Global Administration dashboard.

1. Navigate to Database dashboard from the Navigation panel Dashboards | Databases | Databases
2. select the monitored database agent
3. click Settings > Administration
4. select On-demand Data Settings
5. select the related Agent Manager
6. set the port to an available port and validate the connectivity

NOTE: default RMI port for Oracle is 3723, default RMI port for SQL Server is 3235, default RMI port for DB2 is 3725