My Oracle Support Banner

Analysis Failing With Error "Duplicate dimensions in a tuple in function" When Using The Essbase As a Source (Doc ID 2858145.1)

Last updated on MARCH 30, 2022

Applies to:

Oracle Analytics Cloud - Classic - Version 106.3.0 and later
Oracle Analytics Cloud - Version 106.3.0 and later
Information in this document applies to any platform.

Symptoms

1. Analysis throwing below Error when running against the Essbase Database:

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid: hdashfdhfbhd, obis1]. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: Duplicate dimensions in a tuple in function [TUPLE CONSTRUCTOR] on line [22]:1200503 (HY000)

 2.Another scenario where the Analysis is returning the incorrect results when using Essbase as a Source.

Changes

 Patched to latest OAC version.

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.