Issues with re-calculating table order in Test Data Manager(TDM)

Document ID : KB000006705
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Issues with re-calculating table order

Environment:
OracleTDM GTDatamaker 3.8.0.27
Cause:

Circular references within Tables caused the tables to be out of a known proper order per the Client.

Resolution:

The problem is that due to known circular references in the tables, the program simply defaulted to a specific order.  There was a 50/50 chance of getting the order right.  It was wrong.  However, the backend tables can be changed.  The following SQL gets you to the table so you can then review it and change the table rto_seq_no for the 2 tables in question.

SQL RESOLUTION:

SELECT * FROM

dbo.gtrep_table_order where rto_proj_id = 2346 and rto_pv_id=2360 order by rto_seq_no