Oracle Database Errors or Warnings from Error ORA-36912 to ORA-36950


ORA-36912: (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.
Cause: The aggmap contained a simultaneous model.
Action: Change the model definition so that it is no longer simultaneous.
ORA-36913: (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
Cause: The object refered to by the LOAD_STATUS clause of the aggmap wasn’t an undimensioned valueset over the related dimension
Action: Change the aggmap definition so that it doesn’t refer to an invalid object
ORA-36914: (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and its ancestor.
Cause: The LOAD_STATUS valueset is not allowed to contain both a dimension value and an ancestor of that value.
Action: Perform a limit remove ancestors on the valueset and confirm that the result matches the intended load.

ORA-36920: (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
Cause: The OLAP DML command would result in a named object becoming an anonymous object, but the object had one or more properties associated with it.
Action: Remove the properties using the PROPERTY command. In some cases an UPDATE may be required before the command can proceed.
ORA-36921: (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.
Cause: The OLAP DML command requires certain objects to be in the same analytic workspace, and the command string specified objects from two different analytic workspaces.
Action: If more than one analytic workspace is attached to the session, make sure that the object names given in the command are unique across all attached analytic workspaces. Use qualified object names (QON’s) if necessary.
ORA-36922: (XSVPMVTOPART03) workspace object is the target of an external partition of a partitioned variable.
Cause: An attempt was made to perform some prohibited operation on a variable which is itself a partition of some other variable.
Action: If desired, use the CHGDFN command to DROP the partition from the partitioned variable, and then run the command again.

ORA-36923: (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
Cause: The user ran a command that only operates on a LIST or RANGE partition template (or a variable dimensioned by a LIST or RANGE partition template) on some other kind of analytic workspace object.
Action: Rerun the command on a LIST or RANGE partition template or a variable dimensioned by a LIST or RANGE partition template.
ORA-36924: (XSVPMVTOPART05) workspace object is not in a COMPOSITE.
Cause: The OLAP DML command expected that the variable would be dimensioned by a composite containing the specified dimension, the specified dimension within a composite.
Action: Rerun the command on some variable is dimensioned by a composite containing the specified dimension.
ORA-36930: Cannot start a recursive call to Oracle OLAP because a ROLLBACK past an UPDATE to an attached analytic workspace has been performed.
Cause: ROLLBACK past the UPDATE of one of the attached Analytic Workspaces was called. A recursive Oracle OLAP call cannot be made until the control returns to the initial OLAP call and the affected Analytic Workspaces detached.
Action: Change the called SQL procedure to avoid the ROLLBACK
ORA-36950: (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
Cause: There are more than the maximum number of OFFSET or PERIODICITY values.
Action: Remove some of the values.

Above are list of Oracle Database Errors or Warnings from Error ORA-36912 to ORA-36950 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.

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 *