Category Archives: ORA Database Error Messages

ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object

oracle

ORA-33998: (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object
Cause: The user attempted to include both a dimension and its surrogate in the DIMENSION statement of a model
Action: Use either the dimension or the surrogate in the DIMENSION statement of the model, but not both

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension

oracle

ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension
Cause: The user attempted to define a surrogate on a dimension that has type DAY, WEEK, MONTH, or YEAR
Action: Do not attempt to define a surrogate on this dimension

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER

oracle

ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER
Cause: The user attempted to define a surrogate without specifying a valid data type
Action: Specify the data type (ID, NTEXT, TEXT, NUMBER, or INTEGER) in the definition of the surrogate

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string

oracle

ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string
Cause: Not all kinds of dimensions can have surrogates. The user attempted to define a surrogate of a prohibited kind of dimension
Action: Do not attempt to define a surrogate on this dimension

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33911: (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string

oracle

ORA-33911: (MAKEDCL29) You cannot define a string in analytic workspace string because it has not been upgraded to version string
Cause: User attempted to define an object that requires a certain compatibility setting in an AW that has not been upgraded to that compatibility level
Action: Make sure that the database is running in the appropriate compatibility mode, and upgrade the AW

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target

oracle

ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target
Cause: User gave the TEMPORARY keyword in the definition of an external partition whose target variable was previously defined
Action: Any storage characteristics of the external partition are determined by the target variable. These attributes should be set when the target is defined, not when the external partition is defined

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33625: (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object

oracle

ORA-33625: (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object
Cause: User used the APPEND keyword on a CONCAT target in a FILEREAD, SQL FETCH or SQL SELECT command
Action: APPENDing a value to one of the CONCATs leaves automatically appends to the CONCAT

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33558: (LOCKCHECK01) The status or contents of the workspace object dimension cannot be changed while the LOCK_LANGUAGE_DIMS option is set to valuet

oracle

ORA-33558: (LOCKCHECK01) The status or contents of the workspace object dimension cannot be changed while the LOCK_LANGUAGE_DIMS option is set to valuet
Cause: A LIMIT or MAINTAIN was attempted on the named language dimension while the boolean option LOCK_LANGUAGE_DIMS was set to YES
Action: SET LOCK_LANGUAGE_DIMS to NO and retry the MAINTAIN or LIMIT

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33557: (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it

oracle

ORA-33557: (MAINTCHK01) You cannot string values of dimension workspace object during a loop over it
Cause: User tried to insert or delete a value of the specified dimension while some loop over that dimension was active. The loop could be an explicit FOR or ACROSS loop, or a natural expression evaluation or OLAP_TABLE loop. Also, it could be a loop over the dimension itself or over a derived dimension (like a composite or partition template) or dimension alias that includes it. The insert or delete could be explicitly caused by the MAINTAIN command. It is also possible that the user attempted to assign a value to a variable or partition dimensioned by a composite during a loop over that composite using a qualified data reference (QDR), and that the exception was generated by the engine's attempt to insert a new position in the composite to hold the new value
Action: Move the dimension maintenance or QDR-based variable assignment outside the dimension loop

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object

oracle

ORA-33468: (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object
Cause: When the compiled code was saved, the specified object was a surrogate of a certain dimension. Now the specified object is a surrogate of a different dimension
Action: No action needed; program automatically recompiles

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/