Different Setting of MLoadDiscardDupRowUPI on Teradata 14.10 and Teradata 12

Tools & Utilities

Different Setting of MLoadDiscardDupRowUPI on Teradata 14.10 and Teradata 12

Hi all,

we have just migrated from Teradata 12 to Teradata 14.10, we have a problem with mload with duplicate rows, in the old version (TD12) we skypped this rows due to the setting of the MLoadDiscardDupRowUPI = TRUE.

On new sytem (TD14.10) the MLoadDiscardDupRowUPI = FALSE in the TERADATA 14.10 manual is written:

  • TERADATA 14.10: MLoadDiscardDupRowUPI = FALSE: "MultiLoad logs rows with UPI violations to the application error table."

In the TERADATA 12 manual is written:

MLoadDiscardDupRowUPI = TRUE: "MultiLoad logs rows with UPI violations to the application error table."

so it seems that we will have the same behavior on the two system,  but we are facing error due to UPI violation discarded on ERR2 table on TERADATA 14.10, that we do not have had on Teradata 12, we have done test with the same data on the two system.

Could you please help me to understand this strange behavior ?

Thanks