Oracle Database Errors or Warnings from Error ORA-36621 to ORA-36638

SQLServerF1

ORA-36621: (XSAGMODDIM02) You cannot AGGREGATE the individual partition using static model workspace object because a partition dimension or its deriver workspace object appears in the equation of the step or simultaneous block.
Cause: An attempt was made to AGGREGATE the individual partition using the static model with the partition dimension in the equation of the step or simultaneous block.
Action: AGGREGATE the variable instead of the individual partition.
ORA-36622: (XSAGMODLIST00) workspace object cannot be added to the AGGMAP workspace object because it is not a valid MODEL.
Cause: An object specified in AGGMAP ADD was not a model.
Action: Specify the name of a model.
ORA-36626: (XSAGMODLIST02) MODEL workspace object was skipped because there is already a MODEL by that name attached to AGGMAP workspace object.
Cause: An attempt was made to add the same model to the AGGMAP twice.
Action: None required.

ORA-36628: (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
Cause: The dimension of the model did not match a hierarchy of the aggmap.
Action: Add a RELATION statement to the AGGMAP for that dimension.
ORA-36630: (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
Cause: An empty concat dimension list was specified.
Action: Specify a valid list of dimensions when defining a concat dimension.
ORA-36632: (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
Cause: Attempt was made to CHGDFN a concat, which is already non-unique, to NOT UNIQUE.
Action: Since the concat is already non-unique, this command is unnecessary.

ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
Cause: The user cannot specify INTEGER base dimensions when defining a concat dimension.
Action: Change the datatype of the INTEGER base dimension, or omit it from the concat.
ORA-36635: (XSDUNION03) The base dimension workspace object has an invalid datatype for use in a UNIQUE concat definition.
Cause: Base dimensions of a unique concat must have TEXT or ID datatypes.
Action: Specify a valid list of dimensions when defining a unique concat dimension.
ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
Cause: A non-unique concat dimension cannot be used as a base of a dependent unique concat.
Action: CHGDFN any dependent unique concat dimensions to NOT UNIQUE and retry.
ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.
Cause: A non-unique concat dimension cannot be used as a base of a dependent unique concat.
Action: CHGDFN any non-unique concat base dimensions to UNIQUE and retry.
ORA-36638: (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.
Cause: A non-unique concat dimension cannot be used as a base of a dependent unique concat.
Action: CHGDFN any non-unique concat base dimensions to UNIQUE and retry.

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