How can we help you today? How can we help you today?

CREATE UNIQUE INDEX Error masking a middle initial

Is there something I can do to avoid this error?  It seems to be random.

2025-03-04 05:43:06 [Error] RuleWorker: HandleRuleWorkerLoopException: ENDING on SQL Server error {RuleId="02-0047", WorkerId="1", RunId="01_MaskingSet_XXXXXXXXXX::202503040540419562199"}
System.Data.SqlClient.SqlException (0x80131904): The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.#TempDM_FPwAIl/1MkW2pc8v5dzb/w______________________________________________________________________________________0000000140CD' and the index name 'idx_HpoK9jSjvU6VDzT+yCmGQA'. The duplicate key value is (571).
The statement has been terminated.

GaryM
0

Comments

1 comment

Sort by
  • Eddie Davis
    Official comment

    Hi Gary,

    Thank you for your forum post.

    Sadly, I need to obtain copies of the log file from when you executed the masking set and copy of the MaskingSet itself, to be able to identify a cause for the reported problem.

    A Redgate Support Ticket has been generated and I will contact you via the support to request the files above.

    Many Thanks

    Eddie

    Eddie Davis

Add comment

Please sign in to leave a comment.