Data Maker Publish job tries to insert same record again - This is a duplicate row. Do you wish to ignore or update duplicates?

Products

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

Issue/Introduction

 

 

Data Maker Publish job tries to insert same record again.

Error:

Row #1
Row Number: 1
ST Name: DS
TR Id: 851553
VALUES (CONTRACT_ID=89098, HTL_ID=99999953, ENT_ID=183127, CONTRACT_TYP=14, CONTRACT_CATGY_ID=11, CONTRACT_STAT_ID=10, EST_NPV_AMT=<NULL>, EST_NPV_CURR_CD=<NULL>, OPEN_CONFIDENCE_PCT=<NULL>, CONTRACT_LEN_YR_NBR=<NULL>, PLANNED_STRT_DT=<NULL>, STRT_DT=2020-10-01 13:41:37, PLANNED_END_DT=2029-02-01 13:41:37, END_DT=2029-02-01 13:41:37, CONTRACT_LTR_ID=<NULL>, VER_NBR=8, CREAT_USR_ID=guttikr, CREAT_TS=2020-10-01 13:41:37, LST_UPDT_USR_ID=guttikr, LST_UPDT_TS=2020-10-01 13:41:37, IHG_ENT_ID=150556, LIQ_DAMAGE_MO_QTY=0, PRNT_CONTRACT_ID=<NULL>, TERM_MO_QTY=0, AGREEMENT_DT=2020-10-01 13:41:38, EMEA_CONTRACT_ID=<NULL>, INS_COV_AMT=<NULL>, CONFIDENTIAL_IND=N, EST_CAP_AMT=<NULL>, EST_CAP_CURR_CD=<NULL>, CONTRACT_LIC_TYP=444, STAT_EFF_DT=2020-10-01 13:41:38, PRIM_TERM_RSN_ID=<NULL>, SEC_TERM_RSN_ID=<NULL>, SEC_TERM_SUB_RSN_ID=<NULL>, PRIM_TERM_SUB_RSN_ID=<NULL>)

This is a duplicate row.  Do you wish to ignore or update duplicates?

This record was just inserted by same publish job, trying to insert again and throwing duplicate record error. 

This happening for different tables in different runs.

 

Environment

Release : 4.8.100.10

Component : CA Test Data Manager

Cause

Triggers attached to the tables.

Resolution

Working as designed.

TDM generates data for all tables before inserting the data starting with the child most table and ending with the parent most table.

If you have a lot of triggers attached to your tables. When TDM tries to insert a record in a table, these triggers are activated and generate their own insert statements that run outside the scope of TDM

You can get into situations where these trigger inserts conflict with our TDM inserts showing duplicate messages.

Additional Information

DebugView is a good tool for troubleshooting Datamaker to show what it is doing, and it showed there were not duplicate inserts being made.