Error executing SQL Scrambled Extract Batch File

Document ID : KB000093523
Last Modified Date : 30/04/2018
Show Technical Document Details
Issue:
Attempting to implement On-The-Fly/In-Flight masking for SQL Server DB after an upgrade.  Created a batch file (Export, Import) as per the process mentioned in documentation. But while executing the batch file, an error was generated when trying to execute SQLCMD.  Below is the actual error.
'SQLCMD' is not recognized as an internal or external command, operable program or batch file. Error creating masked views.

How do we troubleshoot this and ultimately resolve this error?
Environment:
TDM 4.2
SubSet-4.5.4.0.zip
Cause:
Scramble database was a much earlier database.
 
Resolution:
The issue here seems to be twofold
1) if SQLCMD is not recognized, please make sure the SQL Server client software is installed correctly and appropriate directories are on the path, SQLCMD is usually in directory C:\Program Files\Microsoft SQL Server\100\Tools\Binn
2) The version of Subset and the version of the scramble database are out of synch, either reinstall scramble from the latest install kit or use the attached SQL file to recreate the charhash function 
Additional Information:
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html