TDM -PII Scanning takes a very long time to complete

Products

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

Issue/Introduction

We are seeing a regular PII scan taking very long time to complete. 7 hours to scan 500 tables for 50 rows is not acceptable.

Environment

Release : 4.10

Resolution

Engineering has provided a fix for the PII Scanning performance in TDMWeb-4.10.170.0. 

You will need to make a modification to the application.properties file, before restarting the CA Test Data Manager Portal Service.
Look in the application.properties file for the new tdmweb.profiling.sampler.usedborder property and change its default value ("false") to "true".
After restarting the service, the scanning will use simpler queries for sampling the tables.

Additional Information

TDM Patches are available at https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649