Analytics Software

Hi Friends,

If any one guide me while Execute the Execution Plan in DAC. We are getting below error. Session run perfectly without failure but data not loaded into W_STATUS_D table.
Please check the below error.


LKPDP_4:TRANSF_1_1> DBG_21294 Lookup cache creation completed : (Tue Feb 26 04:08:49 2013)
LKPDP_4:TRANSF_1_1> CMN_1671 Created new cache files PMLKUP19115_262146_0_3595L32.[dat/idx] in directory /d02/informatica/server/infa_shared/Cache for Lookup [mplt_SIL_StatusDimension.Lkp_W_USER_D_Changed_By_Wid].
LKPDP_4:TRANSF_1_1> DBG_21641 mplt_SIL_StatusDimension.Lkp_W_USER_D_Changed_By_Wid: Index cache size = [1740800], Data cache size = [2097152]
LKPDP_4:TRANSF_1_1> DBG_21216 Finished transformations for Source Qualifier [mplt_SIL_StatusDimension.Lkp_W_USER_D_Changed_By_Wid{{DSQ}}]. Total errors [0]
TRANSF_1_1_1> DBG_21298 Existing cache created with override 'SELECT LOOKUP_TABLE.ROW_WID AS ROW_WID, LOOKUP_TABLE.DATASOURCE_NUM_ID AS DATASOURCE_NUM_ID, LOOKUP_TABLE.INTEGRATION_ID AS INTEGRATION_ID, LOOKUP_TABLE.EFFECTIVE_FROM_DT AS EFFECTIVE_FROM_DT, LOOKUP_TABLE.EFFECTIVE_TO_DT AS EFFECTIVE_TO_DT FROM W_USER_D LOOKUP_TABLE ORDER BY DATASOURCE_NUM_ID,INTEGRATION_ID,EFFECTIVE_FROM_DT,EFFECTIVE_TO_DT,ROW_WID' by lookup [mplt_SIL_StatusDimension.Lkp_W_USER_D_Changed_By_Wid] is re-used by lookup [mplt_SIL_StatusDimension.Lkp_W_USER_D_Created_By_Wid]

WRITER_1_*_1> WRT_8167 Start loading table [W_STATUS_D] at: Tue Feb 26 04:08:49 2013
TRANSF_1_1_1> DBG_21216 Finished transformations for Source Qualifier [Sq_W_STATUS_DS]. Total errors [0]
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Feb 26 04:08:49 2013]
WRITER_1_*_1> WRT_8229 Database errors occurred:
ORA-26002: Table DWH.W_STATUS_D has index defined upon it.

Database driver error...
Function Name : Prepare DPL
SQL Stmt : INSERT INTO W_STATUS_D(ROW_WID,W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,STATUS_DESC,SUBSTATUS_CODE,SUBSTATUS_NAME,SUBSTATUS_DESC,W_STATUS_CODE,W_STATUS_DESC,W_SUBSTATUS_CODE,W_SUBSTATUS_DESC,ACTIVE_FLG,CREATED_BY_WID,CHANGED_BY_WID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DELETE_FLG,W_INSERT_DT,W_UPDATE_DT,DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
Database driver error...
Function Name : Execute Multiple
SQL Stmt : INSERT INTO W_STATUS_D(ROW_WID,W_STATUS_CLASS,STATUS_CODE,STATUS_NAME,STATUS_DESC,SUBSTATUS_CODE,SUBSTATUS_NAME,SUBSTATUS_DESC,W_STATUS_CODE,W_STATUS_DESC,W_SUBSTATUS_CODE,W_SUBSTATUS_DESC,ACTIVE_FLG,CREATED_BY_WID,CHANGED_BY_WID,CREATED_ON_DT,CHANGED_ON_DT,AUX1_CHANGED_ON_DT,AUX2_CHANGED_ON_DT,AUX3_CHANGED_ON_DT,AUX4_CHANGED_ON_DT,DELETE_FLG,W_INSERT_DT,W_UPDATE_DT,DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,TENANT_ID,X_CUSTOM) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Oracle Fatal Error
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Feb 26 04:08:49 2013]
WRITER_1_*_1> WRT_8425 ERROR: Writer execution failed.
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Feb 26 04:08:49 2013]
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
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_STATUS_D] at end of load
WRITER_1_*_1> CMN_1761 Timestamp Event: [Tue Feb 26 04:08:49 2013]
WRITER_1_*_1> WRT_8081 Writer run terminated. [Error in loading data to target table [W_STATUS_D]]
WRITER_1_*_1> WRT_8168 End loading table [W_STATUS_D] at: Tue Feb 26 04:08:49 2013
WRITER_1_*_1> WRT_8035 Load complete time: Tue Feb 26 04:08:49 2013