EPMFDM-140093: Cannot Regenerate The Scenario Error Occurred While Data Import From Open Interface Tables.

(Doc ID 2361992.1)

Last updated on FEBRUARY 20, 2018

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version, Integration

Data import step was failing without extracting data records from interface tables. 


ERPIntegrator0.log from the location [ORACLE_MIDDLEWARE_HOME]/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs

[2018-02-12T11:52:12.397-05:00] [ErpIntegrator0] [ERROR] [EPMFDM-140093] [oracle.apps.erpi.model] [tid: 34] [userId: <anonymous>] [ecid: 00iktnvcBmcDoY1LruO5yY00019k000O0l,0:1] [APP: AIF#] [URI: /aif/faces/mainPage] [SRC_CLASS: com.hyperion.aif.odi.common.util.OdiUtils] 

[SRC_METHOD: modifySourceAdapterPackage] Cannot regenerate the scenario as another Data Rule process (Process ID {0}) using this import format is in running state.[[ java.lang.Exception: EPMFDM-140093:Cannot regenerate the scenario as another Data Rule process (Process ID {0}) using this import format is in running state.
at com.hyperion.aif.odi.common.util.OdiUtils.modifySourceAdapterPackage(OdiUtils.java:208) 


ODIAgent.log from the location [ORACLE_MIDDLEWARE_HOME]/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/oracledi

[2018-02-13T02:07:02.327-05:00] [ErpIntegrator0] [ERROR] [ODI-1134] [] [tid: 96] [userId: <anonymous>] [ecid: 0000M6DzBvmDoY1Lru4EyY1QVPpa00000Z,1:31120] 

[APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1217: Session COMM_LOAD_BALANCES (41501) fails with return code 7000. Caused by: ODI-1226: Step FAILED - Import Data fails after 1 attempt(s).[[ 
ODI-1217: Session COMM_LOAD_BALANCES (41501) fails with return code 7000. 
ODI-1226: Step FAILED - Import Data fails after 1 attempt(s). 
ODI-1232: Procedure COMM Finalize Process execution fails. 
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last): 
  File "<string>", line 10, in <module> 
  File "<string>", line 162, in finalizeProcess 
RuntimeError: ODI-1226: Step Launch GL Load Balances Data fails after 1 attempt(s). 
ODI-1241: Oracle Data Integrator tool execution fails. 
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53)


 Migrated to new Version of from


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms