Masking set run fails with generic message.

unclepuff

I have a masking set on one table with 50 substitutions.  The run fails with the error message "String or binary data would be truncated. The statement has been terminated."  How do I identify which of the 50 substitutions is the culprit?
Thank you.

Eddie D

Hi unclepuff, thank you for your forum post.

If you locate the SQL Data Masker log file for this failed masking attempt, does it reveal any further information?
The log file location can be found the SQL Data Masker GUI ->Misc. Setup tab ->Directories tab ->the path to log file is list under Directory for Log Files.
Or if using the command line, you will find the log file in the path specified in your PARFILE for the LOGFILEDIR= parameter.

Just to confirm, this is one substitution rule that is masking 50 columns in one table?  Or you are masking 50 columns in this one table spread over two or more substitution rules?  I ask this question, as if you have a single rule, you will most likely encounter performance errors.  Please consider splitting the rule in smaller more manageable chunks, further reading here.

Check the rule particularly the VARCHAR and CHAR columns in that the data set selected is not going to insert a text string that excludes  the length of the column.

Many Thanks
Eddie