ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Data Generation: Relational edit on field PK and FK in the same time

book

Article ID: 213479

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After the creation of the generator, the "Relational Edit" does not handle correctly the relations of a field that is child and parent (see example).

EX.: (based on attached files)

PARENT - TBL1 has a primary key (TBL1KEYFIELD).
PARENT and CHILD - TBL2 has a primary key (TBL2KEYFIELD) and whose same field is child based on TBL1KEYFIELD of table TBL1 and is also a parent for TBL3.
CHILD - TBL3 has child (TBL3FK) based on TBL2KEYFIELD of table TBL2.

In this case, the "Relational Edit" performs well the relationship between tables TBL1 and TBL2 but does not update the relationship between tables TBL2 and TBL3 because it is the same field of table TBL2 that is a child of table TBL1 and a parent of table TBL3.

We have to manually find the keys that have not been updated by the generator and manually modify the generator.
For the current project, it took almost 2 working days to adjust everything manually.

Cause

Data generation function ASLIST throwing error when combining COL1/COL2 with QUOTED options.

Environment

Release : 4.9.1

Component : CA Agile Requirements Designer - TMX Script Generator

Resolution

Issue fixed in TDMWeb-4.9.304.0.zip, please contact Broadcom Support for this fix.