0 Replies Latest reply on Oct 2, 2015 5:31 AM by Dattatray

    FDMEE 11.1.2.4 : Error occurred while running Event Script (BefImport).

    Dattatray

      hello All,

       

       

      We have already integrated an EBS instance to HFM application on global context at ODI level. We are able to load data to HFM using this integration. There is a separate view out of ERP, in the same oracle database, which has some data which we require to pull in to the same HFM Application. For the same we are using Open Interface Adapter. We have configured the database source view using the same global context which we are using for EBS instance as both belong to the same server. Following is the BefImport Script we are using to specify the detail we require to pull data in to HFM:

       

       

       

       

      Also please note, this view has 4 value columns, Entered_Dr, Entered_Cr, Accounted_Dr, Accounted_CR. We are currently testing load trial with only one value column i.e, Accounted_Dr.

       

      While running the load rule, we are using Period Mapping Type as None. After executing the rule Please let us know it is resulting in error.

       

        Attaching the ERPIntegrator0.log. scrshot and execution error log file



      import java.sql as sql

      batchName = "Batch_" + str(fdmContext["LOCATION"])

       

      insertStmt = """

      INSERT INTO AIF_OPEN_INTERFACE (

      BATCH_NAME

      ,YEAR

      ,PERIOD

      ,COL02

      ,COL03

      ,COL04

      ,COL05

      ,COL06

      ,COL07

      ,COL08

      ,COL09

      ,COL10

      ,COL11

      ,AMOUNT

      ) VALUES (

      ?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      ,?

      )

      """

       

      sourceConn = sql.DriverManager.getConnection("jdbc:oracle:thin:@ABC.XYZ.com:1536:CRP2", "apps", "apps");

      # Limiting number of rows to 5 during the test runs.

      selectStmt = "SELECT PERIOD_YEAR,PERIOD_NAME,SEGMENT1,SEGMENT2,SEGMENT3,SEGMENT4,SEGMENT5,SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,ATTRIBUTE1,ACCOUNTED_DR FROM UG_GL_HFM_CCPRJ_DIMENTION_V WHERE ACCOUNTED_DR IS NOT NULL"

      stmt = sourceConn.prepareStatement(selectStmt)

      stmtRS = stmt.executeQuery()

       

      while(stmtRS.next()):

      params = [ batchName, stmtRS.getString("PERIOD_YEAR"),

      stmtRS.getString("PERIOD_NAME"),

      stmtRS.getString("SEGMENT1"),

      stmtRS.getString("SEGMENT2"),

      stmtRS.getString("SEGMENT3"),

      stmtRS.getString("SEGMENT4"),

      stmtRS.getString("SEGMENT5"),

      stmtRS.getString("SEGMENT6"),

      stmtRS.getString("SEGMENT7"),

      stmtRS.getString("SEGMENT8"),

      stmtRS.getString("SEGMENT9"),

      stmtRS.getString("ATTRIBUTE1"),

      stmtRS.getBigDecimal("ACCOUNTED_DR") ]

       

      fdmAPI.executeDML(insertStmt, params, False)

      fdmAPI.commitTransaction()

       

      stmtRS.close()

      stmt.close()

      sourceConn.close()

       

       

       

       

      from log file we can see entries

       

      2015-10-01 22:07:43,909 DEBUG [AIF]: CommData.getPovList - END

      2015-10-01 22:07:43,909 DEBUG [AIF]: CommData.updateWorkflow - START

      2015-10-01 22:07:43,909 DEBUG [AIF]:

          SELECT tlp.PROCESSSTATUS

          ,tlps.PROCESSSTATUSDESC

          ,CASE WHEN (tlp.INTLOCKSTATE = 60) THEN 'Y' ELSE 'N' END LOCK_FLAG

          FROM TLOGPROCESS tlp

          ,TLOGPROCESSSTATES tlps

          WHERE tlp.PARTITIONKEY = 6

          AND tlp.CATKEY = 1

          AND tlp.PERIODKEY = '2015-04-30'

          AND tlp.RULE_ID = 12

          AND tlps.PROCESSSTATUSKEY = tlp.PROCESSSTATUS

       

      2015-10-01 22:07:43,909 FATAL [AIF]: Error in CommData.updateWorkflow

      Traceback (most recent call last):

        File "<string>", line 2496, in updateWorkflow

      RuntimeError: The Current Process Status 'Import Error' is Invalid (LOC_OPENINT_PROJ ,GLOBAL, APR15, OPNRULE1)

       

      2015-10-01 22:07:43,909 FATAL [AIF]: Error in HfmData.loadData

      Traceback (most recent call last):

        File "<string>", line 34, in loadData

        File "<string>", line 2496, in updateWorkflow

      RuntimeError: The Current Process Status 'Import Error' is Invalid (LOC_OPENINT_PROJ ,GLOBAL, APR15, OPNRULE1)

       

      2015-10-01 22:07:43,909 DEBUG [AIF]: CommData.updateWorkflow - START

      2015-10-01 22:07:43,909 DEBUG [AIF]:

              UPDATE TLOGPROCESS

              SET PROCESSENDTIME = CURRENT_TIMESTAMP

              ,PROCESSSTATUS = 32

                ,PROCESSENTLOAD = 0

                ,PROCESSENTLOADNOTE = 'AIF_WF_LD_LOAD_ERR'

              WHERE PARTITIONKEY = 6 AND CATKEY = 1 AND PERIODKEY = '2015-04-30' AND RULE_ID = 12

           

      2015-10-01 22:07:43,925 DEBUG [AIF]: CommData.updateWorkflow - END