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

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


Article ID: 213479


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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.


Release : 4.9.1

Component : CA Agile Requirements Designer - TMX Script Generator


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


Issue fixed in, please contact Broadcom Support for this fix.