Oracle Database Errors or Warnings from Error ORA-37129 to ORA-37138

SQLServerF1

ORA-37129: (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
Cause: The AGGMAP was defined with a MODEL statement after a RELATION statement over a base of the COMPRESSED COMPOSITE.
Action: Change the AGGMAP so that the MODEL statements appear before the RELATION statements.
ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
Cause: A PRECOMPUTE clause was specified in the AGGMAP for a RELATION over a base of a COMPRESSED COMPOSITE, but AGGINDEX was ON
Action: Remove the PRECOMPUTE clause from the AGGMAP, or add AGGINDEX OFF
ORA-37131: (XSCCOMP06) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.
Cause: The user specified an aggregation OPERATOR that is not supported by COMPRESSED COMPOSITES.
Action: Use a MODEL for the calculation, or use an uncompressed COMPOSITE.

ORA-37132: (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
Cause: The status of the specified dimension did not include all detail cells.
Action: Add all detail cells to the status of the dimension and reissue the AGGREGATE command.
ORA-37133: (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
Cause: The user attempted to store a value into to a variable dimensioned by a compressed composite, and the variable had previously been precomputed using the AGGREGATE command. Once the AGGREGATE command is run on a variable dimensioned by a compressed composite, it becomes read-only until the computed values are removed with the CLEAR command.
Action: Run the CLEAR AGGREGATES command to remove the computed values from the variable and then rerun the failed operation. Note that CLEAR AGGREGATES will remove all the data computed during the last AGGREGATE command on this variable.
ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.
Cause: The user attempted to create a new position in a compressed composite, either directly (using MAINTAIN MERGE or MAINTAIN ADD) or by storing a value into the variable dimensioned by the compressed composite. This is not allowed when the variable has been precomputed using the AGGREGATE command. Once the AGGREGATE command is run on a variable dimensioned by a compressed composite, the compressed composite becomes read-only until the computed values are removed with the CLEAR command.
Action: Run the CLEAR AGGREGATES command to remove the computed values from the variable and then rerun the failed operation. Note that CLEAR AGGREGATES will remove all the data computed during the last AGGREGATE command on this variable.

ORA-37135: (XSCCOMP19) The COMPRESSED COMPOSITE workspace object in the current defined partition template should be unique or global.
Cause: The COMPRESSED COMPOSITE was neither unique nor global. Unique means each subpartition should have different COMPRESSED COMPOSITEs; Global means all subpartitions should use the same COMPRESSED COMPOSITE if they use any COMPRESSED COMPOSITE.
Action: Redefine the partition template.
ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.
Cause: The user ran ROLLUP on a variable dimensioned by a COMPRESSED COMPOSITE.
Action: Instead of using ROLLUP, generate an aggmap and use AGGREGATE
ORA-37137: (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
Cause: The user tried to CHGDFN a compressed composite
Action: If the change is desired then delete the old composite and create a new one.
ORA-37138: (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
Cause: The user tried to MAINTAIN DELETE from an aggregated COMPRESSED COMPOSITE.
Action: In order to perform this sort of maintenance the composite must first be cleared. This can be done by running the CLEAR AGGREGATES command on the variable dimensioning the composite. Note that this will remove all data computed during the last AGGREGATE command.

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