While I am trying to mask Unique identifier column using SM algo it is throwing error ?

  • 0
  • 1
  • Question
  • Updated 2 weeks ago
  • In Progress
While I am trying to mask Unique identifier column  using SM algo it is throwing error as "Conversion failed when converting from a character string to uniqueidentifier". I tried Casting,converting, prescript/postscripts but getting same error. Any suggestions please!
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb
Any suggestions on my query please! 
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 3,058 Points 3k badge 2x thumb
Hello Rajesh,
                  Which kind of SM algo is using? It will good to share a screenshot of the algorithm.

Please also share where you tried casting/conversion. It must be done at ruleset level.

Seems to be an issue when updating data with SM algorithm.

~Thanks
Jatinder



Photo of John Leser

John Leser, Employee

  • 300 Points 250 badge 2x thumb
This does look like a CAST issue, so it would be interesting to know which database type and what workarounds you've tried.

I've seen a similar issue on postgres where we needed a CAST from varchar to UUID resolved by adding a cast to the DB by executing this SQL on the DB:

create CAST (varchar AS uuid) WITH inout AS IMPLICIT;

If this is failing during the update step, adding a cast to the Ruleset won't help because the failure occurs when we try to update the value with a String and the DB can't cast that back to the identifier type.


(Edited)