Hi All.,
Below is the error i am getting when i try to execute the job in teradata database. I havnt used bulk load option.
Any suggestions pls???
14552 10512 DBS-070404 16/07/2011 23:21:40 |Data flow DF_Cordillera_Stg_multiple_13_to_Cordillera_EDW_ITEM_GROUP_map|Loader Merge_ITEM_GRP
14552 10512 DBS-070404 16/07/2011 23:21:40 SQL submitted to ODBC data source <EDW_V_CDR_DV_I_BASE> resulted in error <[Teradata][ODBC Teradata Driver][Teradata Database]
14552 10512 DBS-070404 16/07/2011 23:21:40 Secondary index uniqueness violation in EDW_D_CDR_DV_WKY_REF_N_01.ITEM_GRP. >. The SQL submitted is <INSERT INTO
14552 10512 DBS-070404 16/07/2011 23:21:40 “EDW_V_CDR_DV_I_BASE”.“ITEM_GRP” (“ITEM_GRP_ID”, “DESC_LANG_CD”, “ITEM_GRP_TYP_CD”, “ITEM_GRP_DESC”, “ITEM_GRP_NM”,
14552 10512 DBS-070404 16/07/2011 23:21:40 “ITEM_HIER_LVL_NUM”, “SRC_SYS_CD”, “WHS_LD_TMST”)
14552 10512 DBS-070404 16/07/2011 23:21:40 VALUES (‘14HV’, ‘ENG’, ‘SPKFR’, ‘SUNSILK HAIR SPRAY BASE 198G’, NULL, 12, NULL, NULL)
14552 10512 DBS-070404 16/07/2011 23:21:40 >.
14552 10512 RUN-051005 16/07/2011 23:21:40 |Data flow DF_Cordillera_Stg_multiple_13_to_Cordillera_EDW_ITEM_GROUP_map|Loader Merge_ITEM_GRP
14552 10512 RUN-051005 16/07/2011 23:21:40 Execution of for target <ITEM_GRP> failed. Possible causes: (1) Error in the SQL syntax; (2) Database
14552 10512 RUN-051005 16/07/2011 23:21:40 connection is broken; (3) Database related errors such as transaction log is full, etc.; (4) The user defined in the datastore
14552 10512 RUN-051005 16/07/2011 23:21:40 has insufficient privileges to execute the SQL. If the error is for preload or postload operation, or if it is for regular load
14552 10512 RUN-051005 16/07/2011 23:21:40 operation and load triggers are defined, check the SQL. Otherwise, for (3) and (4), contact your local DBA.
paul.bods (BOB member since 2011-06-29)
(BOB member since 2004-12-17)