search cancel

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

book

Article ID: 201069

calendar_today

Updated On:

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.

 

Cause

Triggers attached to the tables.

Environment

Release : 4.8.100.10

Component : CA Test Data Manager

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.