Unable to add fields to the ContactGroup business object.  Error thrown: Failed to change ContactGroup#: Altering table ContactGroup failed on Table ContactGroup unique index 'idxContactGroupNameType' contains nullable field(s) and must be defined with a

Version 1

    Details

    When trying to add fields to the ContactGroup business object, the follow error is thrown: 


    Failed to change ContactGroup#: Altering table ContactGroup failed on Table ContactGroup unique index 'idxContactGroupNameType' contains nullable field(s) and must be defined with a filter expression.

     


    Resolution

    This is caused because there is an index on the business object ContactGroup called 'idxContactGroupNameType'.  This is a unique index.  That index contains two fields 'GroupType' and 'Name'.  If you look at those two fields, you will see that they are allowed to be 'Nullable'.  You will need to remove the 'Nullable' attribute from each field and save the business object and the error will no longer occur.  You can then add new fields as needed.


    Here are steps to take:
    1. Log into the AdminUI
    2. Click on Business Objects
    3. Click on ContactGroup
    4. Click on Fields
    5. Click on the field 'GroupType
    6. Uncheck 'Nullable'
    7. Click on the 'Go Back' link at the bottom of the page
    8. Click on the field 'Name'
    9. Uncheck 'Nullable'
    10. Save the business object

    You can now add additional fields and modify any other aspect of the business object ContactGroup.