Oracle Error Message
ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
Reason for the Error
The user attempted to CLEAR an AGGMAP using a directive other than CACHE.
Solution
Amend the CLEAR line to only use the CACHE keyword with AGGMAPs.