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 DECEMBER 02, 2019

Applies to:

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

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

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
Symptoms
Changes
Cause
Solution
References


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