Oracle Database Errors or Warnings from Error ORA-36767 to ORA-36810


ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.
Cause: The specified AGGCOUNT variable had its own permissions distinct from those on the aggregation variable.
Action: Select a different AGGCOUNT variable, or remove the permissions. In some cases this may require an UPDATE before the command can succeed.
ORA-36768: (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
Cause: An AGGCOUNT variable was specified with different base dimensions than the aggregation variable.
Action: Select an AGGCOUNT variable with exactly the same base dimensions as the aggregation variable.
ORA-36778: (XSPGTRLOW) The amount of available temporary storage is still low. Free some temporary storage immediately. You can do so, for example, by UPDATING or DETACHING an analytic workspace.
Cause: Ran out of temporary tablespace storage.
Action: Increase the amount of temporary tablespace storage.

ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
Cause: Specified value for olap_page_pool_size out of range.
Action: None
ORA-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
Cause: The OLAP table function given used more than one LOOP statement.
Action: It is currently impossible to specify more than one LOOP composite, either remove one of the statements (and loop densely over relevant dimensions), or create a new composite that encompasses both loops and have a single loop statement refer to that.
ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
Cause: There is no limitmap on the table function and either the datamap does not contain a fetch, or it errored before the fetch was called.
Action: Check the datamap for errors, make sure that it executes a fetch statement, if it is not intended to execute the fetch then make sure that the table function has a valid limitmap.
ORA-36804: (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.
Cause: Invalid LIMITMAP syntax, or the name resolution failure of an ANALYTIC WORSKPACE OBJECT.
Action: Check the syntax of the limit map, check that the OLAP_TABLE function refers to a valid analytic workspace, check that all analytic workspace objects within the limitmap actually exist within the analytic workspace

ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.
Cause: The limitmap refers to a matching of ADT attribute to AW object, but the ADT attribute is not an element of the specified ADT table. Most commonly this is a typo.
Action: Add the attribute to the ADT, correct the LIMITMAP, or remove the reference from the LIMITMAP.
ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.
Cause: The limitmap has a levelrel clause which has a different number of values in the list to the right of the FROM than it has to the left.
Action: Change the limitmap so that there is a 1:1 mapping of adt and aw elements.
ORA-36810: (XSTBLFUNC05) Analytic workspace object number does not exist.
Cause: The limitmap refers to a non-existent aw object.
Action: Change the limitmap or define the object

Above are list of Oracle Database Errors or Warnings from Error ORA-36767 to ORA-36810 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 *