Oracle Database Errors or Warnings from Error ORA-36181 to ORA-36204


ORA-36181: A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
Cause: The user attempted to add both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties to a single variable.
Action: Remove the existing property before applying the new one.
ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
Cause: A measure dimension was supplied in the AGGMAP, but a position for the variable was not found in it.
Action: Add a position for the variable in the measure dimension.
ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
Cause: The user lacked the permissions necessary for the aggregation variable.
Action: Remove the restricting permissions from the variable or base dimension.

ORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information.
Cause: User attempted an operation (such as the AVERAGE aggregation operator or the AGGCOUNT function) that requires a variable to have AGGCOUNT information on a variable that does not.
Action: Define the variable using the WITH AGGCOUNT clause, or use the CHGDFN ADD AGGCOUNT command to enable AGGCOUNT for the variable.
ORA-36188: (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
Cause: Either someone improperly changed the COUNTVAR variable, or AGGREGATE has an error.
Action: Set the COUNTVAR variable to NA before starting AGGREGATE. If you previously set the COUNTVAR variable to NA, then contact Oracle OLAP technical support.
ORA-36198: (XSAGGR33) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because the operator variable with more than 1 line dimensions is not supported for bases of a COMPRESSED COMPOSITE.
Cause: The user specified an aggregation the operator variable with more than 1 line dimensions that is not supported by COMPRESSED COMPOSITES.
Action: Use a MODEL for the calculation, or use an uncompressed COMPOSITE.

ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
Cause: The given operator requires a WEIGHT specification, but the ARGS variable did not supply one.
Action: Modify the ARGS variable to specify a weight for the operation.
ORA-36201: (XSAGGR35) Cannot aggregate workspace object(partition workspace object) because the subpartition is itself partitioned.
Cause: Attempted to aggregate an intermediate partition of a variable with nested partitioning.
Action: rerun the aggregate command seperately for each ultimate partition or just for the variable as a whole
ORA-36202: (XSAGOP01) ‘number’ is not a valid aggregation operator.
Cause: An invalid string was provided for an aggregation operator.
Action: Check the spelling of the operator to make sure you are specifying a valid one.
ORA-36204: (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN.
Cause: An invalid NAOPERATOR was specified.
Action: Specify HFIRST, HLAST or HEVEN.

Above are list of Oracle Database Errors or Warnings from Error ORA-36181 to ORA-36204 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *