Category Archives: ORA Database Error Messages

ORA-36223: (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type

oracle

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

Back to previous menu

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

ORA-36222: (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object

oracle

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

Back to previous menu

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

ORA-36221: (XSLPDSC02) LIST number and LIST number have different base dimensions

oracle

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

Back to previous menu

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

ORA-36220: (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause

oracle

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

Back to previous menu

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

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

oracle

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

Back to previous menu

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

ORA-36210: (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string

oracle

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

Back to previous menu

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

ORA-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string

oracle

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

Back to previous menu

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

ORA-36206: (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST

oracle

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

Back to previous menu

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

ORA-36204: (XSAGOP04N) In AGGMAP workspace object, the NAOPERATOR string must be HFIRST, HLAST or HEVEN

oracle

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

Back to previous menu

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

ORA-36202: (XSAGOP01) ‘number’ is not a valid aggregation operator

oracle

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

Back to previous menu

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