Masking set run fails with generic message.
unclepuff
Posts: 1 New member
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.
Thank you.
Tagged:
Answers
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com