Forum Stats

  • 3,838,882 Users
  • 2,262,408 Discussions
  • 7,900,779 Comments

Discussions

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

Dattatray
Dattatray Member Posts: 538 Silver Badge
edited Oct 2, 2015 1:31AM in Financial Data Management

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()

pastedImage_13.png

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

This discussion has been closed.