Oracle Database Errors or Warnings from Error ORA-36027 to ORA-36162

SQLServerF1

ORA-36027: (XSHIERCK08) Hierarchy workspace object is not balanced.
Cause: The current hierarchy was not balanced.
Action: Change the hierarchy to balanced.
ORA-36028: (XSHIERCK09) Hierarchy workspace object has multiple paths from number to number.
Cause: The current hierarchy had multiple paths.
Action: Remove multiple paths from the hierarchy.
ORA-36034: (XSMHIERCK00) One or more loops have been detected in relationship workspace object over workspace object. The last number of the items are number.
Cause: A relation was used that had loops in it. There were more items involved than could be reported.
Action: Correct the relation so that it does not contain loops.

ORA-36035: (XSMHIERCKREL) One or more loops have been detected in workspace object. number items involved are number.
Cause: A relation was used that had loops in it.
Action: Correct the relation so that it does not contain loops.
ORA-36036: (XSMHIERCK01) One or more loops have been detected in relationship workspace object over workspace object. The number items involved are number.
Cause: A relation was used that had loops in it.
Action: Correct the relation so that it does not contain loops.
ORA-36154: (XSMXAGGR01) workspace object is not a data variable.
Cause: An object was specified on the Aggregate command line that was not a variable
Action: Specify a variable instead
ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
Cause: The user specified an illegal variable for use with FROM or FROMVAR on the AGGREGATE command line
Action: Specify a legal variable instead

ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
Cause: The user specified AUTOCOMMIT but not AUTOUPDATE on the AGGREGATE command line, which is illegal
Action: Either also specify AUTOUPDATE or don’t specify AUTOCOMMIT
ORA-36160: (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
Cause: The user tried to run the AGGREGATE or AGGCOUNT command or function on a scalar variable.
Action: Specify a dimensioned variable instead
ORA-36161: (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.
Cause: The user specified the same variable as both an aggregation variable and a COUNTVAR
Action: Specify a different COUNTVAR
ORA-36162: (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.
Cause: The user specified a non-INTEGER variable as a COUNTVAR for aggregation
Action: Redefine the COUNTVAR to be an INTEGER

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