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 NOVEMBER 03, 2023
Applies to:
Oracle Analytics Cloud - Classic - Version 106.3.0 and laterOracle 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)
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 |