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

Last updated on JUNE 03, 2024

Applies to:

Symptoms

On: 11.1.2.3.700 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#11.1.2.0] [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.

Changes

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

Cause

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