Category Archives: ORA Database Error Messages

ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue

oracle

ORA-34164: (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue
Cause: A local relation or valueset has become invalid, most probably because an object used by the currently executing program has been deleted
Action: This is an internal error that should be referred to Oracle technical support

Back to previous menu

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

ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object

oracle

ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object
Cause: User used the APPEND keyword on a SURROGATE target in a FILEREAD, SQL FETCH or SQL SELECT command
Action: To assign a value to a SURROGATE in a FILEREAD, SQL FETCH or SQL SELECT command, use the ASSIGN keyword

Back to previous menu

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

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER

oracle

ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER
Cause: The user attempted to assign a value to a dimension surrogate whose data type is INTEGER. INTEGER surrogates, like INTEGER dimensions, cannot have values assigned to them. They can only be referenced by position
Action: Do not attempt to assign values to an INTEGER surrogate. Values will automatically appear and disappear from the INTEGER surrogate as positions are added to or removed from the underlying dimension

Back to previous menu

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

ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object

oracle

ORA-34141: (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object
Cause: User used the ASSIGN keyword on a DIMENSION target in a FILEREAD, SQL FETCH or SQL SELECT command
Action: To create a new dimension value in a FILEREAD, SQL FETCH or SQL SELECT command, use the APPEND keyword

Back to previous menu

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

ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions

oracle

ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions
Cause: Only UNIQUE concat dimensions can have custom member values
Action: Use the CHGDFN command to change the concat dimension to UNIQUE and retry

Back to previous menu

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

ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object

oracle

ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object
Cause: The user tried to apply MAINTAIN DELETE to a non-SESSION value
Action: Only use MAINTAIN DELETE to remove SESSION values from a concat dimension

Back to previous menu

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

ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object

oracle

ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object
Cause: User attempted to MAINTAINT ADD or DELETE a list value from a LIST partition template, but didn't specify which partition to add to or delete from
Action: Specify the partition: maintain (template) add to partition (partitionname) (values) or maintain (template) delete from partition (partitionname) (values)

Back to previous menu

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

ORA-34019: (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE

oracle

ORA-34019: (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE
Cause: User attempted to MAINTAINT ADD or DELETE a list value from a RANGE or CONCAT partition template
Action: Partitioning in a RANGE or CONCAT partition template cannot be changed using the MAINTAIN command

Back to previous menu

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

ORA-34001: (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension

oracle

ORA-34001: (MODCOMP14) Concat leaf dimension workspace object already is used in a DIMENSION statement, either explicitly or as a leaf of another concat dimension
Cause: Either two concat dimensions which share a common leaf dimension, or a concat and one of its leaves where both specified in the DIMENSION statement(s)
Action: Do not specify overlapping concat dimensions, or any leaves of specified concat dimensions

Back to previous menu

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

ORA-34000: (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object

oracle

ORA-34000: (MODCOMP13) You cannot use both workspace object and workspace object as model dimensions, because they are both surrogates of dimension workspace object
Cause: The user attempted to include two dimension surrogates of the same dimension in the DIMENSION statement of a model
Action: Use either of the two surrogates in the DIMENSION statement of the model, but not both

Back to previous menu

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