Oracle Database Errors or Warnings from Error ORA-36164 to ORA-36180

SQLServerF1

ORA-36164: (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
Cause: The user specified a COUNTVAR clause to the AGGREGATE command, but the number of COUNTVAR variables specified did not match the number of variables to be aggregated
Action: Specify a separate COUNTVAR for each variable
ORA-36165: (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
Cause: An attempt was made to add the $COUNTVAR property to a variable which already had an AGGCOUNT, or vice versa.
Action: Delete the already existing $COUNTVAR property or AGGCOUNT first.
ORA-36166: (XSMXAGGR08) workspace object is not a VARIABLE.
Cause: An attempt was made to perform an AGGREGATE or other action on an object which is not a variable.
Action: Specify a variable instead.

ORA-36167: (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
Cause: The user attempted to aggregate a FORMULA using an AGGMAP that is not valid for aggregating FORMULAs. The AGGMAP must specify PRECOMPUTE(NA) for all relation lines and must not specify any caching.
Action: Correct the AGGMAP so it is legal for aggregating a FORMULA.
ORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
Cause: The user specified a COUNTVAR variable which is missing at least one dimension of the aggregation variable
Action: Specify a COUNTVAR variable which has at least as many base dimensions as the aggregation variable
ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.
Cause: The user specified a WEIGHT variable or formula which wasn’t numeric or boolean
Action: Specify a numerical or boolean weight instead

ORA-36174: (XSMXAGGR23) workspace object must be either a VARIABLE, a RELATION or a FORMULA.
Cause: The user specified something that was not a variable, a relation or a formula as a weight for AGGREGATE
Action: Specify a valid variable, relation or formula instead
ORA-36176: (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
Cause: The user specified an illegal relation as a weight. The relation might have been multidimensional, not a self-relation, or not a relation over one of the bases of the aggregation variable.
Action: Specify a valid self relation over one of the bases of the aggregation variable.
ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.
Cause: The user used the ALLOCMAP command to define the AGGMAP, so the AGGMAP can only be used with the ALLOCATE command, or the AGGMAP has no contents attached to it.
Action: Use the AGGMAP command to define the AGGMAP.
ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
Cause: The user used the AGGREGATE command without specifying an AGGMAP on the command line, with a variable which had no $AGGMAP property.
Action: Specify an AGGMAP on the AGGREGATE command line, or add the $AGGMAP property to the variable in question.
ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
Cause: When using AGGREGATE, only simple permissions and permissions on base dimensions are valid.
Action: Remove the permissions clause from the variable causing problems.

Above are list of Oracle Database Errors or Warnings from Error ORA-36164 to ORA-36180 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.

Thanks,
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 *