Portal low performance while importing list of tables during PII scan

Products

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

Issue/Introduction

During PII scan , tried to import and add specific list of tables only for scan. However the performance of TDM portal is very slow.

It hangs a lot and even if managed to add the table but if needed to perform re-scan or move from some other screen. It does not open again. It keeps on spinning and gives warning that portal is un-responsive.

Total number of tables: 1308. Adding this as missed these tables during first run and do not want to again run that project completely.

As the schema and database is common (even in some cases the tables names are same but schema is different) need to specifically include this huge list.

Environment

Release : 4.9, 4.10

Component : Web Portal - PII Audit/Scan

Cause

L2 team has done research on this behavior and found that this performance impact on the portal is due to the performance limitation of Angular JS framework that is being used inside TDM Portal design. Angular JS is not able to handle huge file uploads and causes the slowness. 

Resolution

SE team has considered to change the internal design and replace AngularJS with ReactJS framework that is expected to handle the big files without performance impact.

However this change is being taken up as an enhancement request since it cannot be categorized as a product defect. It is going to take a long time to implement this change as it needs to go trough a complete cycle and may span over many months.

Considering the nature of this change and amount of time it would take to implement. Refer to TDM Portal GA version release notes or TDM Portal Portal Patch build at below links:

- https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10.html

- https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649