search cancel

MS SQL Server DBSCRIPT generated in TDM Portal is wrong

book

Article ID: 243699

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We see an issue with the generated dbscript with 'generate & download constraints scripts' option of TDM portal.

The postscript which is generated is wrong. The script says:

ALTER TABLE Table_name1 ADD CONSTRAINT constraint_name FOREIGN KEY (id) REFERENCES Table_name2 (DealId);

When generating the script from the Microsoft SQL Server 2016 database, the script should be:

ALTER TABLE Table_name1 ADD CONSTRAINT constraint_name FOREIGN KEY (DealId) REFERENCES Table_name2 (id);

So if you see the (DealId) & (id) is replaced.  Post masking when we tried to rebuild the constraints we got an error and upon checking in another ENV we understood the difference.

Environment

Release : 4.10

Component : TDM Web Portal

Resolution

This was fixed in an FDM patch provided back on May 17, 2020. So applying the latest FDM patch will address this issue. Please contact Broadcom Support for the latest FDM patch, or try downloading the latest FDM patch from the below link.

https://support.broadcom.com/web/ecx/support-content-notification/-/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649#FDM4.10