Help solve this problem when loading my data

General
Enthusiast

Help solve this problem when loading my data

I am a newbie in Teradata. I get this erros whenever I am loading my data any help. thanks

(FOC1400) SQLCODE IS 2803 (HEX: 00000AF3)                                   

     : Secondary index uniqueness violation in T_Test.C_Bf_CDS.   

   (FOC1416) TRANSACTION ERROR  : C_BF_CDS                                

   (FOC1400) SQLCODE IS 2803 (HEX: 00000AF3)                                   

     : Secondary index uniqueness violation in T_Test.C_Bf_CDS.   

   (FOC1416) TRANSACTION ERROR  : C_BF_CDS                                

   (FOC1400) SQLCODE IS 2803 (HEX: 00000AF3)                                   

     : Secondary index uniqueness violation in T_Test.C_Bf_CDS.   

   (FOC1416) TRANSACTION ERROR  : CVGE_BENF_CDS                                

   (FOC1400) SQLCODE IS 2803 (HEX: 00000AF3)                                   

     : Secondary index uniqueness violation in T_Test.C_Bf_CDS.   

   (FOC1416) TRANSACTION ERROR  : C_BF_CDS                                

   (FOC1400) SQLCODE IS 2803 (HEX: 00000AF3)                                   

     : Secondary index uniqueness violation in T_Test.C_Bf_CDS.   

   (FOC1416) TRANSACTION ERROR  : C_BF_CDS                                

    REFERENCE...AT TRANS   50000

1 REPLY
Enthusiast

Re: Help solve this problem when loading my data

It appears that the table you are trying to load has a Unique Secondary Index and the data you are attempting to insert has multiple rows that violate the uniqueness constraint of the USI.

First things first, check the target table DDL and profile your source file.