Oracle Database Errors or Warnings from Error ORA-36405 to ORA-36620

SQLServerF1

ORA-36405: (XSSPROP05) Property ignored for object workspace object:
Cause: A property was ignored during import.
Action: Refer to the message that follows this one and correct the error it describes.
ORA-36406: (VCACHE00) ‘number’ is an invalid value for the VARCACHE option. The only permissible values are ‘SESSION’, ‘VARIABLE’, and ‘NONE’.
Cause: The user tried to assign an invalid value to the VARCACHE option
Action: Assign one of the valid values
ORA-36410: (VCACHE03) ‘number’ is an invalid value for the $VARCACHE property. The only permissible values are ‘DEFAULT’, ‘SESSION’, ‘VARIABLE’, and ‘NONE’.
Cause: The user tried to assign an invalid value to the $VARCACHE property on a variable
Action: Assign one of the valid values

ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.
Cause: The depth of the hierarchies that are part of a composite exceeded 4 billion levels during the merge.
Action: Reduce the number of levels in the hierarchies, reduce the number of dimensions in the composite, or do not aggregate over all dimensions at once.
ORA-36610: (XSLMS00) Unable to locate a message file for OLAP message: value
Cause: An internal OLAP DML program in the EXPRESS Analytic Workspace failed to retrieve a user message.
Action: Contact support.
ORA-36612: (XSLMS01) invalid OLAP message number: value
Cause: An internal OLAP DML program in the EXPRESS Analytic Workspace attempted to retrieve a non-existent message.
Action: Contact support.

ORA-36616: (XSAGMODHIER01) There is a cycle formed by MODEL workspace object and other embedded or containing models with the same dimension, workspace object.
Cause: Inclusion of a dynamic model formed a cycle in the named dimension.
Action: Edit the models involving this dimension to remove the cycle.
ORA-36617: (XSAGMODHIER02) There is a self-cycle equation in MODEL workspace object.
Cause: The model for relation modification included a self-cycle equation.
Action: Remove the self-cycle equation from the model.
ORA-36618: (XSAGMODDIM00) workspace object is not a valid dynamic model for AGGMAP.
Cause: The model failed one of the following tests: 1) only one dimension (aside from LAG/LEAD dimensions); 2) assignment to dimension values only; 3) a single simple solution block; 4) no time-series functions with variable step values.
Action: Edit the model so that it conforms to the above requirements.
ORA-36620: (XSAGMODDIM01) MODEL workspace object cannot find the matching embedded model.
Cause: AGGMAP ADD model could not find the matching embedded model.
Action: Add the matching embedded model to the AGGMAP.

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

Thanks,
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 *