My Oracle Support Banner

Regenerate ODI Scenario for Open Interface Adopter fails with "An error occured" Post Database Migration (Doc ID 2606689.1)

Last updated on FEBRUARY 09, 2023

Applies to:

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


On: version, Performance

Post database migration to a New Server(Domain) and after the successful configuration of FMDEE pointing to the New Database, even though all the components in FDMEE  work fine, the users are unable to perform Regenerate ODI Scenario for "Open Interface Adopter". It fails with error "An error occurred"

Error in ErpIntegrator0.log:


[ErpIntegrator0] [NOTIFICATION] [ERPI-105011] [oracle.apps.erpi.model] [tid: 11] [userId: ] [ecid: 005_VfeGmtl99hH2uvFCFH0003kL00017^,0:1] [APP: AIF#] [URI: /aif/faces/mainPage] [SRC_CLASS: com.hyperion.aif.odi.common.util.OdiConstants] [SRC_METHOD: logDebugInfo] EPMERPI- Process id 424 already in progress

 Error in odiagent.og:


 [ErpIntegrator0] [ERROR] [ODI-1134] [] [tid: 31] [userId: <anonymous>] [ecid: 0000MsINTx_99hH2uvM6VH1ThYOu0000M7,1:22361] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1217: Session COMM_LOAD_BALANCES (16501) fails with return code 7000. Caused by: ODI-1226: Step FAILED - Import Data fails after 1 attempt(s).[[
ODI-1217: Session COMM_LOAD_BALANCES (16501) 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 13, 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.


 FDMEE database was migrated to a New Server(Domain) from an existing Domain


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.