Button Properties, Delete and also Clone user feature does not work in the User's Master File

Version 1

    Details

    Button Properties, Delete and also Clone user feature does not work in the Users' Master File

    [STEPS TO REPRODUCE]
    1. Log into GoldMine with master rights
    2. Tools > Users' Settings
    3. Highlight a user > Properties Button or Delete Button or Right Click > Clone


    [RESULT]

    Nothing happens
    Note: this may not work for all users or only from a certain entry in the list onwards


    Resolution

    [CAUSE]
    The USERS table contains a row with an empty USERNAME

    [STEPS]

    Make sure to have a full running backup of your GoldMine database before changing any data in the back end.
    GoldMine Technical Support does not assist in any back end manipulation and only can provide the following information as-is without any warranty of any kind

    1. It is recommended to perform the steps before or after business hours when no user is logged into GoldMine
    2. Start the SQL Server Management Studio
    3. Browse to the GoldMine database
    4. Browse to the USERS table
    5. Right click > Edit Top 200 Rows
    6. Verify if there is a row with a blank USERNAME and remove the corruption
    For Example, by removing the row or adding a missing
    7. Verify the functionality in GoldMine again