Thursday, 7 June 2012

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

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

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)