Category Archives: ORA Database Error Messages

ORA-36200: (XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight

oracle

ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight
Cause: The ARGS variable specified a weight even though one is not needed
Action: Modify the ARGS variable so that it does not specify a weight for that operation

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

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

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
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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36185: (XSAGGR11) workspace object does not have any AGGCOUNT information

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36181: A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/