Oracle Database Errors or Warnings from Error ORA-36988 to ORA-36997


ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
Cause: The related dimension of the destination relation has the wrong data type.
Action: Redefine the destination relation or choose another relation whose related dimension is of type NUMBER.
ORA-36989: (XSRELGID23) GROUPSET and ROLLUP options in GROUPINGID require the destination relation.
Cause: Either variable or surrrogate dimension was specified as destination.
Action: Specify the destination relation.
ORA-36990: (XSRELGID07) The level relation workspace object should be dimensioned by a level dimension.
Cause: The level relation is not dimensioned by a level dimension.
Action: Redefine the level relation or choose another relation with the correct dimensionality.

ORA-36991: (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
Cause: There is a conflict between the hierarchy/level relation and the level order valueset.
Action: Choose objects that do not conflict.
ORA-36992: (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.
Cause: A level relation was not specified.
Action: Specify a level relation.
ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.
Cause: not a surrogate dimension, or the surrogate dimension is not based on the level dimension.
Action: modify/change the surrogate dimension.

ORA-36994: (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
Cause: The surrogate dimension is not numeric
Action: Change the surrogate dimension as numeric
ORA-36995: (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
Cause: more than 1 hierarchies in the current computing scope.
Action: use inhierarchy to limit
ORA-36996: (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.
Cause: Valueset doesn’t match the dimension
Action: Change the valueset’s dimension
ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
Cause: no level relation exists with level order valueset.
Action: provide the level relation.

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