Oracle Database Errors or Warnings from Error ORA-37117 to ORA-37128

SQLServerF1

ORA-37117: olapi history retention has been disabled
Cause: Under certain circumstances, for example, when the database is read only, olapi history retention is not possible because it requires updating persistent tables from time to time. If olapi history retention has been disabled, setting _olapi_history_retention parameter to true has no effect.
Action: Ensure that Oracle is properly installed with the OLAP option. If the RDBMS has been patched, review the patch log for errors. If the problem persists, report it to Oracle Customer Support.
ORA-37118: The OLAP API library was not preloaded.
Cause: In shared-server mode, the OLAP API library should be loaded during process initialization to ensure that the C++ virtual table addresses are identical in all shared-server processes. The OLAP API session was executing in a process in which the library had not been loaded.
Action: Set option _XSOLAPI_LOAD_AT_PROCESS_START to SHARED_SERVER or ALWAYS, restart the instance, and try again.
ORA-37119: Incompatible OLAP API library load address
Cause: The OLAP API session was executing in a process in which the OLAP API sharable library was loaded which was at a different address than the process in which the OLAP API session originated.
Action: Set option _XSOLAPI_LOAD_AT_PROCESS_START to ALWAYS, restart the instance, and try again.

ORA-37120: expression string is null
Cause: expression parser received a null string for syntax analysis.
Action: Prepare a non-null and well-formed MDX query string and try again.
ORA-37121: AW Spreadsheet invalidated
Cause: While this cursor was open, a command was issued that changed the underlying data to become inconsistent.
Action: Perform the query again, avoid performing dimension maintenance and cache clears during spreadsheet processing.
ORA-37122: AW Session cache disabled
Cause: A SQL Spreadsheet was attempted while the AW Session cache was disabled.
Action: Enable the session cache and perform the query again.

ORA-37123: (XSCCOMP17) Can not AGGREGATE workspace object(partition number) because it depends on unaggregated compressed partition number.
Cause: attempted to use a feature not supported by CC’s in the current AW format
Action: Remove the unsupported feature from the aggmap, or upgrade the AW
ORA-37124: (XSCCOMP16) COMPRESSED COMPOSITES with string are not supported in analytic workspace string because it has not been upgraded to version string.
Cause: attempted to use a feature not supported by CC’s in the current AW format
Action: Remove the unsupported feature from the aggmap, or upgrade the AW
ORA-37126: (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.
Cause: The user attempted to DEFINE a variable dimensioned by a COMPRESSED COMPOSITE, but that COMPRESSED COMPOSITE is already being used by another VARIABLE.
Action: Create a second COMPRESSED COMPOSITE for the second VARIABLE or add a measure dimension to the first variable.
ORA-37127: (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
Cause: The user attempted to DEFINE a variable dimensioned by a COMPRESSED COMPOSITE, but gave a slower varying dimension in the dimension list.
Action: Put the COMPRESSED COMPOSITE last in the dimension list when defining the VARIABLE.
ORA-37128: (XSCCOMP20) The partition template workspace object has already used the COMPRESSED COMPOSITE workspace object.
Cause: The COMPRESSED COMPOSITE specified for either a variable or partition template is already in use in another partition template.
Action: Define a different COMPRESSED COMPOSITE.

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