0 Replies Latest reply on Jan 15, 2014 4:54 AM by Suman OTN

    Error occurred moving data from the transformation RECON_SEQ_GEN: to the transformation FILTRANS.

    Suman OTN

      Hi,

       

      Today one my task in the DAC Etl failed and when I opened the DAC log file of it. I saw the error description as below

       

      Error while contacting Informatica server for getting workflow status for PLP_SRC_WH_AP_Invoice_Reconciliation

      Error Code = 36331:Unknown reason for error code 36331

       

      Since there is no much information in DAC log file about the failure, I opened the PLP_SRC_WH_AP_Invoice_Reconciliation session log file.

       

      The error description in the session log file says.

       

      There is an error in the port [NEXTVAL]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error

      ... nl:ERROR(u:'transformation error')).

      2014-01-14 08:00:45 : ERROR : (582188 | TRANSF_1_1_1) : (IS | Oracle_BI_DW_Server) : node01_ : TT_11023 : An error occurred converting data in the port [NEXTVAL]. The row was dropped.

      2014-01-14 08:00:45 : ERROR : (582188 | TRANSF_1_1_1) : (IS | Oracle_BI_DW_Server) : node01_ : TT_11021 : An error occurred moving data from the transformation RECON_SEQ_GEN: to the transformation FILTRANS.

      2014-01-14 08:00:45 : ERROR : (582188 | TRANSF_1_1_1) : (IS | Oracle_BI_DW_Server) : node01 : CMN_1086 : RECON_SEQ_GEN: Number of errors exceeded threshold [1].

      2014-01-14 08:00:45 : INFO : (582188 | TRANSF_1_1_1) : (IS | Oracle_BI_DW_Server) : node01_ : CMN_1053 : : Rowdata: ( RowType=-4(error but dropped due to abort) Src Rowid=1186281 Targ Rowid=1186281

        NEXTVAL (ROW_WID:Int:): "(NULL)"

      )

       

      I am not sure of this error and I have never seen before. Can any one share some ideas on how to tackle this error and make the task execute successfully.

       

       

      Many Thanks.

      '