Oracle Database Errors or Warnings from Error ORA-36206 to ORA-36225

SQLServerF1

ORA-36206: (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
Cause: An invalid REMOPERATOR was specified.
Action: Specify one of the legal operators.
ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.
Cause: The user specified an NAOPERATOR when you were not using PROPORTIONAL or EVEN.
Action: Remove the NAOPERATOR clause from the RELATION line.
ORA-36210: (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
Cause: The user specified a REMOPERATOR without using PROPORTIONAL, EVEN, or HEVEN.
Action: Remove the REMOPERATOR clause from the RELATION line.

ORA-36212: (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
Cause: The user specified MIN, MAX, FLOOR, or CEILING when using an operator other than PROPORTIONAL.
Action: Remove the incorrect argument from the RELATION line.
ORA-36220: (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.
Cause: One of the dimension lists in the dimension loop descriptor had no base dimensions except those in the IGNORE list. This leaves no dimensions for looping over.
Action: Fix the dimension loop descriptor.
ORA-36221: (XSLPDSC02) LIST number and LIST number have different base dimensions.
Cause: The base dimensions of the dimension lists given in the loop descriptor do not match.
Action: Ensure that each dimension list has the same set of looping base dimensions. If necessary, use IGNORE within a lists to discard base dimensions that should not be looped.

ORA-36222: (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
Cause: An IGNORE or DENSE list in a dimension loop descriptor included the dimension twice, included two different valuesets of the dimension, or includes the dimension and a valueset of the dimension.
Action: Only use the dimension or a valueset of the dimension once in an IGNORE or DENSE list.
ORA-36223: (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
Cause: An IGNORE or DENSE list in a dimension loop descriptor included and object that was not a dimension or a valueset, was a conjoint dimension, or was a dimensioned valueset.
Action: Only use simple dimensions and undimensioned valuesets in the IGNORE or DENSE list.
ORA-36224: (XSLPDSC05) workspace object is not a loop dimension
Cause: An IGNORE or DENSE list in a dimension loop descriptor referenced a dimension (or a valueset of a dimension) that was not a base dimension of the loop dimension list.
Action: Remove the dimension or valueset from the IGNORE or DENSE list.
ORA-36225: (XSLPDSC06) A LOOP AGGMAP list must contain an aggmap object, followed by one or more variables and/or dimensions.
Cause: An invalid AGGMAP list was specified. Either to few objects were specified, or an incorrect type of object was used.
Action: Specify a valid AGGMAP list consisting of an aggmap object, followed by one or more variables and/or dimensions.

Above are list of Oracle Database Errors or Warnings from Error ORA-36206 to ORA-36225 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 *