Oracle Solution for Error ora-36378

ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object

specified by your ARGS variable workspace object

must exist in the same analytic workspace as your AGGMAP workspace object

.

What triggered the Error:

While running AGGREGATE in threaded mode, you attempted to specify a WEIGHT variable in another analytic workspace.

What should we do to fix it:

Use a weight variable from the same analytic workspace as the aggmap and rollup variable.