New ConfigTypes not showing in drop down in HMC.

Version 1

    Details

    After committing an Edit Set where one or more new ConfigTypes were created, those ConfigTypes do not show in the drop down in HMC when attempting to create a definition for Update/Create Config Records.


    Resolution

     

    Cause:
    The new ConfigTypes are not appended to the ConfigType table which is where HMC pulls its list to populate the drop down of ConfigTypes.


    Resolution:

    1. Run the following query in SQL server after the new ConfigTypes have been created with the commit of the Edit Set:

    INSERT INTO ConfigType(ConfigType)
    (SELECT DISTINCT(TableType) FROM HEATFld WHERE TableName = 'Config'
    AND TableType NOT IN(SELECT ConfigType FROM ConfigType))

    2. Re-launch the HMC Config Tool and the drop down for ConfigType should now have proper values.