Check Rule Fail forShared Entities with Error"Essbase Error(XXXXXXX): Cannot uniquely identify a member, the name [XXXX] is duplicated" (Doc ID 2320195.1)

Last updated on SEPTEMBER 07, 2024

Applies to:

Symptoms

While executing a dataload using Data Management , the check report shows lookup error, after downloading the log there is a line saying
Cannot execute report. Essbase Error(XXXXX): Cannot uniquely identify a member, the name [XXXXX] is duplicated

++ In Data Management Process log having below entries

INFO [AIF]: ***** Check Initialization - BEGIN *****
INFO [AIF]: Connection established to FDMEE database.
INFO [AIF]: Init Data Key - 1240001
INFO [AIF]: Jython Operations Initialization Completed.
INFO [AIF]: Check Report Precision Value - 2
INFO [AIF]: ***** Check Initialization - END ***** INFO [AIF]: ******** Check Execution - BEGIN ********
INFO [AIF]: Connection established to Essbase.
INFO [AIF]: ------------------- Execution for Entity : XXXXX - BEGIN -------------------
INFO [AIF]: ------------------- Execution for Account : ACTIVO - BEGIN -------------------
INFO [AIF]: ******************* Condition Logic - BEGIN *******************
INFO [AIF]: Error occurred due to specified intersection.
ERROR [AIF]: Cannot execute report. Essbase Error(XXXXX): Cannot uniquely identify a member, the name [XXXXX] is duplicated
INFO [AIF]: Data from Target: LOOKUP_ERROR
INFO [AIF]: ******************* Condition Logic - END *******************

INFO [AIF]: Error occurred during Check Process.
ERROR [AIF]:
INFO [AIF]: Disconnected from FDMEE database.
INFO [AIF]: Disconnected from Essbase.
INFO [AIF]: ******** Check Execution - END ********
INFO [AIF]: [checkData:124,Dec-16] END (false)
FATAL [AIF]: Error in CommData.checkData
Traceback (most recent call last):
File "<string>", line 4407, in checkData
RuntimeError: false

++ In AIF_WEBAPP.log

[EPMServer0] [ERROR] [] [oracle.apps.erpi.model] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: XXX] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.validation.model.util.impl.CheckEssbase] [SRC_METHOD: getCellData] Cannot execute report. Essbase Error(1060200): Cannot uniquely identify a member, the name [URU060] is duplicated[[
com.essbase.api.base.EssException: Cannot execute report. Essbase Error(XXXXX): Cannot uniquely identify a member, the name [XXXX] is duplicated

[EPMServer0] [ERROR] [] [oracle.apps.erpi.model] [tid: [ACTIVE].ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: XXXXX] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.webservices.HPLService] [SRC_METHOD: checkData] [[
java.lang.NullPointerException

[EPMServer0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: XXXX] [ecid:XXXXX] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [SRC_METHOD: invoke_odi_process] pid:143, Extract id:24501, status:Session Failed :24501 : ODI-1217: Session COMM_LOAD_BALANCES (24501) fails with return code 7000.[[
ODI-1226: Step FAILED - Check Data fails after 1 attempt(s).
ODI-1232: Procedure COMM Finalize Process execution fails.

Changes

Cause

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