Oracle Error ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

Oracle 4 Views 1 Min Read

Oracle Error Message

ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

Reason for the Error

A value cannot be added to a dimension if it conflicts with an existing value in a unique concat dimension containing this dimension.

Solution

The concat(s) causing the conflict could be CHGDFNed to NOT UNIQUE, or either of the duplicate values could be renamed to make them UNIQUE.

Tags: