3 Replies Latest reply on Nov 10, 2016 4:07 AM by Nishant Fukate

    FDMEE load issue

    847750

      Hi,

       

      I am seeing issue with FDMEE dataload which worked earlier.

       

      When I see the log, I do not see any error. when I compare the log with the log of successful data load, I see below;

       

      log which executed successfully

       

      2016-10-28 01:10:02,572 DEBUG [AIF]: Comm.updateProcessDetail - START

      2016-10-28 01:10:02,573 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'SUCCESS'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + 0

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('554565' IS NULL) THEN LAST_UPDATED_BY

            ELSE '554565'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 1662

          AND ENTITY_TYPE = 'PROCESS_BAL_IMP'

          AND ENTITY_NAME = 'Jan (JAN-2016)'

         

      2016-10-28 01:10:02,575 DEBUG [AIF]: Comm.updateProcessDetail - END

      2016-10-28 01:10:02,702 DEBUG [AIF]: CommData.postImportData - START

      2016-10-28 01:10:02,702 DEBUG [AIF]: CommData.getRuleInfo - START

      2016-10-28 01:10:02,702 DEBUG [AIF]:

              SELECT brl.RULE_ID, br.RULE_NAME, brl.PARTITIONKEY, brl.CATKEY, part.PARTVALGROUP, br.SOURCE_SYSTEM_ID, ss.SOURCE_SYSTEM_TYPE

       

       

      CommData.postImportData got started after updateProcessDetail...

       

      Log with error

       

      2016-11-06 19:48:31,098 DEBUG [AIF]: Comm.updateProcessDetail - START

      2016-11-06 19:48:31,100 DEBUG [AIF]:

          UPDATE AIF_PROCESS_DETAILS

          SET STATUS = 'FAILED'

          ,RECORDS_PROCESSED = CASE

            WHEN RECORDS_PROCESSED IS NULL THEN 0

            ELSE RECORDS_PROCESSED

          END + 0

          ,EXECUTION_END_TIME = CURRENT_TIMESTAMP

          ,LAST_UPDATED_BY = CASE

            WHEN ('554565' IS NULL) THEN LAST_UPDATED_BY

            ELSE '554565'

          END

          ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP

          WHERE PROCESS_ID = 1667

          AND ENTITY_TYPE = 'PROCESS_BAL_IMP'

          AND ENTITY_NAME = 'Jan (JAN-2016)'

         

      2016-11-06 19:48:31,104 DEBUG [AIF]: Comm.updateProcessDetail - END

      2016-11-06 19:48:31,352 INFO  [AIF]: FDMEE Process End, Process ID: 1667

       

       

      FDMEE process ended after 'updateProcessDetail - END' without going to the next steps.

       

      Below is the error in the xml log:

       

      ODI-1217: Session ERP_GL_LOAD_BALANCES_DATA (9501) fails with return code 7000. ODI-1226: Step Set Process Failure fails after 1 attempt(s). ODI-1232: Procedure COMM Update Process execution fails. Caused By: org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "<string>", line 3, in <module> RuntimeError at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146) at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322) at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2472) 

       

      any suggestions on this please...