Failed to create user role for User: Admin User3 Role PortalEndUser Cannot insert duplicate key row in object 'dbo.tps_user' with unique index 'index$tps_user$name'. The duplicate key value is (Admin User3)

Version 1

    Verified Product Versions

    Service Desk 7.6Service Desk 7.7.xService Desk 7.8.xService Desk 2016.xService Desk 2017.x

    [Error in Mail Log file]

    Failed to create user role for User: Admin User3 Role PortalEndUser Cannot insert duplicate key row in object 'dbo.tps_user' with unique index 'index$tps_user$name'. The duplicate key value is (Admin User3).

     

    [Cause]

    Inbound mail creates a username ending in a number

     

     

    [Resolution]

    Run the Script to convert all usernames ending with a number to an underscore

    Apply the trigger to the DB that will convert number to underscore when created via inbound mail

     

    * Trigger & Script attached