Test Data Manager Masking: Masking Functionality about varchar(max)

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Will masking and sub-setting work if XML files are stored in SQL varchar(max) data sets?

Environment

Release: TDMTDD99000-4.4-Test Data Manager-for Test Data on Demand
Component:

Resolution

Prior to SQL 2016, there is a MAX of 2000 for each column. If XML data goes beyond 2000, and SQL 2016 and up is being used, the upper limit is 8000.