Test Data Manager

Expand all | Collapse all

unique index issue, unable to mask the column

Jump to Best Answer
  • 1.  unique index issue, unable to mask the column

    Posted 10-14-2019 10:46 AM
    Hi ,

    I am trying to create unique login user name (email addresses) in a table where  user name column is having unique columne index.
    When i am trying to run the masking using hashlov and with 4 lac records and also update "unique Column" option i.e. user_name but still its showing below error message after 9000 records updatation

    annot insert duplicate key row in object 'dbo.table_web_user' with unique index 'web_user_name_index'. The duplicate key value is (PETER49@gmail.com).
    >2019-10-14 07:41:41.984 Thread:table_web_user - Table causing error:table_web_user
    >2019-10-14 07:41:41.984 Thread:table_web_user - Select SQL:select web_user2contact,"login_name" from "dbo"."table_web_user" order by "login_name"
    >2019-10-14 07:41:42.000 Thread:table_web_user - Update SQL:update "dbo"."table_web_user" SET "login_name" = ? WHERE "login_name" = ?
    >2019-10-14 07:41:42.000 exit value = 1

    Please help

    Nitin Dixit

  • 2.  RE: unique index issue, unable to mask the column
    Best Answer

    Posted 10-15-2019 09:42 AM
    Hi Nitin,

    If you are using hashlov, AND you need unique values, then the number of entries in your seedlist must exceed the number of unique values in the column you want to mask.