Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-37129

(XSCCOMP04) %a workspace object workspace object
Cannot aggregate over COMPRESSED COMPOSITE %1p using AGGMAP %2p. 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.