Oracle Database Errors or Warnings from Error ORA-36639 to ORA-36652

SQLServerF1

ORA-36639: (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.
Cause: Unique concat base dimensions cannot contain duplicate values.
Action: Use MAINTAIN RENAME to change one of the duplicate values and retry.
ORA-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
Cause: Base dimensions of a unique concat must have TEXT or ID datatypes.
Action: None
ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.
Cause: The UNIQUE keyword was not specified in the concat dimension definition, and is required if any of its base dimensions contain custom member values.
Action: Define the concat as UNIQUE, or remove all base custom member values.

ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.
Cause: Duplicate concat leaf dimension was found.
Action: Remove duplicate concat base dimensions and retry.
ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
Cause: Only UNIQUE concat dimensions can have custom member values or base dimensions which contain custom member values.
Action: Remove all custom member values from the concat and all of its bases, and retry.
ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.
Cause: Concat dimension contains a previously detected leaf dimension.
Action: None

ORA-36646: (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
Cause: UNIQUE keyword was used with an invalid object.
Action: Retry without the UNIQUE keyword.
ORA-36648: (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
Cause: Attempt to change a concat dimension to UNIQUE, but it is already UNIQUE.
Action: None
ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
Cause: Unique concat base dimensions cannot contain duplicate values.
Action: Use MAINTAIN RENAME to change one of the duplicate values and retry.
ORA-36652: (XSDUNION11) workspace object is not a string type dimension.
Cause: The CHGDFN BASE ADD command is only valid for concat dimensions.
Action: None

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