Analytics Software

Hi experts,

One of the tasks in DAC failed. here are the details

ORA-00001: unique constraint (WEDW.W_DUAL_G_P1) violated

Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO W_DUAL_G(DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,ROW_WID,X) VALUES ( ?, ?, ?, ?, ?)
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_DUAL_G(DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,ROW_WID,X) VALUES ( ?, ?, ?, ?, ?)
WRITER_1_*_1> CMN_1761 Timestamp Event: [Wed Apr 29 22:52:15 2009]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Wed Apr 29 22:52:15 2009]
WRITER_1_*_1> WRT_8114
Row # [1] in bad file

WRITER_1_*_1> CMN_1053 : Rowdata: ( RowType=0(insert) Src Rowid=1 Targ Rowid=1
DATASOURCE_NUM_ID (DATASOURCE_NUM_ID:Double:): "1.000000000000000"
ETL_PROC_WID (ETL_PROC_WID:Double:): "1.000000000000000"
INTEGRATION_ID (INTEGRATION_ID:UniChar.30:): "1"
ROW_WID (ROW_WID:Double:): "1.000000000000000"
X (X:UniChar.15:): "1"
)

WRITER_1_*_1> WRT_8164 Error loading into target [W_DUAL_G] : Bad rows exceeded Session Threshold [1]
WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_DUAL_G, W_DUAL_G1, W_DUAL_G2, W_DUAL_G3] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Wed Apr 29 22:52:15 2009]




When i queried for the index name , it resulted as follows :

select * from dba_indexes where
table_name='W_DUAL_G';


Index_name - W_DUAL_G_P1
Table_name - W_DUAL_G
Uniqueness - UNIQUE


Could anyone suggest me how to proceed ?