New ConfigTypes not showing in drop down in HMC.

Version 1


    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.



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


    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.