Oracle Database Errors or Warnings from Error ORA-36258 to ORA-36272


ORA-36258: (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.
Cause: The AGGMAPINFO function was called with an object that is not an AGGMAP.
Action: Modify the call to AGGMAPINFO to specify an AGGMAP object.
ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
Cause: In the partition creation / aggmap creation a situation developed such that when aggregating over a particular dimension of the aggmap a partition boundary was crossed such that the sparsity of the target partition included dimensions that were not in the sparsity of the source partition. Since the process of aggregation always densifies rather than sparsifying this is an extremely suboptimal design and it is not supported by the aggregate system.
Action: Set up your partitioning such that for any partition boundary the source and target partitions of the aggregation will always move towards denser partitions. For any child (c) and any parent (p) where (c) and (p) are in different partitions it must be the case that the parent partition contains no dimension in the composite that the child partition does not contain in its composite.
ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
Cause: The partitioning scheme was such that while aggregating there exists a cell (m) such that both one of its descendants and one of its ancestors are both in the referenced partition, while (m) is in a different partition.
Action: Change the partitioning scheme.

ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function
Cause: The AGGREGATION function was used outside of the MODEL context.
Action: Use AGGREGATION only in a model.
ORA-36267: (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
Cause: A dimension qualification was specified for a valueset with no dimensions.
Action: Remove the qualification.
ORA-36268: (XSCGMDLAGG01) ‘string’ is not a valid dimension value.
Cause: The AGGREGATION parameter list included a value that does not exist in the MODEL dimension that contains the target of the AGGREGATION
Action: Specify only values from the appropriate MODEL dimension
ORA-36269: (XSCGMDLAGG10) ‘workspace object’ does not exist or is not a dimension.
Cause: A nonexistent or invalid object was specified as a QDR dimension.
Action: Specify existing dimensions only.

ORA-36270: (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
Cause: One or more duplicate values appeared in the AGGREGATION parameter list.
Action: Remove the duplication.
ORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.
Cause: A QDR dimension was specified that does not appear in the valueset’s dimension list.
Action: Specify only dimensions in the valueset’s dimension list.
ORA-36272: (XSCGMDLAGG04) ‘workspace object’ is not a valid operator for the AGGREGATION function.
Cause: An invalid AGGREGATION operator was specified.
Action: Correct the invalid operator.

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