Unable to add Redshift instances to database groups (4372723)

Unable to add Redshift instances to database groups

When the user adds a Redshift DB to a DB Group, nothing happens and there is no error message displayed.

If a user adds a Redshift database to another existing group, the database group loses all the agents and there are no agents visible in the group. An error is also printed in the FMS log

ERROR [http-exec-158] com.quest.wcf.core.module.function.FunctionManager - Error executing script id=system:dbwc_groups.25 name="'get Global View Instances List' from the System module Databases/groups"
message: com.quest.nitro.service.sl.interfaces.scripting.ScriptingException: com.quest.nitro.service.sl.interfaces.scripting.ScriptAbortException: java.lang.IllegalArgumentException: Type 'foglight-5:Redshift_Cluster:3' does not have a property with the name 'instances'

This was caused by the Redshift_Cluster database type being missing from the getGlobaViewInstancesList function. I have attached a copy of the fix that has been confirmed working in the PreSales FMS.

WORKAROUND
Attached is a workaround fix to the Global View Instances function to apply in Foglight. Users must be logged into Supportlink to download the attachment and must have the Cartridge Developer role to make function changes in the Foglight system.

1. Go to Configuration | Definitions, and navigate to the function as shown in the image attached
2. Edit the function, first copy the function and keep it in a txt file as a back up it is necessary to revert it at some point
3. Replace the contents of the function with the attached getGlobalViewInstancesList_fix_FOG-6489.txt
4. Save the changes

After the change, the Global View should display the database instances like before and the Redshift agents should be able to be added to new and existing groups.

STATUS
This has been logged as defect FOG-6489 and has been fixed in the 7.1.0.10 and higher releases of the Global View cartridge for Foglight.

FOG-6489

wcf_definition_location_getGlobalViewInstancesList
getGlobalViewInstancesList_fix_FOG-6489