Oracle Database Errors or Warnings from Error ORA-36965 to ORA-36975

SQLServerF1

ORA-36965: (XSRELTBL17) Invalid LEVELORDER valueset workspace object.
Cause: Invalid LEVELORDER valueset was specified.
Action: Specify a valid valueset.
ORA-36966: (XSRELTBL10) workspace object must be a dimension.
Cause: The qualified object must be a dimensions.
Action: Remove the named object from the QDR.
ORA-36967: (XSRELTBL18) Invalid INHIERARCHY valueset workspace object.
Cause: Invalid valueset was specified.
Action: Specify a valid valueset.

ORA-36968: (XSRELTBL11) Invalid relation workspace object.
Cause: Non-object or an object other than a RELATION was specified as source or destination.
Action: Specify RELATION objects.
ORA-36969: (XSRELTBL19) Merged family relation cannot take INHIERARCHY option.
Cause: INHIERARCHY option was specified.
Action: Remove INHIERARCHY option.
ORA-36970: (XSRELTBL12) workspace object must be a self-relation.
Cause: The specified source relation was not a self-relation.
Action: Specify a self-relation as the source.

ORA-36971: (XSRELTBL19) Merged family relation cannot take LEVELORDER option.
Cause: LEVELORDER option was specified.
Action: Remove LEVELORDER option.
ORA-36972: (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
Cause: Destination relation is not dimensioned by source relation dimension.
Action: Give a correct destination relation.
ORA-36974: (XSRELTBL14) workspace object is not a BOOLEAN variable dimensioned by all the dimensions of the hierarchy.
Cause: The named variable had either the wrong data type or the wrong dimensions.
Action: Specify a BOOLEAN variable dimensioned by all the dimensions of the hierarchy.
ORA-36975: (XSRELTBL15) You must specify a USING clause naming a relation with same level dimension as LEVELORDER valueset workspace object.
Cause: USING was omitted from the HIERHEIGHT command, or specified a relation containing values of a different dimension than the LEVELORDER valueset.
Action: Provide a USING clause naming a relation containing values from the correct level dimension. ————————————————————–

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