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.
Release : 4.8.100.10
Component : CA Test Data Manager
Triggers attached to the tables.
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.
DebugView is a good tool for troubleshooting Datamaker to show what it is doing, and it showed there were not duplicate inserts being made.