ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies
encountered while processing a composite dimension in
AGGREGATE caused a counter overflow.



ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite di..

Answer / guest

Cause: The depth of the hierarchies that are part of a
composite exceeded 4 billion levels during the merge.

Action: Reduce the number of levels in the hierarchies,
reduce the number of dimensions in the composite, or do not
aggregate over all dimensions at once.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMG-02011: 2FF11 - unsupported image format conversion specified

1 Answers  


ORA-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.

1 Answers  


RMAN-06115: changed backup piece available

1 Answers  


PCC-02138: CMD-LINE: Internal consistency error

1 Answers  


ORA-00203: using the wrong controlfiles

1 Answers  






ORA-15004: alias "string" does not exist

1 Answers  


ORA-32322: PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs

1 Answers  


ORA-21526: initialization failed

1 Answers  


ORA-39951: incomplete values specified for PL/SQL warning settings

1 Answers  


ORA-06504: PL/SQL: Return types of Result Set variables or query do not match

1 Answers  


DRG-10206: failed to perform recovery for a server or client

1 Answers  


RMAN-00567: Recovery Manager could not print some error messages

1 Answers  


Categories